要料编辑

yangle

2022-04-26 f009f613071b3a35499fea1767805a35dca507ea

 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_Cg_PODemandPlanBillController.cs

File was renamed from WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/Cg_PODemandPlanBillController.cs
@@ -9,17 +9,17 @@

namespace WebAPI.Controllers.SCGL
{
    public class Cg_PODemandPlanBillController : ApiController
    public class JIT_Cg_PODemandPlanBillController : ApiController
    {
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        Cg_PODemandPlanBillMain omdelMian = new Cg_PODemandPlanBillMain();
        List<Cg_PODemandPlanBillSub> omodelsub = new List<Cg_PODemandPlanBillSub>();
        JIT_Cg_PODemandPlanBillMain omdelMian = new JIT_Cg_PODemandPlanBillMain();
        List<JIT_Cg_PODemandPlanBillSub> omodelsub = new List<JIT_Cg_PODemandPlanBillSub>();

        #region ææ–™è®¡åˆ’单 åˆ—表
        [Route("Cg_PODemandPlanBill/Cg_PODemandPlanBillList")]
        [Route("JIT_Cg_PODemandPlanBill/JIT_Cg_PODemandPlanBillList")]
        [HttpGet]
        public object Cg_PODemandPlanBillList(string sWhere, string user)
        {
@@ -55,7 +55,7 @@
        #endregion

        #region ææ–™è®¡åˆ’单  æ·»åŠ /修改
        [Route("Cg_PODemandPlanBill/AddPODemandPlanBillList")]
        [Route("JIT_Cg_PODemandPlanBill/AddPODemandPlanBillList")]
        [HttpPost]
        public object AddPODemandPlanBillList([FromBody] JObject sMainSub)
        {
@@ -101,14 +101,14 @@
                    return objJsonResult;
                }

                omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Cg_PODemandPlanBillMain>(msg2);
                omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<JIT_Cg_PODemandPlanBillMain>(msg2);
                string BillType = "4608";


                if (OperationType == 1)//新增
                {
                    //主表
                    oCN.RunProc("insert into Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
                    oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
                                 ",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
                                 ",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
                                 ",HRemark,HExplanation)" +
@@ -120,7 +120,7 @@
                else if (OperationType == 3)
                {
                    //修改
                    oCN.RunProc($"update  Cg_PODemandPlanBillMain set HUpDater='{omdelMian.HMaker}',HUpDateDate=GETDATE()" +
                    oCN.RunProc($"update  JIT_Cg_PODemandPlanBillMain set HDate='{omdelMian.HDate}',HUpDater='{omdelMian.HMaker}',HUpDateDate=GETDATE()" +
                                $",HSubORGID={omdelMian.HSubORGID},HAddress='{omdelMian.HAddress}',HPURCHASEORGID={omdelMian.HPURCHASEORGID}" +
                                $",HSupplierID={omdelMian.HSupplierID},HSettleCurrId={omdelMian.HSettleCurrId}" +
                                $",HRemark='{omdelMian.HRemark}',HExplanation='{omdelMian.HExplanation}' where HInterID={omdelMian.HInterID}");
@@ -159,16 +159,16 @@
                //获取表格数据
                ds = oCN.RunProcReturn($"select * from  h_v_JIT_Cg_PODemandPlanBillList where å•æ®å·='{omdelMian.HBillNo}'", "h_v_JIT_Cg_PODemandPlanBillList");
                //删除子表
                oCN.RunProc("delete from Cg_PODemandPlanBillSub where HInterID='" + omdelMian.HInterID.ToString() + "' and HEntryID='" + hentryid + "'");
                oCN.RunProc("delete from JIT_Cg_PODemandPlanBillSub where HInterID='" + omdelMian.HInterID.ToString() + "' and HEntryID='" + hentryid + "'");
            }


            omodelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Cg_PODemandPlanBillSub>>(msg3);
            omodelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<JIT_Cg_PODemandPlanBillSub>>(msg3);
            int i = 1;
            //插入子表
            foreach (Models.Cg_PODemandPlanBillSub oSub in omodelsub)
            foreach (Models.JIT_Cg_PODemandPlanBillSub oSub in omodelsub)
            {
                oCN.RunProc("insert into Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
                oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
                            ", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
                            ", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
                            ", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
@@ -199,7 +199,7 @@
        #endregion

        #region ææ–™è®¡åˆ’单 åˆ é™¤
        [Route("Cg_PODemandPlanBill/DelPODemandPlanBillList")]
        [Route("JIT_Cg_PODemandPlanBill/DelPODemandPlanBillList")]
        [HttpGet]
        public object DelPODemandPlanBillList(string HInterID, string HEntryID, string User)
        {
@@ -232,9 +232,9 @@

                    if (ds.Tables[0].Rows.Count == 1)
                    {
                        oCN.RunProc($"delete from Cg_PODemandPlanBillMain where HInterID={HInterID}");
                        oCN.RunProc($"delete from JIT_Cg_PODemandPlanBillMain where HInterID={HInterID}");
                    }
                    oCN.RunProc($"delete from Cg_PODemandPlanBillSub where HInterID={HInterID} and HEntryID={HEntryID}");
                    oCN.RunProc($"delete from JIT_Cg_PODemandPlanBillSub where HInterID={HInterID} and HEntryID={HEntryID}");

                    oCN.Commit();//结束事务

@@ -264,7 +264,7 @@
        #endregion

        #region ææ–™è®¡åˆ’单 å…³é—­
        [Route("Cg_PODemandPlanBill/ClosePODemandPlanBillList")]
        [Route("JIT_Cg_PODemandPlanBill/ClosePODemandPlanBillList")]
        [HttpGet]
        public object ClosePODemandPlanBillList(string HInterID, string User)
        {
@@ -295,7 +295,7 @@

                    oCN.BeginTran();//开启事务

                    oCN.RunProc($"update Cg_PODemandPlanBillMain set HBillStatus=3,HCloseMan='{User}',HCloseDate=getdate()   where HInterID={HInterID}");
                    oCN.RunProc($"update JIT_Cg_PODemandPlanBillMain set HBillStatus=3,HCloseMan='{User}',HCloseDate=getdate()   where HInterID={HInterID}");

                    oCN.Commit();//结束事务