当前位置: 首页 > news >正文

CargosettlementController

目录

1、 CargosettlementController

1.1、 货商结算

1.1.1、 //登录用户

1.2、 结算单号

1.2.1、 //查询供应商账单

1.2.2、 //单号

1.2.3、 //单据日期

1.2.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. 货商结算

        public ActionResult Cargosettlement()//货商结算

        {

            try

            {

                ViewBag.UserName = Session["UserName"].ToString().Trim();

      1. //登录用户

                return View();

            }

            catch (Exception)

            {

                return Redirect("/Home/Login");

            }

        }

    1. 结算单号

        public ActionResult MaintenanceNum()//结算单号

        {

            string MaintenanceNum = "";

            var date = "P" + DateTime.Now.ToString("yyyyMMdd");

            try

            {

                var list = myModels.PW_ProBalance.Where(m => m.Receipt.Contains(date)).OrderBy(m => m.Receipt).ToList();

                if (list.Count != 0)

                {

                    int num = Convert.ToInt32(list.Last().Receipt.Trim().Substring(9)) + 1;

                    if (num < 10)

                    {

                        MaintenanceNum = date + "000" + num;

                    }

                    else if (num > 9 && num < 100)

                    {

                        MaintenanceNum = date + "00" + num;

                    }

                    else if (num > 99 && num < 1000)

                    {

                        MaintenanceNum = date + "0" + num;

                    }

                }

                else

                {

                    MaintenanceNum = date + "0001";

                }

            }

            catch (Exception)

            {

                return Json("", JsonRequestBehavior.AllowGet);

            }

            return Json(MaintenanceNum, JsonRequestBehavior.AllowGet);

        }

        public ActionResult SelectProBalancetDetail(int SuppliersID)

      1. //查询供应商账单

        {

            ArrayList list = new ArrayList();

            try

            {

                var listIncoming = (from tbIncoming in myModels.PW_Incoming

                                    join tbSuppliers in myModels.SYS_Suppliers on tbIncoming.SuppliersID equals tbSuppliers.SuppliersID

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

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

                                    where tbIncoming.SuppliersID == SuppliersID && tbBalanceState.BalanceStateID == 2 && tbIncoming.ToAudit == true

                                    select new GppVo

                                    {

                                        SingleNumber=tbIncoming.IncomingNumber,

      1. //单号

                                        DocumentsTypeID=tbDocumentsType.DocumentsTypeID,

                                        BalanceStateID = tbBalanceState.BalanceStateID,

                                        DocumentsDate = tbIncoming.BilDate.ToString(),

      1. //单据日期

                                        ShouldAmount = tbIncoming.Aamount.ToString(),//总金额

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

                                        BalanceState = tbBalanceState.BalanceState

      1. //付款状态

                                    }).ToList();

                var listReturnForm = (from tbReturnForm in myModels.PW_ReturnForm

                                      join tbSuppliers in myModels.SYS_Suppliers on tbReturnForm.SuppliersID equals tbSuppliers.SuppliersID

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

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

                                      where tbReturnForm.SuppliersID == SuppliersID && tbReturnForm.BalanceStateID == 2 && tbReturnForm.ToAudit == true

                                      select new GppVo

                                      {

                                          SingleNumber=tbReturnForm.ReturnNumber,//单号

                                          DocumentsTypeID = tbDocumentsType.DocumentsTypeID,

                                          BalanceStateID = tbBalanceState.BalanceStateID,

                                          DocumentsDate = tbReturnForm.SheetDate.ToString(),//单据日期

                                          ShouldAmount = tbReturnForm.Amount.ToString(),//总金额

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

                                          BalanceState = tbBalanceState.BalanceState//付款状态

                                      }).ToList();

                list.AddRange(listIncoming);

                list.AddRange(listReturnForm);

            }

            catch (Exception)

            {

                return Json("", JsonRequestBehavior.AllowGet);

            }

            return Json(list, JsonRequestBehavior.AllowGet);

        }


http://www.mrgr.cn/news/19586.html

相关文章:

  • css虚线边框可以调整间距实现
  • Git代码托管仓库01
  • 【C++基础】构造函数和他的初始化列表
  • PAT甲级(Advanced Level) 1001 A+B Format
  • jmeter使用——接口测试事知识点
  • 海康二次开发学习笔记13-从Group外部输入图像
  • opencv全面详解教程
  • 浅谈人工智能之基于AutoGen Studio+litellm+ollama构建model
  • 2024年【化工自动化控制仪表】考试资料及化工自动化控制仪表找解析
  • Vue2项目搭建:Vue2.7+Vite4+Pinia+TailwindCSS+Prettier+ESLint
  • 云计算之ECS
  • 一招制胜!掌握 Python 中pip的8个必备命令
  • MSP430F149实现0.96寸OLED显示
  • 编码(曼彻斯特编码,4B/5B 编码,8b/10b编码)
  • 解决Pynput不能在Ubuntu22.04上正常使用问题
  • 【LabVIEW学习篇 - 17】:人机交互界面设计01
  • 轻松上手 | 基于RockyLinux 9.4安装部署Zabbix 7.0
  • 2024年最强图纸加密软件大揭秘!图纸加密软件推荐
  • lvs DR模式调试
  • 【Fastapi】使用APIRouter做路由管理