CargosettlementController

目录

1、 CargosettlementController

1.1、 SelectProBalance

1.2、 listProBalant

1.3、 //查询结算明细数据

1.4、 //删除采购订单

1. CargosettlementController 

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 CargosettlementController : Controller

    {

        // GET: AccessoriessalesManagment/Cargosettlement

        QXQPEntities myModels = new Models.QXQPEntities();

1. 1. SelectProBalance

        public ActionResult SelectProBalance(BsgridPage bsgridPage/*, string ReceiptNum, string ToAudit*/)

        {

            var listProBalance = (from tbProBalance in myModels.PW_ProBalance

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

                                  join tbPaymen in myModels.SYS_Payment on tbProBalance.PaymentID equals tbPaymen.PaymentID

                                  select new ProBalanceVo

                                  {

                                      ProBalanceID = tbProBalance.ProBalanceID,

                                      SuppliersID = tbSuppli.SuppliersID,

                                      PaymentID = tbPaymen.PaymentID,

                                      SuppliersName = tbSuppli.SuppliersName.Trim(),

                                      SuppliersFirm = tbSuppli.SuppliersFirm.Trim(),

                                      Address = tbSuppli.Address.Trim(),

                                      OpenBank = tbSuppli.OpenBank.Trim(),

                                      TaxNumber = tbSuppli.TaxNumber.Trim(),

                                      PaymentName = tbPaymen.PaymentName,

                                      Receipt = tbProBalance.Receipt,

                                      AccountNumber = tbProBalance.AccountNumber != null ? tbProBalance.AccountNumber : "",

                                      ReceiptDates = tbProBalance.ReceiptDate.ToString(),

                                      ReceiptDate = tbProBalance.ReceiptDate,

                                      Operator = tbProBalance.Operator,

                                      CurrentMany = tbProBalance.CurrentMany,

                                      Auditor = tbProBalance.Auditor,

                                      AuditDates = tbProBalance.AuditDate.ToString(),

                                      AuditDate = tbProBalance.AuditDate,

                                      ToAudit = tbProBalance.ToAudit,

                                      Remark = tbProBalance.Remark != null ? tbProBalance.Remark : "",

                                  }).ToList();

            //if (!string.IsNullOrEmpty(ReceiptNum))

            //{

            //    listProBalance = listProBalance.Where(m => m.Receipt.Contains(ReceiptNum)).ToList();//单号查询

            //}

            //if (ToAudit == "1")

            //{

            //    listProBalance = listProBalance.Where(m => m.ToAudit == true).ToList();// 审核

            //}

            //else if (ToAudit == "2")

            //{

            //    listProBalance = listProBalance.Where(m => m.ToAudit == false).ToList();

            //}

            int count = listProBalance.Count();

            List<ProBalanceVo> listPro = listProBalance.Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();

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

            {

                success = true,

                totalRows = count,

                curPage = bsgridPage.curPage,

                data = listPro,

            };

            return Json(bsgrid, JsonRequestBehavior.AllowGet);

        }

1. 1. listProBalant

        public ActionResult listProBalant(List<PW_ProBalance>listProBalance, List<SYS_ProBalancetDetail> listProBalancetDetail)

        {

            Session["listProBalancetDetail"] = listProBalancetDetail;

            var ProBalanceID = 0;

            try

            {

                if (listProBalance[0].ProBalanceID == 0)

                {

                    myModels.PW_ProBalance.Add(listProBalance[0]);

                }

                else

                {

                    myModels.Entry(listProBalance[0]).State = System.Data.Entity.EntityState.Modified;

                }

                if (myModels.SaveChanges() > 0)

                {

                    ProBalanceID = listProBalance[0].ProBalanceID;

                    for (int i = 0; i < listProBalancetDetail.Count(); i++)

                    {

                        listProBalancetDetail[i].ProBalanceID = ProBalanceID;

                        var ProBalancetDetailID = listProBalancetDetail[i].ProBalancetDetailID;

                        if (ProBalancetDetailID == 0)

                        {

                            myModels.SYS_ProBalancetDetail.Add(listProBalancetDetail[i]);

                        }

                        else

                        {

                            myModels.Entry(listProBalancetDetail[i]).State = System.Data.Entity.EntityState.Modified;

                        }

                    }

                    myModels.SaveChanges();

                }

                else

                {

                    return Json(false, JsonRequestBehavior.AllowGet);

                }

            }

            catch (Exception)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

            return Json(ProBalanceID, JsonRequestBehavior.AllowGet);

        }

        public ActionResult SelectProBalanceDetail(int ProBalanceID)

1. 1. //查询结算明细数据

        {

            var listBalanDetail = (from tbProcurDetail in myModels.SYS_ProBalancetDetail

                                   join tbBalanceState in myModels.SYS_BalanceState on tbProcurDetail.BalanceStateID equals tbBalanceState.BalanceStateID

                                   join tbDocumentsType in myModels.SYS_DocumentsType on tbProcurDetail.DocumentsTypeID equals tbDocumentsType.DocumentsTypeID

                                   where tbProcurDetail.ProBalanceID == ProBalanceID

                                   select new ProBalatDetailVo

                                   {

                                       ProBalancetDetailID = tbProcurDetail.ProBalancetDetailID,

                                       BalanceStateID = tbBalanceState.BalanceStateID,

                                       DocumentsTypeID = tbDocumentsType.DocumentsTypeID,

                                       BalanceState = tbBalanceState.BalanceState,

                                       DocumentsType = tbDocumentsType.DocumentsType,

                                       ToCleared = tbProcurDetail.ToCleared,

                                       SingleNumber = tbProcurDetail.SingleNumber,

                                       DocumentsDates = tbProcurDetail.DocumentsDate.ToString(),

                                       DocumentsDate = tbProcurDetail.DocumentsDate,

                                       ShouldAmount = tbProcurDetail.ShouldAmount,

                                       PaidAmount = tbProcurDetail.PaidAmount,

                                       SuperioAmountr = tbProcurDetail.SuperioAmountr,

                                       ThisSuperioAmountr = tbProcurDetail.ThisSuperioAmountr,

                                       ThisShouldAmount = tbProcurDetail.ThisShouldAmount,

                                       Remark = tbProcurDetail.Remark,

                                   }).ToList();

            return Json(listBalanDetail, JsonRequestBehavior.AllowGet);

    }

        public ActionResult DeleteProBalance(int ProBalanceID)

1. 1. //删除采购订单

        {

            try

            {

                var listProcur = myModels.PW_ProBalance.Where(m => m.ProBalanceID == ProBalanceID).Single();

                var listproDetail = myModels.SYS_ProBalancetDetail.Where(m => m.ProBalanceID == ProBalanceID).ToList();

                myModels.PW_ProBalance.Remove(listProcur);

                myModels.SYS_ProBalancetDetail.RemoveRange(listproDetail);

                myModels.SaveChanges();

            }

            catch (Exception)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

            return Json(true, JsonRequestBehavior.AllowGet);

        }

    }

}