智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenhaozhe
2025-10-19 c28f1d1e1475510ff37b58aa33416908220c529b 
 WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs


@@ -30,7 +30,7 @@


        public object sql { get; private set; }


        public object oCn { get; private set; }




        




        /// <summary>


        /// --返回收料通知单列表


        /// 外购入库单 1201


@@ -52,7 +52,7 @@


                else


                {


                    string sql1 = "select * from h_v_Kf_POStockInBillList where 1 = 1 ";


                    string sql = sql1 + sWhere+ " order by hmainid desc";


                    string sql = sql1 + sWhere + " order by hmainid desc";


                    ds = oCN.RunProcReturn(sql, "h_v_Kf_POStockInBillList");


                }


                foreach (DataColumn col in ds.Tables[0].Columns)//遍历ds中第一个表（Tables[0]）的所有列（Columns）每次循环中，col变量会持有当前列的引用


@@ -222,7 +222,7 @@








       




                string HInvoiceBillNo = mainList[0].HInvoiceBillNo;//发票编号 


                string HExplanation = mainList[0].HExplanation;//摘要


                string HInnerBillNo = mainList[0].HInnerBillNo;//内部单据号 


@@ -277,15 +277,15 @@


                    }


                    //=========================================================


                    //主表


                    String sql =$@"Insert Into Kf_ICStockBillMain 


                    String sql = $@"Insert Into Kf_ICStockBillMain 


                        (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus


                       ,HAddress,HSupID,HCurID,HWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID,HExplanation,HRemark


                        ,HInnerBillNo,HSTOCKORGID,HOWNERID,HMaker,HMakeDate,HProjectID,HInvoiceBillNo)


                        values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1201 + "','" +


                    HBillSubType + "','" + HDate + "','" + HBillNo + "','" + HBillStatus + "','" + HAddress +


                    "'," + HSupID + "," + HCurID + "," + HWHID + "," + HEmpID + "," + HManagerID + "," + 


                    HSecManagerID + ","+ HKeeperID +"," + HDeptID + ",'" + HExplanation + "','" + HRemark


                    + "','" + HInnerBillNo + "'," + HSTOCKORGID + "," + HOWNERID + ",'" + HMaker + "',getdate(),"+ HProjectID + ",'"+ HInvoiceBillNo + "')";


                    "'," + HSupID + "," + HCurID + "," + HWHID + "," + HEmpID + "," + HManagerID + "," +


                    HSecManagerID + "," + HKeeperID + "," + HDeptID + ",'" + HExplanation + "','" + HRemark


                    + "','" + HInnerBillNo + "'," + HSTOCKORGID + "," + HOWNERID + ",'" + HMaker + "',getdate()," + HProjectID + ",'" + HInvoiceBillNo + "')";




                    oCN.RunProc(sql);


                }


@@ -293,7 +293,7 @@


                { //修改




                    DataSet dss;


                    dss = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID , "h_v_Kf_POStockInBillList");


                    dss = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID, "h_v_Kf_POStockInBillList");


                    //判断是否可编辑


                    if (dss.Tables[0].Rows[0]["审核人"].ToString() != "" && dss.Tables[0].Rows[0]["审核人"] != null)


                    {


@@ -316,7 +316,7 @@


                                "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" + HBillNo + "'" +


                                 ",HSupID=" + HSupID + ",HCurID=" + HCurID + ",HSecManagerID=" + HSecManagerID + ", HSTOCKORGID=" + HSTOCKORGID + ",HKeeperID=" + HKeeperID + ",HWHID = " + HWHID


                                 + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HOWNERID=" + HOWNERID


                                 + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID="+ HProjectID + ",HInvoiceBillNo='"+ HInvoiceBillNo + "' where HInterID=" + HInterID;


                                 + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID=" + HProjectID + ",HInvoiceBillNo='" + HInvoiceBillNo + "' where HInterID=" + HInterID;




                    oCN.RunProc(sql);




@@ -388,7 +388,7 @@


            }


        }




        public json AddBillSub(string msg3, long HInterID, int OperationType,string user)


        public json AddBillSub(string msg3, long HInterID, int OperationType, string user)


        {


            List<ClsKf_ICStockBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillSub>>(msg3);




@@ -658,7 +658,7 @@


                return objJsonResult;


            }


        }


#endregion


        #endregion




        #region 根据物料内码获取物料信息


        [Route("Kf_POStockInBill/getMaterialByMaterID")]


