派生自 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")] @@ -254,24 +254,17 @@ #region çç¹åæå表 [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")] [HttpGet] public object Get_InventoryAnalysisList(string sWhere) public object Get_InventoryAnalysisList(string sWhere,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>();//éåº string sql; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql; if (sWhere != null&&sWhere!="") if (sID == null || sID == "") { sql = string.Format(@"select k.HBarCode æ¡ç ,m.HNumber å¨å ·ç¼å·,s.HName çç¹æ¹æ¡, sql = string.Format(@"select k.HBarCode æ¡ç ,m.HBillNo å¨å ·ç¼å·,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 è´¦é¢ä½ç½®ç±»å, @@ -280,16 +273,16 @@ 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_Supplier p1 on m.HNowSupID=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()"); left join Gy_Customer c1 on m.HNowSupID=c1.HItemID left join Gy_Warehouse w on k.HCorrespondentID=w.HItemID left join Gy_Warehouse w1 on m.HNowSupID=w1.HItemID where k.HBillType='3822' and " + sWhere); } else { sql = string.Format(@"select k.HBarCode æ¡ç ,m.HNumber å¨å ·ç¼å·,s.HName çç¹æ¹æ¡, sql = string.Format(@"select k.HBarCode æ¡ç ,m.HBillNo å¨å ·ç¼å·,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 è´¦é¢ä½ç½®ç±»å, @@ -298,111 +291,15 @@ 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_Supplier p1 on m.HNowSupID=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"); left join Gy_Customer c1 on m.HNowSupID=c1.HItemID left join Gy_Warehouse w on k.HCorrespondentID=w.HItemID left join Gy_Warehouse w1 on m.HNowSupID=w1.HItemID where k.HBillType='3822' and " + sWhere + " and k.HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and k.HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ")"); } 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); } list.Add(ds.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; @@ -420,9 +317,98 @@ } #endregion #region çç¹è®°å½å表 [Route("Gy_StockCheckItemBill/Get_MouldStockBillMainTemp")] [HttpGet] public object Get_MouldStockBillMainTemp(string sWhere) { try { ds = MouldStockBillMainTemp(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; } } 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 å¶åæ¥æ desc", "h_v_Gy_MouldStockBillMainTempList"); } else { string sql = sql1 + sWhere + "order by å¶åæ¥æ 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")] [Route("Gy_StockCheckItemBill/MakeProdMove")] [HttpGet] public object MakeProdMove(string HBarCode, string user, string userID) {
