CustomersettleController

目录

1、 CustomersettleController

1.1、 查询单据

1.1.1、 单据类型

1.1.2、 /单据日期

1.1.3、 单号(出库单号)

1.1.4、 结算状态(付款状况)

1. CustomersettleController 

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.ProcurementManagment.Controllers

{

    public class CustomersettleController : Controller

    {

        QXQPEntities myModels = new QXQPEntities();

1. 1. 查询单据

        public ActionResult Selectencipher(int SalesCustomerID)//查询单据

        {

           ArrayList lists = new ArrayList();

            try

            {

                var listOutbound = (from tbOutbound in myModels.PW_Outbound

                                      join tbSalesCustomer in myModels.SYS_SalesCustomer on tbOutbound.SalesCustomerID equals tbSalesCustomer.SalesCustomerID

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

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

                                      where tbOutbound.SalesCustomerID == SalesCustomerID && tbBalanceState.BalanceStateID == 2 && tbOutbound.Reviewwhet == true

                                    select new BingVo

                                    {

                                        DocumentsTypeID = tbDocumentsType.DocumentsTypeID,

                                        BalanceStateID = tbBalanceState.BalanceStateID,

                                        ReceipstType = tbDocumentsType.DocumentsType,//

1. 1. 1. 单据类型

                                        ReceipstDate = tbOutbound.OpenDate.ToString(),/

1. 1. 1. /单据日期                                  

                                        Oddnumbers = tbOutbound.Stockremoval,//

1. 1. 1. 单号(出库单号)

                                        Paymentstate = tbBalanceState.BalanceState, //

1. 1. 1. 结算状态(付款状况)

                                        Totalmoney = tbOutbound.Theamount.ToString(),//总金额                                     

                                    }).ToList();

                var listSalesReturnl = (from tbSalesReturnl in myModels.PW_SalesReturnl

                                        join tbSalesCustomer in myModels.SYS_SalesCustomer on tbSalesReturnl.SalesCustomerID equals tbSalesCustomer.SalesCustomerID

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

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

                                        where tbSalesReturnl.SalesCustomerID == SalesCustomerID && tbSalesReturnl.ToAudit == true && tbBalanceState.BalanceStateID == 2 || tbBalanceState.BalanceStateID == 3

                                        select new BingVo

                                        {

                                            DocumentsTypeID = tbDocumentsType.DocumentsTypeID,

                                            BalanceStateID = tbBalanceState.BalanceStateID,

                                            ReceipstType = tbDocumentsType.DocumentsType,//单据类型

                                            ReceipstDate = tbSalesReturnl.OpenDate.ToString(),//单据日期                                       

                                            Oddnumbers = tbSalesReturnl.Oddseats,//

单号(退货单号)

                                            Paymentstate = tbBalanceState.BalanceState,//结算状态(付款状况)

                                            Totalmoney = tbSalesReturnl.Theamount.ToString(),//总金额                                         

                                        }).ToList();

                lists.AddRange(listOutbound);

                lists.AddRange(listSalesReturnl);

            }

            catch (Exception)

            {

                return Json("", JsonRequestBehavior.AllowGet);

            }

           

            return Json(lists, JsonRequestBehavior.AllowGet);

        }