@@ -808,7 +808,7 @@


                        return objJsonResult;


                    }


                    //==================================================================================                        


                    




                    //审核提交


                    if (oBill.CheckBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_POStockInBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


@@ -848,7 +848,7 @@


                        return objJsonResult;


                    }


                    //=========================================================                   


                 




                    //反审核提交AbandonCheck


                    if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_POStockInBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


@@ -1488,7 +1488,7 @@


        #region 采购入库 发起审批


        [Route("Kf_POStockInBill/StartCheckFlow_POOrderBill")]


        [HttpGet]


        public object StartCheckFlow_POOrderBill(int HInterID,string CurUserName)


        public object StartCheckFlow_POOrderBill(int HInterID, string CurUserName)


        {


            DBUtility.ClsPub.CurUserName = CurUserName;


            try


@@ -1519,7 +1519,7 @@


                DAL.ClsKf_POStockInBill oBill = new DAL.ClsKf_POStockInBill();                              //实例化单据操作类，用于进行相关操作




                //发起审批


                if (oBill.startCheckFlow(lngBillKey,ref DBUtility.ClsPub.sExeReturnInfo) == true)


                if (oBill.startCheckFlow(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


@@ -2102,10 +2102,11 @@


        public object Kf_POStockInBillSaveApi([FromBody] JObject sMainSub)


        {


            try


            { 


            {


                oCN.BeginTran();


                LogService.Write("采购入库单同步,保存方法执行：" + sMainSub.ToString());




                sMainSub["model"]["hredblueflag"] = string.Equals(sMainSub["model"]["hredblueflag"].ToString(), "0") ? false : true;


                var model = sMainSub["model"].ToString();


                var entry = sMainSub["model"]["HENTRY"].ToString();




@@ -2114,118 +2115,125 @@


                List<ClsKf_ICStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillSub>>(entry);




                // 判断 数据库中是否存在id和单据号相等的单据，存在，则重建，只有id号相等，则申请新的id号


                var ds1 = oCN.RunProcReturn($@"


                select hmainid HInterID, 单据号 HBillNO from h_v_Kf_POStockInBillList where hmainid = {mainList[0].HInterID}


                ", "h_v_Kf_POStockInBillList");


                // var ds1 = oCN.RunProcReturn($@"


                // select hmainid HInterID, 单据号 HBillNO from h_v_Kf_POStockInBillList where hmainid = {mainList[0].HInterID}


                // ", "h_v_Kf_POStockInBillList");


                // var HInterID_Old = mainList[0].HInterID;


                // if (ds1.Tables[0].Rows.Count > 0 && ds1.Tables[0].Rows[0]["HInterID"] != null)


                // {


                //     if (string.Equals(ds1.Tables[0].Rows[0]["HBillNo"].ToString(), mainList[0].HBillNo, StringComparison.OrdinalIgnoreCase))


                //     {


                //         string sql = string.Empty;


                //         sql = $"delete Kf_ICStockBillMain where HinterID = {mainList[0].HInterID}";


                //         oCN.RunProc(sql);


                //         sql = $"delete Kf_ICStockBillSub where HinterID = {mainList[0].HInterID}";


                //         oCN.RunProc(sql);


                //     }


                //     else


                //     {


                //         // 重新申请HInterID


                //         var HInterID_Exch = DBUtility.ClsPub.CreateBillID("1201", ref DBUtility.ClsPub.sExeReturnInfo);


                //         mainList[0].HInterID = HInterID_Exch;


                // 


                //         foreach (var oSub in subList)


                //         {


                //             oSub.HInterID = HInterID_Exch;


                //         }


                // 


                //     }


                // }




                if (ds1.Tables[0].Rows.Count > 0 && ds1.Tables[0].Rows[0]["HInterID"] != null)


                {


                    if (string.Equals(ds1.Tables[0].Rows[0]["HBillNo"].ToString(), mainList[0].HBillNo, StringComparison.OrdinalIgnoreCase))


                    {


                        string sql = string.Empty;


                        sql = $"delete Kf_ICStockBillMain where HinterID = {mainList[0].HInterID}";


                        oCN.RunProc(sql);


                        sql = $"delete Kf_ICStockBillSub where HinterID = {mainList[0].HInterID}";


                        oCN.RunProc(sql);


                    }


                    else


                    {


                        // 重新申请HInterID


                        var HInterID_Exch = DBUtility.ClsPub.CreateBillID("1201", ref DBUtility.ClsPub.sExeReturnInfo);


                        mainList[0].HInterID = HInterID_Exch;




                        foreach (var oSub in subList)


                        {


                            oSub.HInterID = HInterID_Exch;


                        }




                    }


                }


               


                // 主表


                string sql = string.Empty;


                sql = $"delete Kf_ICStockBillMain where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                sql = $"delete Kf_ICStockBillSub where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                // 主表插入


                oCN.RunProc($@"Insert Into Kf_ICStockBillMain 


                (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus


                ,HAddress,HSupID,HCurID,HWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID,HExplanation,HRemark


                ,HInnerBillNo,HSTOCKORGID,HOWNERID,HMaker,HMakeDate,HProjectID,HInvoiceBillNo


                ,HChecker, HCheckDate)


                values(


                '{mainList[0].HInterID}',


                '{mainList[0].HYear}',


                '{mainList[0].HPeriod}',


                '{mainList[0].HBillType}',


                '{mainList[0].HBillSubType}',


                '{mainList[0].HDate}',


                '{mainList[0].HBillNo}',


                {mainList[0].HBillStatus},


                '{mainList[0].HAddress}',


                '{mainList[0].HSupID}',


                '{mainList[0].HCurID}',


                '{mainList[0].HWHID}',


                '{mainList[0].HEmpID}',


                '{mainList[0].HManagerID}',


                '{mainList[0].HSecManagerID}',


                '{mainList[0].HKeeperID}',


                '{mainList[0].HDeptID}',


                '{mainList[0].HExplanation}',


                '{mainList[0].HRemark}',


                '{mainList[0].HInnerBillNo}',


                {mainList[0].HSTOCKORGID},


                '{mainList[0].HOWNERID}',


                '{mainList[0].HMaker}',


                '{mainList[0].HMakeDate}',


                '{mainList[0].HProjectID}',


                '{mainList[0].HInvoiceBillNo}',


                '{mainList[0].HChecker}',


                '{mainList[0].HCheckDate}'


                (


                    HInterID, HYear, HPeriod, HBillNo, HBillType, HBillSubType, HMainSourceBillType, HDate,


                    HSupID, HWHID, HSCWHID, HEmpID, HManagerID, HSecManagerID, HKeeperID, HDeptID, HCurID,


                    HSeOrderBillNo, HExplanation, HRemark, HInnerBillNo, HRedBlueFlag, HBillStatus,


                    HMaker, HMakeDate, HChecker, HCheckDate,


                    HUpDater, HUpDateDate, HDeleteMan, HDeleteDate,


                    HOWNERID, HOWNERTYPEID, HERPInterID, HERPBillType, HERPBillNo,


                    HPRDORGID, HSTOCKORGID, HSTOCKERGROUPID, HPURCHASERGROUPID, HDEMANDORGID, HCORRESPONDORGID,


                    HPROVIDERCONTACTID, HSUPPLYID, HSETTLEID, HCHARGEID, HPURCHASEDEPTID, HBUSINESSTYPE,


                    HSUPPLYADDRESS, HPAYORGID, HSETTLEORGID, HSETTLETYPEID, HPAYCONDITIONID, HSETTLECURRID,


                    HEXCHANGETYPEID, HDISCOUNTLISTID, HEXCHANGERATE, HPRICETIMEPOINT, HLOCALCURRID, HISINCLUDEDTAX,


                    HISPRICEEXCLUDETAX


                )


            ");


                values(


                    '{mainList[0].HInterID}','{mainList[0].HYear}','{mainList[0].HPeriod}','{mainList[0].HBillNo}',                   


                    '{mainList[0].HBillType}','{mainList[0].HBillSubType}','{mainList[0].HMainSourceBillType}','{mainList[0].HDate}',                     


                    '{mainList[0].HSupID}','{mainList[0].HWHID}','{mainList[0].HSCWHID}','{mainList[0].HEmpID}','{mainList[0].HManagerID}',                


                    '{mainList[0].HSecManagerID}','{mainList[0].HKeeperID}','{mainList[0].HDeptID}','{mainList[0].HCurID}',                    


                    '{mainList[0].HSeOrderBillNo}','{mainList[0].HExplanation}','{mainList[0].HRemark}','{mainList[0].HInnerBillNo}',              


                    '{mainList[0].HRedBlueFlag}',{mainList[0].HBillStatus},'{mainList[0].HMaker}','{mainList[0].HMakeDate}',                 


                    '{mainList[0].HChecker}','{mainList[0].HCheckDate}','{mainList[0].HUpDater}','{mainList[0].HUpDateDate}',               


                    '{mainList[0].HDeleteMan}','{mainList[0].HDeleteDate}','{mainList[0].HOWNERID}','{mainList[0].HOWNERTYPEID}',              


                    '{mainList[0].HERPInterID}','{mainList[0].HERPBillType}','{mainList[0].HERPBillNo}','{mainList[0].HPRDORGID}',                 


                    '{mainList[0].HSTOCKORGID}','{mainList[0].HSTOCKERGROUPID}','{mainList[0].HPURCHASERGROUPID}','{mainList[0].HDEMANDORGID}',              


                    '{mainList[0].HCORRESPONDORGID}','{mainList[0].HPROVIDERCONTACTID}','{mainList[0].HSUPPLYID}','{mainList[0].HSETTLEID}',                 


                    '{mainList[0].HCHARGEID}','{mainList[0].HPURCHASEDEPTID}','{mainList[0].HBUSINESSTYPE}','{mainList[0].HSUPPLYADDRESS}',            


                    '{mainList[0].HPAYORGID}','{mainList[0].HSETTLEORGID}','{mainList[0].HSETTLETYPEID}','{mainList[0].HPAYCONDITIONID}',           


                    '{mainList[0].HSETTLECURRID}','{mainList[0].HEXCHANGETYPEID}','{mainList[0].HDISCOUNTLISTID}','{mainList[0].HEXCHANGERATE}',             


                    '{mainList[0].HPRICETIMEPOINT}','{mainList[0].HLOCALCURRID}','{mainList[0].HISINCLUDEDTAX}','{mainList[0].HISPRICEEXCLUDETAX}'         


                )");




                // 子表插入


                foreach (var osub in subList)


                {


                    // var syncSorceBillRes = oCN.RunProcReturn($@"


                    //     exec h_p_IFCLD_ERPSourceBillToLocal_POStockInBill_GetSourceInfo 


                    //     '{osub.HSourceBillType}', '{osub.HSourceBillNo}', {osub.HSourceSEQ} 


                    // ", "h_p_IFCLD_ERPSourceBillToLocal_POStockInBill_GetSourceInfo");


                    // string HERPInterID = "0";


                    // string HERPEntryID = "0";


                    // if (syncSorceBillRes != null && syncSorceBillRes.Tables.Count > 0)


                    // {


                    //     osub.HSourceEntryID = (long)syncSorceBillRes.Tables[0].Rows[0]["HEntryID"];


                    //     osub.HSourceInterID = (long)syncSorceBillRes.Tables[0].Rows[0]["HInterID"];


                    //     HERPInterID = syncSorceBillRes.Tables[0].Rows[0]["HERPInterID"].ToString();


                    //     HERPEntryID = syncSorceBillRes.Tables[0].Rows[0]["HERPInterID"].ToString();


                    // }




                   




                    oCN.RunProc($@"Insert into Kf_ICStockBillSub 


                    (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice


                    ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo


                    ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType


                    ,HPOOrderInterID,HPOOrderEntryID ,HPOOrderBillNo


                    ,HPropertyID,HSecUnitID,HSecUnitRate,HPlanMode,HRemark,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo


                    ,HTaxRate,HTaxPrice,HlineTotal) 


                    (


                        HInterID, HEntryID, HMTONo, HPlanMode, HRemark, HExpressNumber,


                        HMaterID, HUnitID, HBatchNo, HPropertyID, HWHID, HSPID, HSCWHID, HSCSPID,


                        HQtyMust, HQty, HPrice, HMoney, HTaxPrice, HTaxRate, HTaxMoney, HRelationQty, HRelationMoney,


                        HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HERPInterID, HERPEntryID, HERPBillNo_Sub,


                        HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HSeOrderInterID, HSeOrderEntryID, HSeOrderBillNo,


                        HICMOInterID, HICMOEntryID, HICMOBillNo, HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo,


                        HProduceDate, HExpiryDate, HOWNERID, HOWNERTYPEID, HKEEPERID, HKEEPERTYPEID,


                        HSUPPLIERLOT, HREQTRACENO, HPROJECTNO, HGIVEAWAY, HSYSPRICE, HPRICECOEFFICIENT,


                        HDISCOUNTRATE, HBASEUNITPRICE, HTAXCOMBINATION, HPRICELISTENTRY, HCOSTPRICE, HSEQ,


                        HROWTYPE, HPARENTMATID, HPRILSTENTRYID, HPURBASENUM, HSTOCKBASEDEN, HBFLOWID,


                        HSTOCKSTATUSID, HPRICEUNITID, HBASEUNITID, HSNUNITID, HREMAININSTOCKUNITID, HEXTAUXUNITID,


                        HTAXRATEID, HTAXRATE_TAX, HTAXAMOUNT, HCOSTPERCENT, HCOSTAMOUNT, HVAT,


                        HSELLERWITHHOLDING, HBUYERWITHHOLDING


                    ) 


                    values (


                        '{osub.HInterID}', 


                        '{osub.HEntryID}', 


                        '{osub.HMaterID}',


                        '{osub.HUnitID}', 


                        '{osub.HQtyMust}', 


                        '{osub.HQty}',


                        '{osub.HPrice}',


                        '{osub.HMoney}',


                        '{osub.HOrderPrice}',


                        '{osub.HWHID}',


                        '{osub.HSPID}',


                        '{osub.HRelationQty}',


                        '{osub.HBatchNo}',


                        '{osub.HSourceInterID}',


                        '{osub.HSourceEntryID}',


                        '{osub.HSourceBillNo}',


                        '{osub.HSourceBillType}',


                        '{osub.HPOOrderInterID}',


                        '{osub.HPOOrderEntryID}',


                        '{osub.HPOOrderBillNo}',


                        '{osub.HPropertyID}',


                        '{osub.HSecUnitID}',


                        '{osub.HSecUnitRate}',


                        '{osub.HPlanMode}',


                        '{osub.HRemark}',


                        '{osub.HSeOrderInterID}',


                        '{osub.HSeOrderEntryID}',


                        '{osub.HSeOrderBillNo}',


                        '{osub.HTaxRate}',


                        '{osub.HTaxPrice}',


                        '{osub.HlineTotal}'


                    )


                    ");


                        '{osub.HInterID}','{osub.HEntryID}','{osub.HMTONo}',{osub.HPlanMode},'{osub.HRemark}','{osub.HExpressNumber}',


                        '{osub.HMaterID}','{osub.HUnitID}','{osub.HBatchNo}','{osub.HPropertyID}','{osub.HWHID}',                      


                        '{osub.HSPID}','{osub.HSCWHID}','{osub.HSCSPID}', '{osub.HQtyMust}','{osub.HQty}','{osub.HPrice}',                     


                        '{osub.HMoney}', '{osub.HTaxPrice}', '{osub.HTaxRate}', '{osub.HTaxMoney}', '{osub.HRelationQty}',               


                        '{osub.HRelationMoney}','{osub.HSourceInterID}','{osub.HSourceEntryID}','{osub.HSourceBillNo}',              


                        '{osub.HSourceBillType}','{osub.HERPInterID}','{osub.HERPEntryID}','{osub.HERPBillNo_Sub}',             


                        '{osub.HPOOrderInterID}','{osub.HPOOrderEntryID}','{osub.HPOOrderBillNo}','{osub.HSeOrderInterID}',            


                        '{osub.HSeOrderEntryID}','{osub.HSeOrderBillNo}','{osub.HICMOInterID}','{osub.HICMOEntryID}',               


                        '{osub.HICMOBillNo}','{osub.HWWOrderInterID}','{osub.HWWOrderEntryID}', '{osub.HWWOrderBillNo}',             


                        '{osub.HProduceDate}','{osub.HExpiryDate}', '{osub.HOWNERID}','{osub.HOWNERTYPEID}','{osub.HKEEPERID}',                  


                        '{osub.HKEEPERTYPEID}', '{osub.HSUPPLIERLOT}', '{osub.HREQTRACENO}', '{osub.HPROJECTNO}','{osub.HGIVEAWAY}',                  


                        '{osub.HSYSPRICE}', '{osub.HPRICECOEFFICIENT}','{osub.HDISCOUNTRATE}','{osub.HBASEUNITPRICE}', '{osub.HTAXCOMBINATION}',            


                        '{osub.HPRICELISTENTRY}','{osub.HCOSTPRICE}', '{osub.HSEQ}','{osub.HROWTYPE}','{osub.HPARENTMATID}', '{osub.HPRILSTENTRYID}',             


                        '{osub.HPURBASENUM}','{osub.HSTOCKBASEDEN}', '{osub.HBFLOWID}','{osub.HSTOCKSTATUSID}','{osub.HPRICEUNITID}', '{osub.HBASEUNITID}',                


                        '{osub.HSNUNITID}', '{osub.HREMAININSTOCKUNITID}','{osub.HEXTAUXUNITID}','{osub.HTAXRATEID}','{osub.HTAXRATE_TAX}','{osub.HTAXAMOUNT}',                 


                        '{osub.HCOSTPERCENT}','{osub.HCOSTAMOUNT}','{osub.HVAT}','{osub.HSELLERWITHHOLDING}','{osub.HBUYERWITHHOLDING}'           


                    )");


                }




                //采购入库单新增回填采购入库关联数量