智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
1
duhe
2024-03-28 92cc987c52cc28414e04f95a4656ac39ad925d54 
 WebAPI/Controllers/SCGL/Sc_ProductionReturnBillController.cs


@@ -79,6 +79,379 @@


        }






        #region 生产退库单 删除功能


        /// <summary>


        ///产品入库单删除功能


        /// </summary>


        /// <returns></returns>




        [Route("Sc_ProductionReturnBill/DeltetProductionReturnBill")]


        [HttpGet]


        public object DeltetProductionReturnBill(string HInterID, string user)


        {


            try


            {


                string HBillNo = "";


                //删除前控制=========================================      


                string sql1 = "exec h_p_Sc_ProductionReturnBill_BeforeDelCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                ds = oCN.RunProcReturn(sql1, "h_p_Sc_ProductionReturnBill_BeforeDelCtrl");


                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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




                string sReturn = "";


                oCN.BeginTran();


                oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);


                oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);


                oCN.Commit();




                //删除后控制==================================================================================      


                string sql2 = "exec h_p_Sc_ProductionReturnBill_AfterDelCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                ds = oCN.RunProcReturn(sql2, "h_p_Sc_ProductionReturnBill_AfterDelCtrl");


                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


                {


                    sReturn = "删除后判断失败，请与网络管理人员联系";


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:" + sReturn;


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }


                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                {


                    sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:" + sReturn;


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }


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




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "删除成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        //#region 生产入库单  保存/编辑功能


        //[Route("Kf_ProductInBill/ProductInBillEdit")]


        //[HttpPost]


        //public object ProductInBillEdit([FromBody] JObject sMainSub)


        //{


        //    try


        //    {


        //        var _value = sMainSub["sMainSub"].ToString();


        //        string msg1 = _value.ToString();


        //        oCN.BeginTran();


        //        //保存主表


        //        objJsonResult = AddBillMain(msg1);


        //        if (objJsonResult.code == "0")


        //        {


        //            oCN.RollBack();


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = objJsonResult.Message;


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }


        //        oCN.Commit();


        //        objJsonResult.code = "1";


        //        objJsonResult.count = 1;


        //        objJsonResult.Message = "单据保存成功！";


        //        objJsonResult.data = null;


        //        return objJsonResult;




        //    }


        //    catch (Exception e)


        //    {


        //        oCN.RollBack();


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = "保存失败！" + e.ToString();


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //}




        //public json AddBillMain(string msg1)


        //{


        //    string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


        //    string msg2 = sArray[0].ToString(); //主表数据


        //    string msg3 = sArray[1].ToString(); //子表数据


        //    int OperationType = int.Parse(sArray[2].ToString()); // 数据类型 1添加 3修改


        //    string user = sArray[3].ToString();


        //    string msg_allVal = sArray[4].ToString(); //主表+子表所有数据




        //    try


        //    {


        //        msg2 = "[" + msg2.ToString() + "]";


        //        List<ClsKf_ProductInBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ProductInBillMain>>(msg2);




        //        long HInterID = mainList[0].HInterID;//递入type得到的单据ID


        //        string HBillNo = mainList[0].HBillNo;//递入type得到的单据号


        //        long HPRDORGID = mainList[0].HPRDORGID;//组织


        //        DateTime HDate = mainList[0].HDate;//日期


        //        string HRemark = mainList[0].HRemark;//备注


        //        long HSupID = mainList[0].HSupID;//供应商


        //        long HEmpID = mainList[0].HEmpID;//业务员


        //        long HDeptID = mainList[0].HDeptID;//部门


        //        long HSecManagerID = mainList[0].HSecManagerID;//验收员


        //        long HKeeperID = mainList[0].HKeeperID;//保管员


        //        long HCurID = mainList[0].HCurID;//币别


        //        Single HExRate = mainList[0].HExRate;//汇率


        //        long HManagerID = mainList[0].HManagerID;//主管


        //        long HWHID = mainList[0].HWHID;//仓库


        //        string HMaker = user;//制单人


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


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




        //        List<ClsCg_POInStockBillMain> mainList2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POInStockBillMain>>(msg2);


        //        DateTime dt = DateTime.Now;


        //        long HCORRESPONDORGID = mainList2[0].HOrgID;


        //        long HYear = mainList2[0].HYear == null ? 0 : mainList2[0].HYear;


        //        long HPeriod = mainList2[0].HPeriod == null ? 0 : mainList2[0].HPeriod;


        //        string HBillType = mainList2[0].HBillType == null ? "''" : mainList2[0].HBillType;


        //        string HBillSubType = mainList2[0].HBillSubType == null ? "''" : mainList2[0].HBillSubType;


        //        long HBillStatus = mainList2[0].HBillStatus == null ? 0 : mainList2[0].HBillStatus;


        //        string HMakeDate = mainList2[0].HMakeDate == null ? "''" : mainList2[0].HMakeDate;


        //        string HChecker = mainList2[0].HChecker == null ? "''" : mainList2[0].HChecker;


        //        string HCheckDate = mainList2[0].HCheckDate == null ? "''" : mainList2[0].HCheckDate;


        //        string HOWNERTYPEID = mainList2[0].HOWNERTYPEID == null ? "''" : mainList2[0].HOWNERTYPEID;


        //        long HOWNERID = mainList2[0].HOWNERID == null ? 0 : mainList2[0].HOWNERID;


        //        long HERPInterID = mainList2[0].HERPInterID == null ? 0 : mainList2[0].HERPInterID;


        //        string HERPBillType = mainList2[0].HERPBillType == null ? "''" : mainList2[0].HERPBillType;


        //        long HPURCHASEORGID = mainList2[0].HPURCHASEORGID == null ? 0 : mainList2[0].HPURCHASEORGID;


        //        long HSTOCKORGID = mainList2[0].HSTOCKORGID == null ? 0 : mainList2[0].HSTOCKORGID;


        //        long HREQUIREORGID = mainList2[0].HREQUIREORGID == null ? 0 : mainList2[0].HREQUIREORGID;


        //        long HSTOCKGROUPID = mainList2[0].HSTOCKGROUPID == null ? 0 : mainList2[0].HSTOCKGROUPID;


        //        string HSENDBILLNO = mainList2[0].HSENDBILLNO == null ? "''" : mainList2[0].HSENDBILLNO;


        //        string HLADBILLNO = mainList2[0].HLADBILLNO == null ? "''" : mainList2[0].HLADBILLNO;


        //        long HPURDEPTID = mainList2[0].HPURDEPTID == null ? 0 : mainList2[0].HPURDEPTID;


        //        long HPURGROUPID = mainList2[0].HPURGROUPID == null ? 0 : mainList2[0].HPURGROUPID;


        //        long HSUPPLYID = mainList2[0].HSUPPLYID == null ? 0 : mainList2[0].HSUPPLYID;


        //        long HSETTLEID = mainList2[0].HSETTLEID == null ? 0 : mainList2[0].HSETTLEID;


        //        long HCHARGEID = mainList2[0].HCHARGEID == null ? 0 : mainList2[0].HCHARGEID;


        //        string HBUSINESSTYPE = mainList2[0].HBUSINESSTYPE == null ? "''" : mainList2[0].HBUSINESSTYPE;


        //        string HSUPPLYADDRESS = mainList2[0].HSUPPLYADDRESS == null ? "''" : mainList2[0].HSUPPLYADDRESS;


        //        long HPROVIDERCONTACTID = mainList2[0].HPROVIDERCONTACTID == null ? 0 : mainList2[0].HPROVIDERCONTACTID;




        //        ds = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_ProductInBillList");


        //        if ((OperationType == 1 || OperationType == 2 || OperationType == 4) && ds.Tables[0].Rows.Count == 0)//新增


        //        {




        //            //保存前控制=========================================


        //            ds = oCN.RunProcReturn("exec h_p_Kf_ProductInBill_BeforeSaveCtrl " + HInterID, "h_p_Kf_ProductInBill_BeforeSaveCtrl");




        //            if (ds == null || ds.Tables[0].Rows.Count == 0)


        //            {


        //                objJsonResult.code = "0";


        //                objJsonResult.count = 0;


        //                objJsonResult.Message = "保存前判断失败！";


        //                objJsonResult.data = null;


        //                return objJsonResult;


        //            }


        //            if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


        //            {


        //                objJsonResult.code = "0";


        //                objJsonResult.count = 0;


        //                objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


        //                objJsonResult.data = null;


        //                return objJsonResult;


        //            }


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


        //            //主表


        //            string sql = $@"Insert Into Kf_ICStockBillMain    


        //                (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate


          //             ,HBillNo,HBillStatus,HSupID,HManagerID,HEmpID,HDeptID,HSecManagerID,HKeeperID,HRemark,HMaker,HMakeDate,HCurID,HExRate,HWHID,HInnerBillNo,HExplanation )


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


        //            HBillSubType + "','" + HDate + "','" + HBillNo + "'," + HBillStatus + "," + HSupID +


        //            "," + HManagerID + "," + HEmpID + "," + HDeptID + "," + HSecManagerID + "," + HKeeperID + ",'" + HRemark + "','" + HMaker +


        //            "',getdate()" + "," + HCurID + "," + HExRate + "," + HWHID + ",'" + HInnerBillNo + "','" + HExplanation + "')";




        //            oCN.RunProc(sql);




        //        }


        //        else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0)


        //        { //修改


        //            string sql = $@"update Kf_ICStockBillMain  set " +


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


        //                         ",HSupID=" + HSupID + ",HCurID=" + HCurID


        //                         + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID


        //                         + ",HInnerBillNo='" + HInnerBillNo + "' where HInterID=" + HInterID;




        //            oCN.RunProc(sql);






        //            //删除子表


        //            oCN.RunProc("delete from Kf_ICStockBillSub where HInterID='" + HInterID + "'");


        //        }


        //        //保存子表


        //        objJsonResult = AddBillSub(msg3, HInterID, OperationType, user);




        //        //生产入库单新增回填生产订单关联数量


        //        oCN.RunProc("exec h_p_Kf_UpDateRelation_ProductInToICMO_Add " + HInterID);




        //        //生产入库单新增回填生产汇报单关联数量


        //        oCN.RunProc("exec h_p_Kf_UpDateRelation_ProductInToICMOReport_Add " + HInterID);




        //        if (objJsonResult.code == "0")


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = objJsonResult.Message;


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }




        //        objJsonResult.code = "1";


        //        objJsonResult.count = 1;


        //        objJsonResult.Message = null;


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //    catch (Exception e)


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = "Exception！" + e.ToString();


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //}




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


        //{


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




        //    List<ClsKf_ProductInBillSub> DetailColl2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ProductInBillSub>>(msg3);






        //    //long HSPID = DetailColl2[0].HSPID == null ? 0 : DetailColl2[0].HSPID;


        //    long HSourceInterID = DetailColl2[0].HSourceInterID == null ? 0 : DetailColl2[0].HSourceInterID;


        //    long HSourceEntryID = DetailColl2[0].HSourceEntryID == null ? 0 : DetailColl2[0].HSourceEntryID;


        //    string HSourceBillNo = DetailColl2[0].HSourceBillNo == null ? "''" : DetailColl2[0].HSourceBillNo;


        //    string HSourceBillType = DetailColl2[0].HSourceBillType == null ? "''" : DetailColl2[0].HSourceBillType;


        //    string HRemark = DetailColl2[0].HRemark == null ? "''" : DetailColl2[0].HRemark;


        //    string HPOOrderBillNo = DetailColl2[0].HPOOrderBillNo == null ? "''" : DetailColl2[0].HPOOrderBillNo;




        //    int i = 0;


        //    foreach (ClsKf_ProductInBillSub oSub in DetailColl)


        //    {


        //        i++;


        //        if (oSub.HQty <= 0 || oSub.HQty == null)


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "第" + i + "行，数量不能为0或者小于0";


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }




        //        if (oSub.HMaterID == 0)


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "第" + i + "行，物料不能为空";


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }




        //        //if (oSub.HSourceID == 0)


        //        //{


        //        //    objJsonResult.code = "0";


        //        //    objJsonResult.count = 0;


        //        //    objJsonResult.Message = "第" + i + "行，生产资源不能为空";


        //        //    objJsonResult.data = null;


        //        //    return objJsonResult;


        //        //}




        //        if (oSub.HUnitID == 0)


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "第" + i + "行，计量单位不能为空";


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }




        //        DataSet Cs;


        //        Int64 NewHEntryID = 1;


        //        Cs = oCN.RunProcReturn("select MAX(HEntryID)HEntryID from Kf_ICStockBillSub", "Kf_ICStockBillSub");


        //        if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0)


        //        {


        //            NewHEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString());


        //            NewHEntryID += 1;


        //        }






        //        oCN.RunProc($@"Insert into Kf_ICStockBillSub 


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


          //     ,HMoney,HWHID,HSPID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HPOOrderInterID


        //        ,HPOOrderEntryID,HPOORderBillNo,HSecUnitID,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HRelationQty,HSecUnitRate,HPropertyID) 


        //         values({HInterID},{NewHEntryID},{oSub.HMaterID},{oSub.HUnitID},{(oSub.HQtyMust == null ? 0 : oSub.HQtyMust)},{(oSub.HQty == null ? 0 : oSub.HQty)}


        //        ,{oSub.HPrice},{oSub.HMoney},{oSub.HWHID},{oSub.HSPID},'{HRemark}',{oSub.HSourceInterID},{oSub.HSourceEntryID},'{HSourceBillNo}',{HSourceBillType},


        //        {oSub.HPOOrderInterID},{oSub.HPOOrderEntryID},'{HPOOrderBillNo}',{oSub.HSecUnitID},{oSub.HSeOrderInterID},{oSub.HSeOrderEntryID},'{oSub.HSeOrderBillNo}',{oSub.HRelationQty},{oSub.HSecUnitRate},{oSub.HSecUnitRate})");




        //    }


        //    //保存后控制=========================================              


        //    ds = oCN.RunProcReturn("exec h_p_Kf_ProductInBill_AfterSaveCtrl " + HInterID, "h_p_Kf_ProductInBill_AfterSaveCtrl");




        //    if (ds == null || ds.Tables[0].Rows.Count == 0)


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = "保存后判断失败！";


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //    if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


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




        //    objJsonResult.code = "1";


        //    objJsonResult.count = 1;


        //    objJsonResult.Message = null;


        //    objJsonResult.data = null;


        //    return objJsonResult;


        //}


        //#endregion




        #region 生产退库单 审核/反审核


        /// <summary>


        ///