| | |
| | | using DBUtility; |
| | | using DAL; |
| | | using DBUtility; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Converters; |
| | | using Newtonsoft.Json.Linq; |
| | |
| | | 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 top " + pageSize + " * 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; |
| | |
| | | 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"; |
| | | ds.Tables[0].Columns["hmainid"].ColumnName = "HMainID"; |
| | | ds.Tables[0].Columns["hsubid"].ColumnName = "HSubID"; |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | |
| | |
| | | //åå
¥ä¿¡æ¯ |
| | | 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": //å
¶ä»å
¥åºå |
| | |
| | | case "1207": //ç´æ¥è°æ¨å |
| | | break; |
| | | case "1239": //éè´éæå |
| | | break; |
| | | case "1244": //ç产éæå |
| | | break; |
| | | case "1255": //ç»è£
æå¸å |
| | | break; |
| | |
| | | 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 [åæ¥èµæ] |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string HOrgType = sArray[1].ToString(); |
| | | string HSourceBillType = sArray[2].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(); |
| | |
| | | else |
| | | { |
| | | //çææ¡ç |
| | | SaveBarCode(msg2, HSelectBarCodeType, CampanyName); |
| | | SaveBarCode(msg2, HSelectBarCodeType, CampanyName, HSourceBillTypeName); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | #endregion |
| | | |
| | | #region[æ¡ç çææ¹æ³] |
| | | private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName) |
| | | private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName,string HSourceBillTypeName) |
| | | { |
| | | int LSHlen = 6; //æµæ°´å·é¿åº¦ |
| | | int SumLen = 10; //æ»é¿åº¦ |
| | |
| | | //å¢å æ¡ç è¶
è¿æªçæåè½æ§å¶ |
| | | |
| | | // |
| | | |
| | | |
| | | //æ¡ç çææ¶åæ¥çææ¡ç åºå
¥åºè®°å½ |
| | | 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 |
| | | //è·åçæçæ¡ç ä¿¡æ¯ |