派生自 MES-WEB-API
WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs
@@ -1,5 +1,8 @@ using Newtonsoft.Json; using DAL; using DBUtility; using Newtonsoft.Json; using Newtonsoft.Json.Converters; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; @@ -22,8 +25,12 @@ private WebS.WebService1 oWebs = new WebS.WebService1(); //è·åç³»ç»åæ° Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); public Int64 HInterID = 0; //å ç public string ModName = "85"; public string HOrgNumber = ""; public Int64 HOrgID = -1; public string SourceQtyCtl = ""; //è¶ æºåæ°éæ§å¶ #region æ¡ç çæ @@ -62,7 +69,7 @@ } else { list.Add(""); list.Add(CampanyName); } objJsonResult.code = "1"; objJsonResult.count = 1; @@ -125,7 +132,7 @@ list.Add("å¯ä¸æ¡ç "); list.Add("åç§æ¡ç "); list.Add("æ¹æ¬¡æ¡ç "); //list.Add("æçæ¡ç "); list.Add("æçæ¡ç "); } objJsonResult.code = "1"; objJsonResult.count = 1; @@ -149,6 +156,7 @@ [HttpGet] public object ReportFromBillList(int page, int limit, string sWhere,string HSouceBillType,string HOrgID) { oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo); List<object> columnNameList = new List<object>(); try { @@ -169,35 +177,66 @@ { case "ç产订å": tabname = "h_v_IFCLD_ICMOBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IFCLD_ICMOBillList_Source "+sWhere+ " and ä»»å¡æ°é>isnull(å ¥åºæ°é,0) and ç¶æ<>'ç»æ¡' order by åæ®å·", "h_v_IFCLD_ICMOBillList_Source").Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å·) as HRowNumber,* from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and ä»»å¡æ°é>isnull(å ¥åºæ°é,0) and ç¶æ<>'ç»æ¡') as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IFCLD_ICMOBillList_Source "+sWhere+ " and ä»»å¡æ°é>isnull(å ¥åºæ°é,0) and ç¶æ<>'ç»æ¡' order by åæ®å·", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select row_number() over (order by åæ®å·) as HRowNumber,* from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and ä»»å¡æ°é>isnull(å ¥åºæ°é,0) and ç¶æ<>'ç»æ¡') as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "ç产æ±æ¥å": tabname = "h_v_IF_ICMOReportBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ICMOReportBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_ICMOReportBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "éè´è®¢å": tabname = "h_v_IF_POOrderBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POOrderBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POOrderBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "æ¶æéç¥å": tabname = "h_v_IF_POInStockBillList_Source"; if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") { count = new SQLHelper.ClsCN().RunProcReturn("select top 1000 * from h_v_IF_POInStockBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select top 1000 row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); } else { count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POInStockBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); } break; case "å§å¤è®¢å": tabname = "h_v_IF_EntrustOrderBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_EntrustOrderBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_EntrustOrderBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "éè´§éç¥å": case "çäº§å ¥åºå": tabname = "h_v_IF_ProductInBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProductInBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_ProductInBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "å ¶ä»å ¥åºå": case "éè´å ¥åºå": tabname = "h_v_IF_POStockInBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POStockInBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POStockInBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "ç´æ¥è°æ¨å": break; case "éè´éæå": case "éå®éè´§å": tabname = "h_v_IF_SellOutBackBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBackBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_SellOutBackBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "ç产éæå": break; case "ç»è£ æå¸å": tabname = "h_v_IF_MateOutBackBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MateOutBackBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_MateOutBackBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; default: break; } ds = new SQLHelper.ClsCN().RunProcReturn(sql, tabname); string aa = ds.Tables[0].Columns[0].ToString(); //ds.Tables[0].Columns["hmainid"].ColumnName.ToUpper(); //ds.Tables[0].Columns["hsubid"].ColumnName.ToUpper(); ds.Tables[0].Columns["hmainid"].ColumnName = "HMainID"; ds.Tables[0].Columns["hsubid"].ColumnName = "HSubID"; foreach (DataColumn col in ds.Tables[0].Columns) { @@ -238,6 +277,1135 @@ } #endregion #region [éè¿æ¡ç ç¼å·è·åHItemId] [Route("Sc_BarCode/Get_HItemId")] [HttpGet] public object Get_HItemId(string sWhere) { List<object> columnNameList = new List<object>(); try { ds = oCN.RunProcReturn("select * from h_v_IF_BarCodeBillList where æ¡ç ç¼å· = '" + sWhere + "'", "h_v_IF_BarCodeBillList"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message.ToString(); objJsonResult.data = null; objJsonResult.list = columnNameList; } return objJsonResult; } #endregion #region [éè¿éæ©çæºåä¿¡æ¯æ¥æ¾æºåæ°æ®] [Route("Sc_BarCode/SelectReportFromBillList")] [HttpPost] public object SelectReportFromBillList([FromBody] JObject msg) { //List<DBUtility.BillSelect> oList,string HBarCodeType var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string HSourceBillType = sArray[1].ToString(); string HBarCodeType = sArray[2].ToString(); string UserName = sArray[3].ToString(); ClsPub.CurUserName = UserName; ListModels oListModels = new ListModels(); List<object> ListRows = new List<object>(); try { msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n List<DBUtility.BillSelect> oList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<DBUtility.BillSelect>>(msg2); foreach (DBUtility.BillSelect oSelectRow in oList) { HSouceOrderList ordrlist = new HSouceOrderList(); switch (oSelectRow.BillType) { case "3710": //ç产订å //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IFCLD_ICMOList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IFCLD_ICMOList"); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList(ds.Tables[0],ordrlist, HBarCodeType)); break; case "3711": //ç产æ±æ¥å //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_ICMOReportList"); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1102": //éè´è®¢å //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IF_POOrderList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_POOrderList"); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1103": //æ¶æéç¥å //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IF_POInStockList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_POInStockList"); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1601": //å§å¤è®¢å //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IF_EntrustOrderList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_EntrustOrderList"); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1202": //çäº§å ¥åº //å¾å°ä¿¡æ¯ ds = oWebs.getDataSetBySQL("select * from h_v_IF_ProductInBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_ProductInBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo); //åå ¥ä¿¡æ¯ ListRows.Add(Sub_WriteInForm_InOut(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1201": //éè´å ¥åº //å¾å°ä¿¡æ¯ ds = oWebs.getDataSetBySQL("select * from h_v_IF_POStockInBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_POStockInBillList_Source ", ref DBUtility.ClsPub.sExeReturnInfo); //åå ¥ä¿¡æ¯ ListRows.Add(Sub_WriteInForm_InOut(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1247": //éå®éè´§ //å¾å°ä¿¡æ¯ ds = oWebs.getDataSetBySQL("select * from h_v_IF_SellOutBackBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_SellOutBackBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo); //åå ¥ä¿¡æ¯ ListRows.Add(Sub_WriteInForm_InOut(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1244": //ç产éæ //å¾å°ä¿¡æ¯ ds = oWebs.getDataSetBySQL("select * from h_v_IF_MateOutBackBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_MateOutBackBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo); //åå ¥ä¿¡æ¯ ListRows.Add(Sub_WriteInForm_InOut(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; case "1403": //éè´§éç¥å break; case "1203": //å ¶ä»å ¥åºå break; case "1207": //ç´æ¥è°æ¨å break; case "1239": //éè´éæå break; case "1255": //ç»è£ æå¸å break; default: break; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è·åæ°æ®æå!"; objJsonResult.data = null; objJsonResult.list = ListRows; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message.ToString(); objJsonResult.data = null; objJsonResult.list = ListRows; } return objJsonResult; } public object HSourceOrderList(DataTable dt, HSouceOrderList ordrlist,string HBarCodeType) { for (int i = 0; i < dt.Rows.Count; i++) { ordrlist.HQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); ordrlist.HMainID = dt.Rows[i]["hmainid"].ToString(); ordrlist.HSubID = dt.Rows[i]["hsubid"].ToString(); ordrlist.HBillNo = dt.Rows[i]["åæ®å·"].ToString(); ordrlist.HSourceBillNo = dt.Rows[i]["åæ®å·"].ToString(); ordrlist.HBillType = dt.Rows[i]["HBillType"].ToString(); ordrlist.HDate = dt.Rows[i]["æ¥æ"].ToString(); //åæ¥ æ¶æåæ®æ¥æ ordrlist.HShowDate = DateTime.Now.ToString(); ordrlist.HSupID = dt.Rows[i]["hsupid"].ToString(); ordrlist.HSupNumber = dt.Rows[i]["ä¾åºå代ç "].ToString(); ordrlist.HSupName = dt.Rows[i]["ä¾åºå"].ToString(); ordrlist.HDeptID = dt.Rows[i]["HDeptID"].ToString(); ordrlist.HDeptNumber = dt.Rows[i]["é¨é¨ä»£ç "].ToString(); ordrlist.HDeptName = dt.Rows[i]["é¨é¨"].ToString(); ordrlist.HMaterID = dt.Rows[i]["HMaterID"].ToString(); ordrlist.HMaterNumber = dt.Rows[i]["ç©æ代ç "].ToString(); ordrlist.HMaterName = dt.Rows[i]["ç©æå称"].ToString(); ordrlist.HMaterModel = dt.Rows[i]["è§æ ¼åå·"].ToString(); ordrlist.HBatchNo = dt.Rows[i]["æ¹æ¬¡"].ToString(); ordrlist.HUnitID = dt.Rows[i]["HUnitID"].ToString(); ordrlist.HUnitNumber = dt.Rows[i]["计éåä½ä»£ç "].ToString(); ordrlist.HUnitName = dt.Rows[i]["计éåä½"].ToString(); ordrlist.HRemark = dt.Rows[i]["å¤æ³¨"].ToString(); ordrlist.HMTONo = dt.Rows[i]["计åè·è¸ªå·"].ToString(); ordrlist.HCusID = dt.Rows[i]["HCusID"].ToString(); ordrlist.HCusNumber = dt.Rows[i]["客æ·ä»£ç "].ToString(); ordrlist.HCusName = dt.Rows[i]["客æ·"].ToString(); ordrlist.HCusType = dt.Rows[i]["客æ·åå·"].ToString(); ordrlist.HPinfanBarCode = dt.Rows[i]["HPinfanBarCode"].ToString(); ordrlist.HPinfan = dt.Rows[i]["HPinfan"].ToString(); ordrlist.HSourceName = dt.Rows[i]["ç产线"].ToString(); ordrlist.HEndDate = dt.Rows[i]["计åå®å·¥æ¥æ"].ToString();//åæ¥ ç产订å 失ææ¥æ ordrlist.HMinQty = dt.Rows[i]["æå°å è£ æ°"].ToString(); if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); } else if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å"|| HBarCodeType == "仪å¨æåæ¡ç è§å"|| HBarCodeType == "è¯åæåæ¡ç è§å") { ordrlist.HMinQty = "1"; } else { ordrlist.HMinQty = dt.Rows[i]["æå°å è£ æ°"].ToString(); } } return ordrlist; } public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType,string HSourceBillType) { oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo); for (int i = 0; i < dt.Rows.Count; i++) { ordrlist.HQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); ordrlist.HMainID = dt.Rows[i]["hmainid"].ToString(); ordrlist.HSubID = dt.Rows[i]["hsubid"].ToString(); ordrlist.HBillNo = dt.Rows[i]["åæ®å·"].ToString(); ordrlist.HBillType = dt.Rows[i]["HBillType"].ToString(); ordrlist.HDate = dt.Rows[i]["æ¥æ"].ToString(); //åæ¥ æ¶æåæ®æ¥æ ordrlist.HShowDate = DateTime.Now.ToString(); ordrlist.HDeptID = dt.Rows[i]["HDeptID"].ToString(); ordrlist.HDeptNumber = dt.Rows[i]["é¨é¨ä»£ç "].ToString(); ordrlist.HDeptName = dt.Rows[i]["é¨é¨"].ToString(); ordrlist.HMaterID = dt.Rows[i]["HMaterID"].ToString(); ordrlist.HMaterNumber = dt.Rows[i]["ç©æ代ç "].ToString(); ordrlist.HMaterName = dt.Rows[i]["ç©æå称"].ToString(); ordrlist.HMaterModel = dt.Rows[i]["è§æ ¼åå·"].ToString(); ordrlist.HBatchNo = dt.Rows[i]["æ¹æ¬¡"].ToString(); ordrlist.HUnitID = dt.Rows[i]["HUnitID"].ToString(); ordrlist.HUnitNumber = dt.Rows[i]["计éåä½ä»£ç "].ToString(); ordrlist.HUnitName = dt.Rows[i]["计éåä½"].ToString(); ordrlist.HRemark = dt.Rows[i]["å¤æ³¨"].ToString(); ordrlist.HMTONo = dt.Rows[i]["计åè·è¸ªå·"].ToString(); if(HSourceBillType == "æ¶æéç¥å") { if (oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º") { ordrlist.HFurnaceNO = dt.Rows[i]["çå·"].ToString(); ordrlist.HCoilNO = dt.Rows[i]["é¢å·æå å·"].ToString(); ordrlist.HheatNO = dt.Rows[i]["çå¤ç"].ToString(); } } if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); } else if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å") { ordrlist.HMinQty = "1"; } else { ordrlist.HMinQty = dt.Rows[i]["æå°å è£ æ°"].ToString(); } ordrlist.HMaker = ClsPub.CurUserName; if (HSourceBillType== "æ¶æéç¥å"|| HSourceBillType== "éè´è®¢å"|| HSourceBillType=="å§å¤è®¢å"|| HSourceBillType== "éè´å ¥åºå") { ordrlist.HInnerBillNo = dt.Rows[i]["å é¨éè´è®¢åå·"].ToString(); ordrlist.HSupID= dt.Rows[i]["hsupid"].ToString(); ordrlist.HSupNumber = dt.Rows[i]["ä¾åºå代ç "].ToString(); ordrlist.HSupName = dt.Rows[i]["ä¾åºå"].ToString(); if (HSourceBillType == "æ¶æéç¥å") { if (dt.Rows[i]["æ¯å¦èµ å"].ToString() == "æ¯") { ordrlist.HGiveAwayFlag = 1; } else { ordrlist.HGiveAwayFlag = 0; } } } if (HSourceBillType == "éè´§éç¥å") { ordrlist.HCusID = dt.Rows[i]["HCusID"].ToString(); ordrlist.HCusNumber = dt.Rows[i]["客æ·ä»£ç "].ToString(); ordrlist.HCusName= dt.Rows[i]["客æ·"].ToString(); } if (HSourceBillType == "å ¶ä»å ¥åºå") { ordrlist.HWhID = dt.Rows[i]["HWhID"].ToString(); ordrlist.HWhNumber = dt.Rows[i]["ä»åºä»£ç "].ToString(); ordrlist.HWhName = dt.Rows[i]["ä»åº"].ToString(); ordrlist.HSPID = dt.Rows[i]["HSPID"].ToString(); ordrlist.HSPNumber = dt.Rows[i]["ä»ä½ä»£ç "].ToString(); ordrlist.HSPName = dt.Rows[i]["ä»ä½"].ToString(); } } return ordrlist; } //æ ¹æ®TABLEåå ¥çé¢(åºå ¥åºåæ®) private object Sub_WriteInForm_InOut(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType, string HSourceBillType) { for (int i = 0; i < dt.Rows.Count; i++) { ordrlist.HQty = dt.Rows[i]["å¯çææ¡ç æ°é"].ToString(); ordrlist.HinitQty = dt.Rows[i]["å¯çææ¡ç æ°é"].ToString(); ordrlist.HMinQty = dt.Rows[i]["æå°å è£ æ°"].ToString(); ordrlist.HMainID = dt.Rows[i]["HMainID"].ToString(); ordrlist.HSubID = dt.Rows[i]["HSubID"].ToString(); ordrlist.HBillNo = dt.Rows[i]["åæ®å·"].ToString(); ordrlist.HBillType = dt.Rows[i]["HBillType"].ToString(); ordrlist.HDeptID = dt.Rows[i]["HDeptID"].ToString(); ordrlist.HDeptNumber = dt.Rows[i]["é¨é¨ä»£ç "].ToString(); ordrlist.HDeptName = dt.Rows[i]["é¨é¨"].ToString(); ordrlist.HMaterID = dt.Rows[i]["HMaterID"].ToString(); ordrlist.HMaterNumber = dt.Rows[i]["ç©æ代ç "].ToString(); ordrlist.HMaterName = dt.Rows[i]["ç©æå称"].ToString(); ordrlist.HMaterModel = dt.Rows[i]["è§æ ¼åå·"].ToString(); ordrlist.HBatchNo = dt.Rows[i]["æ¹å·"].ToString(); ordrlist.HUnitID = dt.Rows[i]["HUnitID"].ToString(); ordrlist.HUnitNumber = dt.Rows[i]["计éåä½ä»£ç "].ToString(); ordrlist.HUnitName = dt.Rows[i]["计éåä½"].ToString(); ordrlist.HAuxPropID = dt.Rows[i]["HAuxPropID"].ToString(); ordrlist.HAuxPropNumber = dt.Rows[i]["è¾ å©å±æ§ä»£ç "].ToString(); ordrlist.HAuxPropName = dt.Rows[i]["è¾ å©å±æ§"].ToString(); ordrlist.HWhID = dt.Rows[i]["HWhID"].ToString(); ordrlist.HWhNumber = dt.Rows[i]["ä»åºä»£ç "].ToString(); ordrlist.HWhName = dt.Rows[i]["ä»åº"].ToString(); ordrlist.HSPID = dt.Rows[i]["HSPID"].ToString(); ordrlist.HSPNumber = dt.Rows[i]["ä»ä½ä»£ç "].ToString(); ordrlist.HSPName = dt.Rows[i]["ä»ä½"].ToString(); ordrlist.HMTONo = dt.Rows[i]["计åè·è¸ªå·"].ToString(); ordrlist.HDate = dt.Rows[i]["æ¥æ"].ToString(); ordrlist.HShowDate = DateTime.Now.ToString(); } return ordrlist; } #endregion #region [åæ¥èµæ] [Route("Sc_BarCode/Sync_data")] [HttpGet] public object Sync_data() { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { oCn.RunProc("exec h_p_IF_ERPDataToLocal", ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åæ¥åºç¡èµææåï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åæ¥åºç¡èµæ失败ï¼" + e; objJsonResult.data = null; return objJsonResult; } } #endregion #region [æ¹æ¬¡] [Route("Sc_BarCode/Batch")] [HttpGet] public object Batch(int HMaterID, string HBatchNo) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); bool b = false; if (HMaterID != 0) { DataSet oDs = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_GetBatchNo " + HMaterID.ToString() + ",'" + HBatchNo + "','" + "" + "','" + "" + "'", "h_p_Gy_BarCodeBill_GetBatchNo"); // if (oDs == null && oDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "1"; objJsonResult.Message="çææ¹æ¬¡å¤±è´¥ï¼"; return objJsonResult; } else if (DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][0]) == "1") { objJsonResult.code = "1"; objJsonResult.Message = "çææ¹æ¬¡æåï¼"; objJsonResult.data = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]); HBatchNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]); b = true; return objJsonResult; } } //æç»è¡¨æ¯å¦ä¸ºé¶è¡ if (b == false) { objJsonResult.code = "1"; objJsonResult.Message="没æéè¦çææ¹æ¬¡çæç»è¡ï¼"; return objJsonResult; } else //å®å ¨å°é { return null; } } #endregion #region [æ¡ç çææ¥å£] [Route("Sc_BarCode/Sub_SaveBill")] [HttpPost] public object Sub_SaveBill([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 HOrgType = sArray[1].ToString(); string HSourceBillTypeName = sArray[2].ToString(); string HSelectBarCodeType = sArray[3].ToString(); string CampanyName = sArray[4].ToString()=="xxx"?"": sArray[4].ToString(); string UserName = sArray[5].ToString(); ClsPub.CurUserName = UserName; //è·åå ç HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo); DAL.ClsGy_ORGANIZATIONS_View oClsGy_ORGANIZATIONS_View = new DAL.ClsGy_ORGANIZATIONS_View(); HOrgNumber = ""; if (oClsGy_ORGANIZATIONS_View.GetInfoByName(HOrgType)) { HOrgID = oClsGy_ORGANIZATIONS_View.omodel.HItemID; HOrgNumber = DBUtility.ClsPub.isStrNull(oClsGy_ORGANIZATIONS_View.omodel.HNumber); } if (HOrgID == -1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "éæ©ç»ç»æé误!"; return objJsonResult; } if (!Sub_AllowSave(msg2, HSelectBarCodeType))//åæ®å®æ´æ§å¤æ { return objJsonResult; } if (HSelectBarCodeType == "仪å¨æåæ¡ç è§å") { //客æ·å®å¶ } else { //çææ¡ç SaveBarCode(msg2, HSelectBarCodeType, CampanyName, HSourceBillTypeName); } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç çæ失败!"+e.Message; return objJsonResult; } return objJsonResult; } #endregion #region[åæ®å®æ´æ§å¤æ] private bool Sub_AllowSave(string msg2, string HSelectBarCodeType) { msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n List<HSouceOrderList> ordrlist = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HSouceOrderList>>(msg2); string sHRemark = ""; for (int i = 0; i < ordrlist.Count; i++) { long HSno = i + 1; // åºå· string HBarCodeType = HSelectBarCodeType; // æ¡ç ç±»å string HSourceBillNo = DBUtility.ClsPub.isStrNull(ordrlist[i].HBillNo); // æºååå· long HMaterID = DBUtility.ClsPub.isLong(ordrlist[i].HMaterID); // ç©æå ç string HBatchNo = DBUtility.ClsPub.isStrNull(ordrlist[i].HBatchNo); // æ¹å· long HAuxPropID = DBUtility.ClsPub.isLong(ordrlist[i].HAuxPropID); // è¾ å©å±æ§ID double HSourceQty = DBUtility.ClsPub.isDoule(ordrlist[i].HMinQty); // æºåæ°é double HQty = DBUtility.ClsPub.isDoule(ordrlist[i].HQty); // æ°é double HMinQty = DBUtility.ClsPub.isDoule(ordrlist[i].HMinQty); // æå°å è£ æ° if (HMaterID != 0) { DataSet oDsCheck = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_AddCheck " + HSno.ToString() + ",'" + HBarCodeType + "','" + HSourceBillNo + "'," + HMaterID.ToString() + ",'" + HBatchNo + "'," + HAuxPropID.ToString() + "," + HSourceQty.ToString() + "," + HQty.ToString() + "," + HMinQty.ToString() + "," + HOrgID.ToString() + ",'" + SourceQtyCtl + "'", "h_p_Gy_BarCodeBill_AddCheck"); if (oDsCheck == null && oDsCheck.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç çæå®æ´æ§å¤æé误"; return false; } else if (DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0][0]) == "1") { sHRemark = sHRemark + DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HRemark"]); } } } if (sHRemark != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = sHRemark; return false; } return true; } #endregion #region[æ¡ç çææ¹æ³] private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName,string HSourceBillTypeName) { int LSHlen = 6; //æµæ°´å·é¿åº¦ int SumLen = 10; //æ»é¿åº¦ string TM = ""; //æ¡ç string HNumber = ""; //ç©æå ç string HMaterNumber = ""; //ç©æ代ç double HSumQty = 0; //产åæ°é double HMinQty = 0; //æå°å è£ æ° int HBQty = 0; //ç®±æ° double HQty = 0; //æ°é string WeiShu = ""; //å°¾æ° int LSH = 0; //æµæ°´å· string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 string sDate = ""; //æ¥æ string sYear = ""; //å¹´ string sPeriod = ""; //æ string sDay = ""; //æ¥ string HBatchNo = ""; //æ¹æ¬¡ string HYasuoji = ""; //åç¼©æº string HModelName = ""; //æºå string HICMOBillNo = ""; //æºåå· string HBarCodeBatchNo = ""; //æ¡ç æ¹æ¬¡å· string HBarCodeDate = ""; //æ¡ç æ¥æ int k = 0; int n = 0; //åä¸æ¹çææ¡ç ä¸ç第å æ¡ string sTMNumber = ""; //æ¡ç èªå®ä¹åç¼ string HCoilNO = ""; string HFurnaceNO = ""; string HFactory = ""; decimal HAuxQty = 0; string HheatNO = ""; DataSet Ds; msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n List<HSouceOrderList> ordrlist = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HSouceOrderList>>(msg2); List<HBarCodeList> ListRows = new List<HBarCodeList>(); for (int j = 0; j < ordrlist.Count; j++) { if (ClsPub.isLong(ordrlist[j].HMaterID) != 0) { HNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterID); HMaterNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterNumber); HBatchNo = ClsPub.isStrNull(ordrlist[j].HBatchNo); HCoilNO = ClsPub.isStrNull(ordrlist[j].HCoilNO); HFurnaceNO = ClsPub.isStrNull(ordrlist[j].HFurnaceNO); HFactory = ClsPub.isStrNull(ordrlist[j].HFactory); HAuxQty = ClsPub.isLong(ordrlist[j].HAuxQty); HheatNO = ClsPub.isStrNull(ordrlist[j].HheatNO); //æ¥æè·åæ¹å¼ sDate = DateTime.Now.ToString(); // if (HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") //åæ®æ¥æ(æ¶æéç¥å) { sDate = DBUtility.ClsPub.isStrNull(ordrlist[j].HDate); } else if (HSelectBarCodeType == "è¯åæåæ¡ç è§å")// 失ææ¥æï¼ç产订åï¼ { sDate = DBUtility.ClsPub.isStrNull(ordrlist[j].HEndDate); } else if (CampanyName == "å¤å®çµå¨")// æ¥æï¼ç产订å æ¡ç æ¥æ { sDate = DBUtility.ClsPub.isStrNull(ordrlist[j].HDate); } HYasuoji = DBUtility.ClsPub.isStrNull(ordrlist[j].HPinfan); //å缩æºä»£ç ï¼å¤å®çµå¨ï¼ HModelName = DBUtility.ClsPub.isStrNull(ordrlist[j].HCusType); //æºåï¼å¤å®çµå¨ï¼ HICMOBillNo = DBUtility.ClsPub.isStrNull(ordrlist[j].HSourceBillNo); //ç产订åå·ï¼å¤å®çµå¨ï¼ HBarCodeBatchNo = DBUtility.ClsPub.isStrNull(ordrlist[j].HPinfanBarCode); //æ¡ç æ¹æ¬¡å·ï¼å¤å®çµå¨ï¼ HBarCodeDate = DBUtility.ClsPub.isStrNull(ordrlist[j].HSupNumber); //æ¡ç æ¥æï¼å¤å®çµå¨ï¼ // sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); sDay = sDay.Substring(sDay.Length - 2, 2); //================================== if (HSelectBarCodeType == "å¯ä¸æ¡ç ") { if (CampanyName == "åå") //ç³»ç»åæ° å®¢æ·å®å¶åå称 { //æ¡ç åç¼ = ç©æ代ç + å¹´ + æ + æ¥ sTMNumber = HNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else if (CampanyName == "é£é¾") { string HWorksNumber = ""; HWorksNumber = CampanyName; if (HWorksNumber == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å·¥å代ç ä¸è½ä¸ºç©º!"; return objJsonResult; } //æ¡ç åç¼ = å·¥å代ç + ç©æå ç + æ¥æ sTMNumber = HWorksNumber + HNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else if (CampanyName == "çä¸ç¥º") { var date = DateTime.Now.ToString("yyMMdd");//æ¥æ if (HSourceBillTypeName == "æ¶æéç¥å") { //ç©æ代ç -å è£ æ è¯-æ¥æ-ä¾åºå代ç -å «ä½æµæ°´å· LSHlen = 8;//æµæ°´å·æ¯8ä½ DataSet dataDs = oCN.RunProcReturn($@"select isnull(pr.FNUMBER,'') F_TEZV_BASE from AIS20220308151944..T_PUR_Receive a inner join AIS20220308151944..T_PUR_RECEIVEENTRY b on a.FID = b.FID left join AIS20220308151944..T_BAS_PREBDONE pr on b.F_TEZV_BASE=pr.FID where a.FID={ordrlist[j].HMainID} and b.FENTRYID={ordrlist[j].HSubID}", "T_PUR_Receive"); if (dataDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸åå¨ï¼"; return objJsonResult; } sTMNumber = ordrlist[j].HMaterNumber + "-" + dataDs.Tables[0].Rows[0]["F_TEZV_BASE"].ToString() + "-" + date + "-" + ordrlist[j].HSupNumber + "-"; //sTMNumber = ordrlist[j].HMaterNumber + "-å è£ æ è¯-" + date + "-" + ordrlist[j].HSupNumber + "-"; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else if (HSourceBillTypeName == "çäº§å ¥åºå") { //ç©æ代ç -å è£ æ è¯-æ¥æ-ç»ç»ä»£ç -å «ä½æµæ°´å· LSHlen = 8;//æµæ°´å·æ¯8ä½ DataSet dataDs = oCN.RunProcReturn($@"select isnull(pr.FNUMBER,'') F_bsv_Base1,a.FPRDORGID from AIS20220308151944..T_PRD_INSTOCK a inner join AIS20220308151944..T_PRD_INSTOCKENTRY b on a.FID = b.FID join( select HERPInterID, HERPEntryID, HInterID, HEntryID from Kf_ICStockBillSub )kf on b.FID = kf.HERPInterID and b.FENTRYID = kf.HERPEntryID left join AIS20220308151944..T_BAS_PREBDONE pr on b.F_bsv_Base1=pr.FID where kf.HInterID = {ordrlist[j].HMainID} and kf.HEntryID = {ordrlist[j].HSubID}", "T_PRD_INSTOCK"); if (dataDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸åå¨ï¼"; return objJsonResult; } string RQHNumber = ""; if (dataDs.Tables[0].Rows[0]["FPRDORGID"].ToString() == "100014")//æ±è { RQHNumber = "1.07.008"; } else if (dataDs.Tables[0].Rows[0]["FPRDORGID"].ToString() == "100012")//ä¸æµ· { RQHNumber = "1.04.008"; } sTMNumber = ordrlist[j].HMaterNumber + "-" + dataDs.Tables[0].Rows[0]["F_bsv_Base1"].ToString() + "-" + date + "-" + RQHNumber + "-"; //sTMNumber = ordrlist[j].HMaterNumber + "-å è£ æ è¯-"+ date + "-ç»ç»ä»£ç -"; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else { sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } } else //éç¨æ¹æ³ { //æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } } else if (HSelectBarCodeType == "åç§æ¡ç ") { if (CampanyName == "äºäº") //ç³»ç»åæ° å®¢æ·å®å¶åå称 { TM = HNumber + ";" + DBUtility.ClsPub.isStrNull(ordrlist[j].HMTONo); } else { TM = HOrgNumber + HNumber; } } else if (HSelectBarCodeType == "æ¹æ¬¡æ¡ç ") { TM = HOrgNumber + HNumber + HBatchNo; }//åæ¥ç¹æ®å¤ç else if (HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { //ç©æç¼ç +åæ®æ¥æï¼YYMMDDï¼+æµæ°´4ä½ sTMNumber = HMaterNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 4; } else if (HSelectBarCodeType == "仪å¨æåæ¡ç è§å") //å¦å¤å¤çäº { //ç©æç¼ç +åºåå·+ç产æ¥æ //sTMNumber = HMaterNumber + sYear + sPeriod + sDay; //Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· // //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); //LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else if (HSelectBarCodeType == "è¯åæåæ¡ç è§å") { //ç©æç¼ç +ç产æ¹å·+æµæ°´å·6ä½- sTMNumber = HMaterNumber + HBatchNo; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 6; } else if (HSelectBarCodeType == "å éæºæ¡ç ") { //å¶é æ¬é¨1ä½ï¼é»è®¤1ï¼+æºå代ç 5ä½ï¼ï¼+å¹´2ä½+æ1ä½ï¼AãBãC代æ¿10æä»½ï¼ //+æ¥2ä½+æ¡ç æ¹æ¬¡ç 2ä½+å缩æºä»£ç 1ä½+00+æµæ°´å·4ä½+æ ¡éªç ï¼é»è®¤0ï¼ sTMNumber = "1" + HModelName + HBarCodeDate + HBarCodeBatchNo + HYasuoji + "00"; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 5; if (sTMNumber.Length != 16) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç é¿åº¦ä¸å¤16ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼å¶é æ¬é¨1ä½:[0] + æºå代ç 5ä½:[" + HModelName + "] + å¹´ææ¥5ä½:[" + HBarCodeDate + "] + æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "]+ å缩æº1ä½:[" + HYasuoji + "]+00 ; "; return objJsonResult; } } else if (HSelectBarCodeType == "å¤éæºæ¡ç ") { //ç©æ代ç 11ä½+å¹´2ä½+æ1ä½ï¼AãBãC代æ¿10æ份ï¼+æ¥2ä½+æ¹æ¬¡2ä½+æµæ°´å·4ä½ //sTMNumber = HMaterNumber.Replace(Convert.ToChar("."),Convert.ToChar("")) + HBarCodeDate + HBarCodeBatchNo; sTMNumber = HMaterNumber.Replace(".", "") + HBarCodeDate + HBarCodeBatchNo; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 5; if (sTMNumber.Length != 18) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç é¿åº¦ä¸å¤18ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼ç©æ代ç 11ä½:[" + HMaterNumber.Replace(".", "") + "]+å¹´ææ¥5ä½:[" + HBarCodeDate + "]+æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "];"; return objJsonResult; } } else if (HSelectBarCodeType == "åæåæ¡ç ") { //ç产订åå·+4ä½æµæ°´å· sTMNumber = HICMOBillNo; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 5; } else if (HSelectBarCodeType == "æçæ¡ç ") { LSHlen = 4; //æµæ°´å·é¿åº¦ //æ¡ç åç¼ = ç©æå ç + å¹´ + æ + æ¥ sTMNumber = HNumber + sYear + sPeriod + sDay; Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "é误çæ¡ç ç±»åï¼ä¸è½çææ¡ç ï¼"; return objJsonResult; } HBQty = HBQty + ClsPub.isInt(ordrlist[j].HBQty); HMinQty = ClsPub.isDoule(ordrlist[j].HMinQty); HSumQty = ClsPub.isDoule(ordrlist[j].HQty); n = 0; for (int i = k; i < HBQty; i++) { if (HSumQty - HMinQty > 0) { WeiShu = ""; HSumQty = HSumQty - HMinQty; } else { if (HSumQty == HMinQty) { WeiShu = ""; } else { WeiShu = "å°¾æ°"; } HMinQty = HSumQty; } // LSH = LSH + 1; LSH2 = LSH.ToString(); while (LSH2.Length < LSHlen) //å¦ææµæ°´å·å°äº6ä½æ°åé¢è¡¥0 { LSH2 = "0" + LSH2; } if (HSelectBarCodeType == "å¯ä¸æ¡ç " || HSelectBarCodeType == "æçæ¡ç ") { //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· TM = sTMNumber + LSH2; } else if (HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || HSelectBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å" || HSelectBarCodeType == "è¯åæåæ¡ç è§å" || HSelectBarCodeType == "åæåæ¡ç " || HSelectBarCodeType == "å¤éæºæ¡ç ") { TM = sTMNumber + LSH2; } else if (HSelectBarCodeType == "å éæºæ¡ç ") { TM = sTMNumber + LSH2 + "0"; } // if (TM.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡å½¢ç ä¸è½ä¸ºç©ºï¼ä¸è½çææ¡ç ï¼"; return objJsonResult; } HBarCodeList barcode = new HBarCodeList(); barcode.HBarCode2 = TM; barcode.HEntryID2 = ClsPub.isStrNull(j + 1); barcode.HMaterID2 = ordrlist[j].HMaterID; barcode.HMaterNumber2 = ordrlist[j].HMaterNumber; barcode.HMaterName2 = ordrlist[j].HMaterName; barcode.HMaterModel2 = ordrlist[j].HMaterModel; barcode.HPinfan2 = ordrlist[j].HPinfan; barcode.HPinfanBarCode2 = ordrlist[j].HPinfanBarCode; barcode.HAuxPropID2 = ordrlist[j].HAuxPropID; barcode.HAuxPropNumber2 = ordrlist[j].HAuxPropNumber; barcode.HAuxPropName2 = ordrlist[j].HAuxPropName; barcode.HUnitID2 = ordrlist[j].HUnitID; barcode.HUnitNumber2 = ordrlist[j].HUnitNumber; barcode.HUnitName2 = ordrlist[j].HUnitName; barcode.HQty2 = ClsPub.isStrNull(HMinQty); barcode.HBatchNo2 = ordrlist[j].HBatchNo; barcode.HSourceInterID2 = ordrlist[j].HMainID; barcode.HSourceEntryID2 = ordrlist[j].HSubID; barcode.HSourceBillNo2 = ordrlist[j].HBillNo; barcode.HSourceBillType2 = ordrlist[j].HBillType; barcode.HPrint = "0"; barcode.HWei = WeiShu; barcode.HBarcodeNo = ClsPub.isStrNull(n + 1); barcode.HBarcodeQtys = ordrlist[j].HBQty; barcode.HSupID2 = ordrlist[j].HSupID; barcode.HSupNumber2 = ordrlist[j].HSupNumber; barcode.HSupName2 = ordrlist[j].HSupName; barcode.HDeptID2 = ordrlist[j].HDeptID; barcode.HDeptNumber2 = ordrlist[j].HDeptNumber; barcode.HDeptName2 = ordrlist[j].HDeptName; barcode.HRemark2 = ordrlist[j].HRemark; barcode.HDate2 = ordrlist[j].HDate; barcode.HShowDate2 = ordrlist[j].HShowDate; barcode.HWhID2 = ordrlist[j].HWhID; barcode.HWhNumber2 = ordrlist[j].HWhNumber; barcode.HWhName2 = ordrlist[j].HWhName; barcode.HSPID2 = ordrlist[j].HSPID; barcode.HSPNumber2 = ordrlist[j].HSPNumber; barcode.HSPName2 = ordrlist[j].HSPName; barcode.HMTONo2 = ordrlist[j].HMTONo; barcode.HCusID2 = ordrlist[j].HCusID; barcode.HCusNumber2 = ordrlist[j].HCusNumber; barcode.HCusName2 = ordrlist[j].HCusName; barcode.HCusType2 = ordrlist[j].HCusType; barcode.HSourceID2 = ordrlist[j].HSourceID; barcode.HSourceNumber2 = ordrlist[j].HSourceNumber; barcode.HSourceName2 = ordrlist[j].HSourceName; barcode.HEndDate2 = ordrlist[j].HEndDate; barcode.HSeOrderBillNo2 = ordrlist[j].HSeOrderBillNo; barcode.HInnerBillNo2 = ordrlist[j].HInnerBillNo; barcode.HMaker2 = ordrlist[j].HMaker; barcode.HGiveAwayFlag2 = ordrlist[j].HGiveAwayFlag; barcode.HCoilNO = ordrlist[j].HCoilNO; barcode.HFurnaceNO = ordrlist[j].HFurnaceNO; barcode.HFactory = ordrlist[j].HFactory; barcode.HAuxQty = ordrlist[j].HAuxQty; barcode.HheatNO = ordrlist[j].HheatNO; ListRows.Add(barcode); k = k + 1; n = n + 1; oCN.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); } } } string HWei = ""; //å°¾æ° string HBarCode = ""; string HBarCodeType = ""; Int64 HMaterID = 0; Int64 HAuxPropID = 0; Int64 HUnitID = 0; double HQty2 = 0; string HBatchNo2 = ""; Int64 HSupID = 0; Int64 HGroupID = 0; int HPrintQty = 0; Int64 HSourceInterID = 0; Int64 HSourceEntryID = 0; string HSourceBillNo = ""; string HSourceBillType = ""; Int64 HBarcodeNo = 0; //æå· Int64 HBarcodeQtys = 0; //æ»ææ° Int64 HDeptID = 0; Int64 HWhID = 0; Int64 HSPID = 0; string HRemark = ""; string HMaterName = ""; string HMaterModel = ""; string HPinfan = ""; string HMTONo = ""; Int64 HCusID = 0; string HCusType = ""; DateTime HEndDate; string HWorkLineName = ""; string HSeOrderBillNo = ""; string HInnerBillNo = ""; bool HGiveAwayFlag = false; Int64 HEntryID = 0; string HCoilNO2 = ""; string HFurnaceNO2 = ""; string HFactory2 = ""; decimal HAuxQty2 = 0; string HheatNO2 = ""; DateTime HProduceDate; DateTime HExpiryDate; try { oCN.BeginTran(); for (int i = 0; i < ListRows.Count; i++) { if (ClsPub.isLong(ListRows[i].HMaterID2) != 0) { HWei = ClsPub.isStrNull(ListRows[i].HWei); HBarCode = ClsPub.isStrNull(ListRows[i].HBarCode2); // HBarCodeType = ClsPub.isStrNull(HSelectBarCodeType); if (CampanyName == "åæ¥ç§æ" || CampanyName == "å¤å®çµå¨") { HBarCodeType = "å¯ä¸æ¡ç "; } // HMaterID = ClsPub.isLong(ListRows[i].HMaterID2); HEntryID = ClsPub.isLong(ListRows[i].HEntryID2); HAuxPropID = ClsPub.isLong(ListRows[i].HAuxPropID2); HUnitID = ClsPub.isLong(ListRows[i].HUnitID2); HQty2 = ClsPub.isDoule(ListRows[i].HQty2); HBatchNo2 = ClsPub.isStrNull(ListRows[i].HBatchNo2); HSourceInterID = ClsPub.isLong(ListRows[i].HSourceInterID2); HSourceEntryID = ClsPub.isLong(ListRows[i].HSourceEntryID2); HSourceBillNo = ClsPub.isStrNull(ListRows[i].HSourceBillNo2); HSourceBillType = ClsPub.isStrNull(ListRows[i].HSourceBillType2); HBarcodeQtys = ClsPub.isLong(ListRows[i].HBarcodeQtys); HBarcodeNo = ClsPub.isLong(ListRows[i].HBarcodeNo); HSupID = ClsPub.isLong(ListRows[i].HSupID2); HDeptID = ClsPub.isLong(ListRows[i].HDeptID2); HWhID = ClsPub.isLong(ListRows[i].HWhID2); HSPID = ClsPub.isLong(ListRows[i].HSPID2); HRemark = ClsPub.isStrNull(ListRows[i].HRemark2); HMaterName = ClsPub.isStrNull(ListRows[i].HMaterName2); HMaterModel = ClsPub.isStrNull(ListRows[i].HMaterModel2); HPinfan = ClsPub.isStrNull(ListRows[i].HPinfan2); HMTONo = ClsPub.isStrNull(ListRows[i].HMTONo2); HCusID = ClsPub.isLong(ListRows[i].HCusID2); HCusType = ClsPub.isStrNull(ListRows[i].HCusType2); HEndDate = ClsPub.isDate(ListRows[i].HEndDate2); HWorkLineName = ClsPub.isStrNull(ListRows[i].HSourceName2); HSeOrderBillNo = ClsPub.isStrNull(ListRows[i].HSeOrderBillNo2); HInnerBillNo = ClsPub.isStrNull(ListRows[i].HInnerBillNo2); HGiveAwayFlag = ClsPub.isBool(ListRows[i].HGiveAwayFlag2); HCoilNO2 = ClsPub.isStrNull(ListRows[i].HCoilNO); HFurnaceNO2 = ClsPub.isStrNull(ListRows[i].HFurnaceNO); HFactory2 = ClsPub.isStrNull(ListRows[i].HFactory); HAuxQty2 = ClsPub.isLong(ListRows[i].HAuxQty); HheatNO2 = ClsPub.isStrNull(ListRows[i].HheatNO); HProduceDate = ClsPub.isDate(ListRows[i].HProduceDate); HExpiryDate = ClsPub.isDate(ListRows[i].HExpiryDate); oCN.RunProc("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 " + ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + ",HGiveAwayFlag " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" + ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString() + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'" + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + "" + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'" + ")"); //HNumber = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterID2Col].Value); //if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") //{ // if (CampanyName == "åå") //ç³»ç»åæ° å®¢æ·å®å¶åå称 // { // //æ¡ç åç¼ = ç©æ代ç + å¹´ + æ + æ¥ // sTMNumber = HNumber + sYear + sPeriod + sDay; // } // else if (CampanyName == "é£é¾") // { // string HWorksNumber = ""; // HWorksNumber = cmbHWorksNumber.Text; // if (HWorksNumber == "") // { // MessageBox.Show("å·¥å代ç ä¸è½ä¸ºç©ºï¼"); // return; // } // //æ¡ç åç¼ = å·¥å代ç + ç©æå ç + æ¥æ // sTMNumber = HWorksNumber + HNumber + sYear + sPeriod + sDay; // } // else //éç¨æ¹æ³ // { // //æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ // sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay; // } //} //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); } } //å¢å æ¡ç è¶ è¿æªçæåè½æ§å¶ // //æ¡ç çææ¶åæ¥çææ¡ç åºå ¥åºè®°å½ if (HSourceBillTypeName.Trim() == "çäº§å ¥åºå" || HSourceBillTypeName.Trim() == "éè´å ¥åºå" || HSourceBillTypeName.Trim() == "éå®éè´§å" || HSourceBillTypeName.Trim() == "ç产éæå") { if (!oWebs.set_BarCodeAutoWMS(HInterID, HSourceBillType, HOrgID, ref DBUtility.ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; objJsonResult.list = null; return objJsonResult; } } oCN.Commit(); List<Object> listobj = ListRows.ConvertAll(s => (object)s);//Listå®ä½ç±»è½¬æ¢ä¸ºobject //è·åçæçæ¡ç ä¿¡æ¯ string sql = string.Format(@"select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " order by HItemID"); ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_IF_ICMOBillList_Table"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è·åèµæºç»å®æ°æ®æåï¼"; objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //åºååDataSetä¸çæ¶é´æ ¼å¼ï¼ç¶ååååºåååæ¥ objJsonResult.list = listobj; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没æè¿åä»»ä½ç»æ,æ¡ç ä¸åå¨ï¼"; objJsonResult.data = null; objJsonResult.list = listobj; return objJsonResult; } } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç çæ失败ï¼" + e.Message; return objJsonResult; } } #endregion #region[æ¡ç æå°æ´æ°æå°æ¬¡æ°] /// <summary> /// æ´æ°æå°æ¬¡æ° /// </summary> /// <param name="msg"></param> /// <param name="msg2"></param> /// <returns></returns> [Route("Sc_BarCode/UpdateBarcodePrintQty")] [HttpPost] public object UpdateBarcodePrintQty(string msg) { try { oCN.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HitemID in("+msg+")", ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æ´æ°æå°æ¬¡æ°æå"; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æå°å¤±è´¥!æå°ç»æ ï¼" + e.ToString(); return objJsonResult; } } #endregion #endregion } }
