PurchaseorderController

目录

1、 PurchaseorderController

1.1、 //查询单据数据

1.1.1、 //判断是否为空？是，为本身；否，为0 。

1.1.2、 //单号查询

1.1.3、 //单据状况

1.1.4、 // 审核

1. PurchaseorderController 

using QXQPS.Models;

using QXQPS.Vo;

using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace QXQPS.Areas.AccessoriessalesManagment.Controllers

{

    public class PurchaseorderController : Controller

    {

        QXQPEntities myModels = new Models.QXQPEntities();

        // GET: AccessoriessalesManagment/Purchaseorder

1. 1. //查询单据数据

        {

            var listProcur = (from tbProcur in myModels.PW_Procurement

                              join tbSuppli in myModels.SYS_Suppliers on tbProcur.SuppliersID equals tbSuppli.SuppliersID

                              join tbWareho in myModels.SYS_Warehouse on tbProcur.WarehouseID equals tbWareho.WarehouseID

                              join tbUser in myModels.PW_User on tbProcur.UserID equals tbUser.UserID

                              select new ProcurementVo

                              {

                                  ProcurementID = tbProcur.ProcurementID,

                                  SuppliersID = tbSuppli.SuppliersID,

                                  WarehouseID = tbWareho.WarehouseID,

                                  UserID = tbUser.UserID,

                                  SuppliersName = tbSuppli.SuppliersName.Trim(),

                                  SuppliersFirm = tbSuppli.SuppliersFirm.Trim(),

                                  MakerDates = tbProcur.MakerDate.ToString(),

                                  MakerDate = tbProcur.MakerDate,

                                  Maker = tbProcur.Maker.Trim(),

                                  IndentNumber = tbProcur.IndentNumber,

                                  DeliveryDeadlines = tbProcur.DeliveryDeadline.ToString(),

                                  WarehouseName = tbWareho.WarehouseName.Trim(),

                                  Aamount = tbProcur.Aamount,

                                  Handsel = tbProcur.Handsel!=null? tbProcur.Handsel:0,

1. 1. 1. //判断是否为空？是，为本身；否，为0 。

                                  ToAudit = tbProcur.ToAudit,

                                  Documents=tbProcur.Documents,

                                  Auditer = tbProcur.Auditer.Trim(),

                                  AuditerDates = tbProcur.AuditerDate.ToString(),

                                  Remark = tbProcur.Remark.Trim(),

                              }).ToList();

            if (!string.IsNullOrEmpty(IndentNum))

            {

                listProcur = listProcur.Where(m => m.IndentNumber.Contains(IndentNum)).ToList();

1. 1. 1. //单号查询

            }

            if (!string.IsNullOrEmpty(Documents))

            {

                listProcur = listProcur.Where(m => m.Documents == Documents).ToList();

1. 1. 1. //单据状况

            }

            if (ToAudit == "1")

            {

                listProcur = listProcur.Where(m => m.ToAudit == true).ToList();

1. 1. 1. // 审核

            }

            else if (ToAudit == "2")

            {

                listProcur = listProcur.Where(m => m.ToAudit == false).ToList();

            }

            if (!string.IsNullOrEmpty(Dateone) && !string.IsNullOrEmpty(Datetow))//时间范围查询

            {

                DateTime Time1 = Convert.ToDateTime(Dateone);

                DateTime Time2 = Convert.ToDateTime(Datetow);

                listProcur = listProcur.Where(m => m.MakerDate >= Time1 && m.MakerDate <= Time2).ToList();

            }

            int count = listProcur.Count();

            List<ProcurementVo> listPro = listProcur.OrderBy(m => m.ToAudit).Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();

            Bsgrid<ProcurementVo> bsgrid = new Bsgrid<ProcurementVo>()

            {

                success = true,

                totalRows = count,

                curPage = bsgridPage.curPage,

                data = listPro,

            };

            return Json(bsgrid, JsonRequestBehavior.AllowGet);

        }