派生自 MES-WEB-API
WebAPI/Controllers/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillController.cs
@@ -16,14 +16,14 @@ public class Sc_ICMOBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; #region ç产任å¡åå é¤åè½ [Route("Sc_ICMOBill/DeltetSc_ICMOReportBill")] [HttpGet] public object DeltetSc_ICMOReportBill(string HInterID,string user) public object DeltetSc_ICMOReportBill(string HInterID, string user) { try { @@ -75,6 +75,33 @@ } #endregion #region ç产任å¡åè·åè½¦é´ [Route("Sc_ICMOBill/GetHDeptList")] [HttpGet] public object GetHDeptList() { try { DataSet oDs = new DataSet(); //========== oDs = oCN.RunProcReturn("select HItemID,HName from Gy_Department", "Gy_Department"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è·åæåï¼"; objJsonResult.data = oDs.Tables[0]; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å¢åè£ ç®±åå车äºä»¶ [Route("Sc_ICMOBill/QK_PackingBillByXSBill")] [HttpGet] @@ -82,16 +109,34 @@ { try { string sql = string.Format(@"select a.HInterID,a.HBillNo,a.HMaterID,m.HName HMaterName, a.HUnitID,u.HName HUnitName,b.HQty HPlanQty,a.HCusID, c.HName HCusName,a.HEmpID,e.HName HEmpName,a.HDeptID,d.HName HDeptName,a.HPlanEndDate,0 HMinQty,0 HTotalQty,0 HSpsQty from Sc_ICMOBillMain a left join Sc_ICMOBillSub b on a.HInterID=b.HInterID left join Gy_Material m on b.HMaterID=m.HItemID left join Gy_Unit u on b.HUnitID=u.HItemID left join Gy_Customer c on a.HCusID=c.HItemID left join Gy_Employee e on a.HEmpID=e.HItemID left join Gy_Department d on a.HDeptID=d.HItemID where b.HDEPTID='113546' and b.HSeOrderInterID=(select HSeOrderInterID from Sc_PPBomBillMain where HBillNo='" + HBillNo + "')"); //string sql = string.Format(@"select a.HInterID,a.HBillNo,a.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, a.HUnitID,u.HName HUnitName,b.HQty HPlanQty,a.HCusID, c.HName HCusName,a.HEmpID,e.HName HEmpName,a.HDeptID,d.HName HDeptName,a.HPlanEndDate,0 HMinQty,0 HTotalQty,0 HSpsQty,a.HSeOrderBillNo // from Sc_ICMOBillMain a // left join Sc_ICMOBillSub b on a.HInterID=b.HInterID // left join Gy_Material m on b.HMaterID=m.HItemID // left join Gy_Unit u on b.HUnitID=u.HItemID // left join Gy_Customer c on a.HCusID=c.HItemID // left join Gy_Employee e on a.HEmpID=e.HItemID // left join Gy_Department d on a.HDeptID=d.HItemID // where b.HInterID=(select HICMOInterID from Sc_PPBomBillMain where HBillNo='" + HBillNo + "')"); string sql = string.Format(@" select a.HInterID,a.HBillNo,a.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, a.HUnitID,u.HName HUnitName,b.HQty HPlanQty,a.HCusID, c.HName HCusName,a.HEmpID,e.HName HEmpName,a.HDeptID,d.HName HDeptName,a.HPlanEndDate,0 HMinQty,0 HTotalQty,0 HSpsQty,a.HSeOrderBillNo ,fo.FBILLNO FBillNo,fo.F_ZZZZ_TEXT7 FLXName,fo.FRECEIVEADDRESS FInAddress,fm1.FOLDNUMBER FMaterName,fo.F_ZZZZ_TEXT FBZFS,fu.FDATAVALUE FHX, fu1.FDATAVALUE FQK,fo.F_ZZZZ_WBBZ FWBBZ from Sc_ICMOBillMain a left join Sc_ICMOBillSub b on a.HInterID=b.HInterID left join Gy_Material m on b.HMaterID=m.HItemID left join Gy_Unit u on b.HUnitID=u.HItemID left join Gy_Customer c on a.HCusID=c.HItemID left join Gy_Employee e on a.HEmpID=e.HItemID left join Gy_Department d on a.HDeptID=d.HItemID left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID where b.HInterID=(select HICMOInterID from Sc_PPBomBillMain where HBillNo='" + HBillNo + "')"); ds = oCN.RunProcReturn(sql, "Sc_ICMOBillMain"); if (ds.Tables[0].Rows.Count != 0 || ds != null) { @@ -153,9 +198,13 @@ string day = DateTime.Now.Day.ToString(); string nowDate = year + month + day; string materid = ""; int LSH; string LSH2; string TM = ""; long sum = 0; if (msg4=="ZZ") if (msg4 == "ZZ") { string FID = ""; oCN.BeginTran(); foreach (Models.ClsQK_PackingBill oItemSub in ls) { @@ -164,11 +213,19 @@ { //çæå¯ä¸æ¡ç æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ string sTMNumber = OrgNum + oItemSub.HMaterNumber + nowDate; Ds1 = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· int LSH = ClsPub.isInt(Ds1.Tables[0].Rows[0][0]);//å¯ä¸ç //è·åå ç LSH = ClsPub.isInt(Ds1.Tables[0].Rows[0][0]);//å¯ä¸ç LSH = LSH + 1; LSH2 = LSH.ToString(); while (LSH2.Length<6) { LSH2 = "0" + LSH2; } TM = sTMNumber + LSH2; //è·åå ç long HInterID = DBUtility.ClsPub.CreateBillID_Prod("85", ref DBUtility.ClsPub.sExeReturnInfo); oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + string str = string.Format(@"insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + @@ -177,21 +234,23 @@ ",HGiveAwayFlag " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " + ") values (" + "'" + LSH + "','å¯ä¸æ¡ç '," + oItemSub.HMaterID.ToString() + "," + oItemSub.HUnitID.ToString() + "," + oItemSub.HMinQty.ToString() + "'" + TM + "','å¯ä¸æ¡ç '," + oItemSub.HMaterID.ToString() + "," + oItemSub.HUnitID.ToString() + "," + oItemSub.HMinQty.ToString() + ",'',0,0,'" + msg3 + "',getdate(),0," + oItemSub.HMinQty.ToString() + ", " + oItemSub.HInterID.ToString() + "," + oItemSub.HInterID.ToString() + ",'" + oItemSub.HBillNo + "','3710',''" + ",1,1," + oItemSub.HDeptID.ToString() + ",0,0,''" + ", " + oItemSub.HCusID.ToString() + ",'',getdate(),'',getdate()" + ", " + msg5.ToString() + "," + OrgNum.ToString() + ",''," + HInterID.ToString() + ", " + msg5.ToString() + "," + OrgNum.ToString() + ",'" + oItemSub.HSeOrderBillNo.ToString() + "'," + HInterID.ToString() + ",0" + ",'" + oItemSub.HMaterName + "','','',0,'','')"); oCN.RunProc(str); oCN.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); string sql1 = string.Format(@"update Sc_ICMOBillSub set HQty=" + oItemSub.HSpsQty + " where HInterID=" + oItemSub.HInterID); oCN.RunProc(sql1); FID = FID + HInterID + ","; } } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.code = FID; objJsonResult.count = 1; objJsonResult.Message = "æ´è£ çææåï¼"; objJsonResult.data = 1; @@ -211,7 +270,7 @@ //çæå¯ä¸æ¡ç æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ string sTMNumber = OrgNum + oItemSub.HMaterNumber + nowDate; Ds1 = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· int LSH = ClsPub.isInt(Ds1.Tables[0].Rows[0][0]);//å¯ä¸ç LSH = ClsPub.isInt(Ds1.Tables[0].Rows[0][0]);//å¯ä¸ç //æå ¥æ¡ç æ¡£æ¡ oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + @@ -230,14 +289,14 @@ + ", " + msg5.ToString() + "," + OrgNum.ToString() + ",''," + HInterID2.ToString() + ",0" + ",'" + oItemSub.HMaterName + "','','',0,'','')"); //æå ¥ç»æåå表 //æå ¥ç»æåå表 string sql = string.Format(@"insert into Sc_PackUnionBillSub(HInterID,HEntryID,HCloseMan,HCloseType,HRemark, HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType, HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HSourceID,HEquipID,HGroupID,HWorkerID, HScanDate,HBarCode,HBarCode_Pack) values("+HInterID+",'','',0,'èªå¨ç»å®',"+oItemSub.HInterID+",'','"+oItemSub.HBillNo+"','3710',"+ "0,0,"+ oItemSub.HMaterID+","+ oItemSub.HUnitID+","+ oItemSub.HPlanQty+", 0,0,0,0,"+ "getdate(),'"+ LSH + "','" +HBillNo+"')"); values(" + HInterID + ",'','',0,'èªå¨ç»å®'," + oItemSub.HInterID + ",'','" + oItemSub.HBillNo + "','3710'," + "0,0," + oItemSub.HMaterID + "," + oItemSub.HUnitID + "," + oItemSub.HPlanQty + ", 0,0,0,0," + "getdate(),'" + LSH + "','" + HBillNo + "')"); //æ´æ¹ç产订åçæ°é string sql1 = string.Format(@"update Sc_ICMOBillSub set HQty=" + oItemSub.HSpsQty + " where HInterID=" + oItemSub.HInterID); @@ -251,14 +310,14 @@ HProdOrgID,HDeptID,HEmpID,HSNum,HPackNum,HBarCode_Cus,HBatchNo,HBillSubType) values('2022',1,'3783'," + HInterID + ",getdate(),'" + HBillNo + "',1,0,0," + "'èªå¨ç»å®','','', '" + msg3 + "',getdate(),'','',0,'',0,0,'" + HBillNo + "',0,0,0,0,0," + HBillNo + "',0,0,0,0,0," + "0,0,0,0,0,'','','')"); oCN.RunProc(sql2); //å次çæå¯ä¸ç //è·åå ç long HInterID3 = DBUtility.ClsPub.CreateBillID_Prod("85", ref DBUtility.ClsPub.sExeReturnInfo); //çæå¯ä¸æ¡ç æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ string sTMNumber1 = OrgNum + materid+nowDate; string sTMNumber1 = OrgNum + materid + nowDate; Ds1 = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber1 + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· int LSH1 = ClsPub.isInt(Ds1.Tables[0].Rows[0][0]);//å¯ä¸ç string sql3 = string.Format(@"insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + @@ -287,7 +346,7 @@ objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { @@ -322,10 +381,10 @@ left join Gy_Employee e on a.HEmpID=e.HItemID left join Gy_Department d on a.HDeptID=d.HItemID left join Sc_PackUnionBillMain p on a.HSourceInterID=p.HInterID where a.HBarCode=(select HBarCode from Sc_PackUnionBillSub where HInterID= (select HBarcodeNo from Gy_BarCodeBill where HBarCode='" + HInterID + "'))"); where a.HBarCode in(select HBarCode from Sc_PackUnionBillSub where HInterID= (select HBarcodeNo from Gy_BarCodeBill where HItemID='" + HInterID + "'))"); ds = oCN.RunProcReturn(sql, "Sc_PackUnionBillSub"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; @@ -353,7 +412,7 @@ { try { ds = QK_GetPackingBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) @@ -412,18 +471,18 @@ /// <returns></returns> [Route("Sc_ICMOBillController/DeleteQK_GetPackingBillList")] [HttpGet] public object DeleteQK_GetPackingBillList(string HInterID,string Flag) public object DeleteQK_GetPackingBillList(string HInterID, string Flag) { try { oCN.BeginTran(); if (Flag=="0") if (Flag == "0") { DataSet ds = new DataSet(); ds = oCN.RunProcReturn("select * from Gy_BarCodeBill where HItemID=" + HInterID, "Gy_BarCodeBill"); DataRow dr = ds.Tables[0].Rows[0]; string sql = string.Format(@"delete from Gy_BarCodeBill where HItemID=" + HInterID); string sql1 = string.Format(@"update Sc_ICMOBillSub set HQty=HPlanQty+" + dr["HQty"] +" where HInterID=(select HSourceInterID from Gy_BarCodeBill where HItemID="+ HInterID + ")"); string sql1 = string.Format(@"update Sc_ICMOBillSub set HQty=HPlanQty+" + dr["HQty"] + " where HInterID=(select HSourceInterID from Gy_BarCodeBill where HItemID=" + HInterID + ")"); oCN.RunProc(sql); oCN.RunProc(sql1); } @@ -440,18 +499,18 @@ foreach (DataRow dr in dt.Rows) { DataSet ds = new DataSet(); ds = oCN.RunProcReturn("select * from Gy_BarCodeBill where HBarCode='" + dr["HBarCode"].ToString()+"'", "Gy_BarCodeBill"); ds = oCN.RunProcReturn("select * from Gy_BarCodeBill where HBarCode='" + dr["HBarCode"].ToString() + "'", "Gy_BarCodeBill"); DataRow dr1 = ds.Tables[0].Rows[0]; string sql = string.Format(@"delete from Gy_BarCodeBill where HBarCode='" + dr["HBarCode"].ToString()+"'"); string sql = string.Format(@"delete from Gy_BarCodeBill where HBarCode='" + dr["HBarCode"].ToString() + "'"); string sql1 = string.Format(@"update Sc_ICMOBillSub set HQty=HPlanQty+" + dr1["HQty"] + " where HInterID=(select HSourceInterID from Gy_BarCodeBill where HBarCode='" + dr["HBarCode"].ToString() + "')"); oCN.RunProc(sql); oCN.RunProc(sql1); } } //éåå®åå é¤éè¿æ¡ç idæ¾å°ææ¡ç ï¼éè¿ææ¡ç æ¾å°ç»æåå表çæ°æ®ï¼ä»¥å主表æ°æ® string sql3 = string.Format(@"delect from Sc_PackUnionBillSub where HInterID=(select HBarcodeNo from Gy_BarCodeBill where HItemID="+ HInterID); string sql3 = string.Format(@"delect from Sc_PackUnionBillSub where HInterID=(select HBarcodeNo from Gy_BarCodeBill where HItemID=" + HInterID); string sql4 = string.Format(@"delect from Sc_PackUnionBillMain where HInterID=(select HBarcodeNo from Gy_BarCodeBill where HItemID=" + HInterID); //å é¤æ大çåæçå¯ä¸ç string sql5 = string.Format(@"delete from Gy_BarCodeBill where HItemID=" + HInterID); @@ -478,5 +537,7 @@ } } #endregion } }
