派生自 MES-WEB-API
WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs
@@ -211,7 +211,7 @@ ")", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCn.RunProc("Update Gy_StockCheckItem set HEndflag=0 where HItemID=" + oBill.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; @@ -252,6 +252,46 @@ } #endregion #region çç¹åæå表å¤æå½åéæ©ççç¹æ¹æ¡æ¯å¦çæè¿åæ® [Route("Gy_StockCheckItemBill/StockItemSubIsExistence")] [HttpGet] public object StockItemSubIsExistence(string sID) { try { DataSet ds; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql; sql = string.Format(@"select * from Gy_StockCheckItemSub where HInterID=" + sID); ds = oCN.RunProcReturn(sql, "Gy_StockCheckItemSub"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ææªçæ"; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å·²çæ"; return objJsonResult; } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region çç¹åæå表 [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")] [HttpGet] @@ -263,15 +303,30 @@ try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sID == null || sID == "") //å¤ææ¯å¦éæ©çç¹æ¹æ¡ï¼æ¯=>ï¼ç¨çç¹æ¹æ¡å表å对æ¯ï¼ï¼å¦=>ï¼ç¨å¨å ·æ¡£æ¡å对æ¯ï¼ if (sID==null|| sID == "") { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere + " order by HItemID desc "); if (sWhere=="pk") { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisPK"); } else { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList2 '{sWhere}'"); } } else { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere + " and HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ") order by HItemID desc "); if (sWhere == "pk") { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisPK2 WHERE HInterID="+ sID); } else { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList '{sID}','{sWhere}'"); } } ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain_Temp"); ds = oCN.RunProcReturn(sql, "h_p_Sc_MouldInventoryAnalysisList"); list.Add(ds.Tables[0]); objJsonResult.code = "1"; @@ -383,12 +438,13 @@ #region çç¹åæå®¡æ ¸ #region è°æ¨âç´æ¥è°æ¨ [Route("Gy_StockCheckItemBill/MakeProdMove")] [HttpGet] public object MakeProdMove(string msg) [HttpPost] public object MakeProdMove([FromBody] JObject msg) { try { string msg1 = msg.ToString(); var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user @@ -405,6 +461,7 @@ { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HDate = item.HMakeDate; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); @@ -421,7 +478,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3814','3814'," + HInterID + ",'" + HBillNo + "','2022-01-02'" + " values('3814','3814'," + HInterID + ",'" + HBillNo + "','" + HDate+"'"+ ", '" + user + "',getdate()" + ", " + dr["HSupID"].ToString() + ", 1," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -439,8 +496,9 @@ oCn.RunProc(sql); oCn.RunProc(sql1); oCn.RunProc("update Sc_MouldStockBillMain_Temp set HCheckStatus=1 where HitemID=" + HItemID); oCn.Commit(); } oCn.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; @@ -464,12 +522,13 @@ #region ççâå ¶ä»å ¥åºå [Route("Gy_StockCheckItemBill/MakeOtherIn")] [HttpGet] public object MakeOtherIn(string msg) [HttpPost] public object MakeOtherIn([FromBody] JObject msg) { try { string msg1 = msg.ToString(); var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user @@ -487,6 +546,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -501,11 +561,12 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3827','3827'," + HInterID + ",'" + HBillNo + "','2022-01-02'" + " values('3827','3827'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + ",isnull('" + dr["HNowSupID"].ToString() + "',0),0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",'',0" + ") "; string sql1 = string.Format(@"Insert Into Sc_MouldStockBillSub (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID, HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitRate,HSecUnitID,HUnitID, HBatchNo,HQtyMust,HQty,HPrice,HMoney,HDesignLife,HLeaveLife,HUseLife,HWHID,HSCWHID,HSPID,HSCSPID,HSPGroupID,HCorrespondentTypeID,HCorrespondentID, @@ -513,13 +574,15 @@ "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + "," + dr1["HCorrespondentID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); //主表 oCn.BeginTran(); oCn.RunProc(sql); oCn.RunProc(sql1); oCn.RunProc("update Sc_MouldStockBillMain_Temp set HCheckStatus=1 where HitemID=" + HItemID); oCn.Commit(); } oCn.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; @@ -543,13 +606,13 @@ #region çäºâå¤çåºåºå [Route("Gy_StockCheckItemBill/MakeScrapOut")] [HttpGet] public object MakeScrapOut(string msg) [HttpPost] public object MakeScrapOut([FromBody] JObject msg) { try { //var _value = msg["msg"].ToString(); string msg1 = msg.ToString(); var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user @@ -566,6 +629,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -581,7 +645,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3832','3832'," + HInterID + ",'" + HBillNo + "','2022-01-02'" + " values('3832','3832'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -599,8 +663,8 @@ oCn.RunProc(sql); oCn.RunProc(sql1); oCn.RunProc("update Sc_MouldStockBillMain_Temp set HCheckStatus=1 where HitemID=" + HItemID); oCn.Commit(); } oCn.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; @@ -624,13 +688,13 @@ #region åºåºâé¢ç¨åºåºå [Route("Gy_StockCheckItemBill/MakeProdOut")] [HttpGet] public object MakeProdOut(string msg) [HttpPost] public object MakeProdOut([FromBody] JObject msg) { try { //var _value = msg["msg"].ToString(); string msg1 = msg.ToString(); var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user @@ -647,6 +711,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -662,7 +727,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3802','3802'," + HInterID + ",'" + HBillNo + "','2022-01-02'" + " values('3802','3802'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -680,8 +745,9 @@ oCn.RunProc(sql); oCn.RunProc(sql1); oCn.RunProc("update Sc_MouldStockBillMain_Temp set HCheckStatus=1 where HitemID=" + HItemID); oCn.Commit(); } oCn.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; @@ -704,12 +770,12 @@ #region éåºâé¢ç¨éåºå [Route("Gy_StockCheckItemBill/MakeProdBack")] [HttpGet] public object MakeProdBack(string msg) [HttpPost] public object MakeProdBack([FromBody] JObject msg) { try {//var _value = msg["msg"].ToString(); string msg1 = msg.ToString(); { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user @@ -726,6 +792,7 @@ var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string HDate = item.HMakeDate; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); @@ -741,7 +808,7 @@ ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3803','3803'," + HInterID + ",'" + HBillNo + "','2022-01-02'" + " values('3803','3803'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ", " + dr["HNowSupID"].ToString() + "," + dr["HNowSupTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + @@ -759,8 +826,9 @@ oCn.RunProc(sql); oCn.RunProc(sql1); oCn.RunProc("update Sc_MouldStockBillMain_Temp set HCheckStatus=1 where HitemID=" + HItemID); oCn.Commit(); } oCn.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; @@ -784,8 +852,8 @@ #region å é¢ç¨éåºåé¢ç¨åºåº [Route("Gy_StockCheckItemBill/MakeProdOutBack")] [HttpGet] public object MakeProdOutBack(string msg) [HttpPost] public object MakeProdOutBack([FromBody] JObject msg) { MakeProdBack(msg); MakeProdOut(msg);
