派生自 MES-WEB-API
WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs
@@ -16,7 +16,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public Models.ClsGy_StockCheckItemBill BillNew0 = new Models.ClsGy_StockCheckItemBill(); public Models.ClsGy_StockCheckItemBill BillNew0 = new ClsGy_StockCheckItemBill(); #region çç¹æ¹æ¡å表 [Route("Gy_StockCheckItemBill/Get_StockCheckItemList")] @@ -26,22 +26,23 @@ try { ds = StockCheckItemList(sWhere); if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è¿åè®°å½æåï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "æ æ°æ®"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -206,7 +207,7 @@ ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HEndDate,HOrgID) " + " Values('" + oBill.HNumber + "','" + oBill.HName + "','" + oBill.HHelpCode + "','" + oBill.HShortNumber + "'," + oBill.HParentID.ToString() + "," + oBill.HLevel.ToString() + "," + Convert.ToString(oBill.HEndFlag ? 1 : 0) + "," + Convert.ToString(oBill.HStopflag ? 1 : 0) + ",'" + oBill.HRemark + "','" + oBill.HUseFlag + "',getdate(),'" + msg3 + "','" + oBill.HEndDate.ToString() + "'," + oBill.HOrgID.ToString()+ "','" + oBill.HUseFlag + "',getdate(),'" + msg3 + "','" + oBill.HEndDate.ToString() + "'," + oBill.HOrgID.ToString() + ")", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCn.RunProc("Update Gy_StockCheckItem set HEndflag=0 where HItemID=" + oBill.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); @@ -251,159 +252,114 @@ } #endregion #region çç¹åæå表 [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")] #region çç¹åæå表å¤æå½åéæ©ççç¹æ¹æ¡æ¯å¦çæè¿åæ® [Route("Gy_StockCheckItemBill/StockItemSubIsExistence")] [HttpGet] public object Get_InventoryAnalysisList(string sWhere) public object StockItemSubIsExistence(string sID) { DataSet ds; List<object> list = new List<object>(); List<object> list1 = new List<object>(); List<object> list2 = new List<object>(); List<object> list3 = new List<object>(); List<object> list4 = new List<object>(); List<object> list5 = new List<object>(); List<object> list6 = new List<object>(); List<object> list7 = new List<object>(); try { DataSet ds; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql; if (sWhere != null&&sWhere!="") sql = string.Format(@"select * from Gy_StockCheckItemSub where HInterID=" + sID); ds = oCN.RunProcReturn(sql, "Gy_StockCheckItemSub"); if (ds.Tables[0].Rows.Count == 0) { sql = string.Format(@"select k.HBarCode æ¡ç ,s.HName çç¹æ¹æ¡, case when k.HCorrespondentTypeID=1 then 'ä¾åºå' when k.HCorrespondentTypeID=2 then '客æ·' when k.HCorrespondentTypeID=4 then 'ä»åº' end å®é ä½ç½®ç±»å, case when k.HCorrespondentTypeID=1 then p.HName when k.HCorrespondentTypeID=2 then c.HName when k.HCorrespondentTypeID=4 then w.HName end å®é ä½ç½®, case when m.HNowSupTypeID=1 then 'ä¾åºå' when m.HNowSupTypeID=2 then '客æ·' when m.HNowSupTypeID=4 then 'ä»åº' end è´¦é¢ä½ç½®ç±»å, case when m.HNowSupTypeID=1 then p1.HName when m.HNowSupTypeID=2 then c1.HName when m.HNowSupTypeID=4 then w1.HName end è´¦é¢ä½ç½® from Sc_MouldStockBillMain_Temp k left join Gy_MouldFileMain m on k.HBarCode=m.HBarCode left join Gy_StockCheckItem s on k.HSourceInterID=s.HItemID left join Gy_Supplier p on k.HCorrespondentID=p.HItemID left join Gy_Supplier p1 on m.HNowSupTypeID=p1.HItemID left join Gy_Customer c on k.HCorrespondentID=c.HItemID left join Gy_Customer c1 on m.HNowSupTypeID=c1.HItemID left join Gy_Warehouse w on k.HSourceInterID=w.HItemID left join Gy_Warehouse w1 on m.HNowSupTypeID=w1.HItemID where (select HEndDate from Gy_StockCheckItem where Hitemid=(select top 1 HSourceInterID from Sc_MouldStockBillMain_Temp WHERE HSourceInterID=0))<getdate()"); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ææªçæ"; return objJsonResult; } else { sql = string.Format(@"select k.HBarCode æ¡ç ,s.HName çç¹æ¹æ¡, case when k.HCorrespondentTypeID=1 then 'ä¾åºå' when k.HCorrespondentTypeID=2 then '客æ·' when k.HCorrespondentTypeID=4 then 'ä»åº' end å®é ä½ç½®ç±»å, case when k.HCorrespondentTypeID=1 then p.HName when k.HCorrespondentTypeID=2 then c.HName when k.HCorrespondentTypeID=4 then w.HName end å®é ä½ç½®, case when m.HNowSupTypeID=1 then 'ä¾åºå' when m.HNowSupTypeID=2 then '客æ·' when m.HNowSupTypeID=4 then 'ä»åº' end è´¦é¢ä½ç½®ç±»å, case when m.HNowSupTypeID=1 then p1.HName when m.HNowSupTypeID=2 then c1.HName when m.HNowSupTypeID=4 then w1.HName end è´¦é¢ä½ç½® from Sc_MouldStockBillMain_Temp k left join Gy_MouldFileMain m on k.HBarCode=m.HBarCode left join Gy_StockCheckItem s on k.HSourceInterID=s.HItemID left join Gy_Supplier p on k.HCorrespondentID=p.HItemID left join Gy_Supplier p1 on m.HNowSupTypeID=p1.HItemID left join Gy_Customer c on k.HCorrespondentID=c.HItemID left join Gy_Customer c1 on m.HNowSupTypeID=c1.HItemID left join Gy_Warehouse w on k.HSourceInterID=w.HItemID left join Gy_Warehouse w1 on m.HNowSupTypeID=w1.HItemID"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å·²çæ"; return objJsonResult; } ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain_Temp"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (dr["å®é ä½ç½®ç±»å"].ToString()== dr["è´¦é¢ä½ç½®ç±»å"].ToString()&& dr["å®é ä½ç½®ç±»å"].ToString()=="ä¾åºå") { //æ£å¸¸ if (dr["å®é ä½ç½®"].ToString() == dr["è´¦é¢ä½ç½®"].ToString()) { list1.Add(dr); } //çç å®ç©å¨Aä¾åºåï¼ä½æ¯å¨è´¦é¢ä¸æ²¡æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() !=""|| dr["å®é ä½ç½®"].ToString() != null && dr["è´¦é¢ä½ç½®"].ToString()==""|| dr["è´¦é¢ä½ç½®"].ToString() == null) { list5.Add(dr); } //çäº Aä¾åºå没æè¿ä¸ªå°è½¦ï¼ä½æ¯å¨è´¦é¢ä¸æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() == "" || dr["å®é ä½ç½®"].ToString() == null && dr["è´¦é¢ä½ç½®"].ToString() != "" || dr["è´¦é¢ä½ç½®"].ToString() != null) { list6.Add(dr); } //å åé¢ç¨éåºåï¼ååé¢ç¨åºåºå å°è½¦å¨Aä¾åºå/客æ·ï¼ä½æ¯è´¦é¢ä¸å°è½¦å¨Bä¾åºå/å®¢æ· if (dr["å®é ä½ç½®ç±»å"].ToString()=="客æ·"&& dr["å®é ä½ç½®"].ToString() != dr["å®é ä½ç½®"].ToString()) { list4.Add(dr); } //åºåº if (dr["å®é ä½ç½®ç±»å"].ToString() == "ä¾åºå" && dr["è´¦é¢ä½ç½®ç±»å"].ToString() == "ä»åº") { list3.Add(dr); } } if (dr["å®é ä½ç½®ç±»å"].ToString() == dr["è´¦é¢ä½ç½®ç±»å"].ToString() && dr["å®é ä½ç½®ç±»å"].ToString() == "客æ·") { //æ£å¸¸ if (dr["å®é ä½ç½®"].ToString() == dr["è´¦é¢ä½ç½®"].ToString()) { list1.Add(dr); } //çç å®ç©å¨Aä¾åºåï¼ä½æ¯å¨è´¦é¢ä¸æ²¡æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() != "" || dr["å®é ä½ç½®"].ToString() != null && dr["è´¦é¢ä½ç½®"].ToString() == "" || dr["è´¦é¢ä½ç½®"].ToString() == null) { list5.Add(dr); } //çäº Aä¾åºå没æè¿ä¸ªå°è½¦ï¼ä½æ¯å¨è´¦é¢ä¸æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() == "" || dr["å®é ä½ç½®"].ToString() == null && dr["è´¦é¢ä½ç½®"].ToString() != "" || dr["è´¦é¢ä½ç½®"].ToString() != null) { list6.Add(dr); } //åºåº if (dr["å®é ä½ç½®ç±»å"].ToString() == "客æ·" && dr["è´¦é¢ä½ç½®ç±»å"].ToString() == "ä»åº") { list3.Add(dr); } //å åé¢ç¨éåºåï¼ååé¢ç¨åºåºå å°è½¦å¨Aä¾åºå/客æ·ï¼ä½æ¯è´¦é¢ä¸å°è½¦å¨Bä¾åºå/å®¢æ· if (dr["å®é ä½ç½®ç±»å"].ToString() == "ä¾åºå" && dr["å®é ä½ç½®"].ToString() != dr["å®é ä½ç½®"].ToString()) { list4.Add(dr); } } if (dr["å®é ä½ç½®ç±»å"].ToString() == dr["è´¦é¢ä½ç½®ç±»å"].ToString() && dr["å®é ä½ç½®ç±»å"].ToString() == "ä»åº") { //æ£å¸¸ if (dr["å®é ä½ç½®"].ToString() == dr["è´¦é¢ä½ç½®"].ToString()) { list1.Add(dr); } //çç å®ç©å¨Aä¾åºåï¼ä½æ¯å¨è´¦é¢ä¸æ²¡æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() != "" || dr["å®é ä½ç½®"].ToString() != null && dr["è´¦é¢ä½ç½®"].ToString() == "" || dr["è´¦é¢ä½ç½®"].ToString() == null) { list5.Add(dr); } //çäº Aä¾åºå没æè¿ä¸ªå°è½¦ï¼ä½æ¯å¨è´¦é¢ä¸æè¿ä¸ªå°è½¦ if (dr["å®é ä½ç½®"].ToString() == "" || dr["å®é ä½ç½®"].ToString() == null && dr["è´¦é¢ä½ç½®"].ToString() != "" || dr["è´¦é¢ä½ç½®"].ToString() != null) { list6.Add(dr); } //éåº if (dr["è´¦é¢ä½ç½®ç±»å"].ToString()=="ä¾åºå"|| dr["è´¦é¢ä½ç½®ç±»å"].ToString() == "客æ·") { list7.Add(dr); } //è°æ¨ if (dr["å®é ä½ç½®"].ToString() != dr["è´¦é¢ä½ç½®"].ToString()) { list2.Add(dr); } } } list.Add(list1); list.Add(list2); list.Add(list3); list.Add(list4); list.Add(list5); list.Add(list6); list.Add(list7); } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region çç¹åæå表 å é¤ ä¸éè¦çæ°æ® [Route("Gy_StockCheckItemBill/StockItemSubDel")] [HttpGet] public object StockItemSubDel(string sID) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //oCn.BeginTran(); //oCN.RunProc("exec h_p_StockItemSubDel " + sID); //oCn.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å é¤æåï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception ex) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region çç¹åæå表 [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")] [HttpGet] public object Get_InventoryAnalysisList(string sWhere, string sID) { DataSet ds; List<object> list = new List<object>(); string sql; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //å¤ææ¯å¦éæ©çç¹æ¹æ¡ï¼æ¯=>ï¼ç¨çç¹æ¹æ¡å表å对æ¯ï¼ï¼å¦=>ï¼ç¨å¨å ·æ¡£æ¡å对æ¯ï¼ if (sID == null || sID == "") { if (sWhere == "pk") { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisPK"); } else { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList2 '{sWhere}'"); } } else { if (sWhere == "pk") { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisPK '{sID}'"); } else { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList '{sID}','{sWhere}'"); } } ds = oCN.RunProcReturn(sql, "h_p_Sc_MouldInventoryAnalysisList"); list.Add(ds.Tables[0]); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; objJsonResult.list = list; @@ -419,5 +375,583 @@ } } #endregion #region çç¹è®°å½å表 [Route("Gy_StockCheckItemBill/Get_MouldStockBillMainTemp")] [HttpGet] public object Get_MouldStockBillMainTemp(string sWhere) { try { ds = MouldStockBillMainTemp(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "æ æ°æ®"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } public static DataSet MouldStockBillMainTemp(string sWhere) { string sql1 = string.Format(@"select * from h_v_Gy_MouldStockBillMainTempList where 1=1 "); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by hitemid desc", "h_v_Gy_MouldStockBillMainTempList"); } else { string sql = sql1 + sWhere + "order by hitemid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_MouldStockBillMainTempList"); } } #endregion #region [çç¹è®°å½å é¤åè½] [Route("Gy_StockCheckItemBill/set_DeleteBill_Temp")] [HttpGet] public object set_DeleteBill_Temp(string HItemID) { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HItemID); if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCn.RunProcReturn("select * from Sc_MouldStockBillMain_Temp where HItemID=" + lngBillKey, "Sc_MouldStockBillMain_Temp"); if (ds != null) { oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HItemID=" + lngBillKey); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å é¤æåï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®ä¸åå¨ï¼è¯·æ¥çæ¯å¦éå¤å é¤"; objJsonResult.data = null; return objJsonResult; } } #endregion #region çç¹åæå®¡æ ¸ #region è°æ¨âç´æ¥è°æ¨ [Route("Gy_StockCheckItemBill/MakeProdMove")] [HttpPost] public object MakeProdMove([FromBody] JObject msg) { try { 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 string userID = sArray[2].ToString();//userID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ ListModels oListModels = new ListModels(); List<Models.Cls_InventoryAnalysisList> lsmain = new List<Models.Cls_InventoryAnalysisList>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); lsmain = oListModels.getObjectByJson_Gy_StockCheckItemBill(msg2); foreach (Models.Cls_InventoryAnalysisList item in lsmain) { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr1 = ds1.Tables[0].Rows[0]; HInterID = DBUtility.ClsPub.CreateBillID("3814", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3814", ref DBUtility.ClsPub.sExeReturnInfo, true); string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3814','3814'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" + HDate + "','" + sName + "'" + ", " + dr["HSupID"].ToString() + ", 1," + dr["HNowSupID"].ToString() + ",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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "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); //ä¿®æ¹å¨å ·æ¡£æ¡ä½ç½® string sql2 = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{HInterID.ToString()}' "); oCn.RunProc(sql2); oCn.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; } return objJsonResult; } #endregion #region ççâå ¶ä»å ¥åºå [Route("Gy_StockCheckItemBill/MakeOtherIn")] [HttpPost] public object MakeOtherIn([FromBody] JObject msg) { try { 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 string userID = sArray[2].ToString();//userID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ ListModels oListModels = new ListModels(); List<Models.Cls_InventoryAnalysisList> lsmain = new List<Models.Cls_InventoryAnalysisList>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); lsmain = oListModels.getObjectByJson_Gy_StockCheckItemBill(msg2); foreach (Models.Cls_InventoryAnalysisList item in lsmain) { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr1 = ds1.Tables[0].Rows[0]; HInterID = DBUtility.ClsPub.CreateBillID("3827", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3827", ref DBUtility.ClsPub.sExeReturnInfo, true); string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3827','3827'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" +HDate + "','" + sName + "'" + ", " + 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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "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); //ä¿®æ¹å¨å ·æ¡£æ¡ä½ç½® string sql2 = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{HInterID.ToString()}' "); oCn.RunProc(sql2); oCn.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; } return objJsonResult; } #endregion #region çäºâå¤çåºåºå [Route("Gy_StockCheckItemBill/MakeScrapOut")] [HttpPost] public object MakeScrapOut([FromBody] JObject msg) { try { 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 string userID = sArray[2].ToString();//userID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ ListModels oListModels = new ListModels(); List<Models.Cls_InventoryAnalysisList> lsmain = new List<Models.Cls_InventoryAnalysisList>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); lsmain = oListModels.getObjectByJson_Gy_StockCheckItemBill(msg2); foreach (Models.Cls_InventoryAnalysisList item in lsmain) { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; string sql, sql1; Int64 HInterID = 0;//æ¾ç¤ºçå段 HInterID = DBUtility.ClsPub.CreateBillID("3828", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3828", ref DBUtility.ClsPub.sExeReturnInfo, true); DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); DataRow dr = ds.Tables[0].Rows[0]; if (HItemID == 0) { sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3828','3828'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','"+ HDate + "','" + sName + "'" + ",0,0," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + ") "; 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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + ",0,0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + ",0,0,0,0" + ",0,0,0," + userID + ",0,100005,'')"); } else { ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr1 = ds1.Tables[0].Rows[0]; sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3832','3832'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "',getdate()" + ",'" + sName + "'" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + ") "; 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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "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); //ä¿®æ¹å¨å ·æ¡£æ¡ä½ç½® string sql2 = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{HInterID.ToString()}' "); oCn.RunProc(sql2); oCn.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; } return objJsonResult; } #endregion #region åºåºâé¢ç¨åºåºå [Route("Gy_StockCheckItemBill/MakeProdOut")] [HttpPost] public object MakeProdOut([FromBody] JObject msg) { try { 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 string userID = sArray[2].ToString();//userID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ ListModels oListModels = new ListModels(); List<Models.Cls_InventoryAnalysisList> lsmain = new List<Models.Cls_InventoryAnalysisList>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); lsmain = oListModels.getObjectByJson_Gy_StockCheckItemBill(msg2); foreach (Models.Cls_InventoryAnalysisList item in lsmain) { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr1 = ds1.Tables[0].Rows[0]; HInterID = DBUtility.ClsPub.CreateBillID("3802", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3802", ref DBUtility.ClsPub.sExeReturnInfo, true); string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3802','3802'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" +HDate + "','" + sName + "'" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "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() + ",'1548785'," + 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); //ä¿®æ¹å¨å ·æ¡£æ¡ä½ç½® string sql2 = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{HInterID.ToString()}' "); oCn.RunProc(sql2); oCn.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; } return objJsonResult; } #endregion #region éåºâé¢ç¨éåºå [Route("Gy_StockCheckItemBill/MakeProdBack")] [HttpPost] public object MakeProdBack([FromBody] JObject msg) { try { 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 string userID = sArray[2].ToString();//userID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ ListModels oListModels = new ListModels(); List<Models.Cls_InventoryAnalysisList> lsmain = new List<Models.Cls_InventoryAnalysisList>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); lsmain = oListModels.getObjectByJson_Gy_StockCheckItemBill(msg2); foreach (Models.Cls_InventoryAnalysisList item in lsmain) { var HBarCode = item.HBarCode; var HItemID = item.HItemID; string HBillNo = ""; Int64 HInterID = 0;//æ¾ç¤ºçå段 DataSet ds1 = new DataSet(); ds = oCn.RunProcReturn("select * from Gy_MouldFileMain where HBarCode='" + HBarCode + "'", "Gy_MouldFileMain"); ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr1 = ds1.Tables[0].Rows[0]; HInterID = DBUtility.ClsPub.CreateBillID("3803", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3803", ref DBUtility.ClsPub.sExeReturnInfo, true); string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3803','3803'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" +HDate + "','" + sName + "'" + ", " + dr["HNowSupID"].ToString() + "," + dr["HNowSupTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",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, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "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); //ä¿®æ¹å¨å ·æ¡£æ¡ä½ç½® string sql2 = string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{HInterID.ToString()}' "); oCn.RunProc(sql2); oCn.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; } return objJsonResult; } #endregion #region å é¢ç¨éåºåé¢ç¨åºåº [Route("Gy_StockCheckItemBill/MakeProdOutBack")] [HttpPost] public object MakeProdOutBack([FromBody] JObject msg) { MakeProdBack(msg); MakeProdOut(msg); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æåï¼"; //WebAPIController.Add_Log("éè´§åä¸æ¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } #endregion #endregion } }
