| | |
| | | } |
| | | else |
| | | { |
| | | list.Add(""); |
| | | list.Add(CampanyName); |
| | | } |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | list.Add("å¯ä¸æ¡ç "); |
| | | list.Add("åç§æ¡ç "); |
| | | list.Add("æ¹æ¬¡æ¡ç "); |
| | | //list.Add("æçæ¡ç "); |
| | | list.Add("æçæ¡ç "); |
| | | } |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | [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 |
| | | { |
| | |
| | | break; |
| | | case "æ¶æéç¥å": |
| | | tabname = "h_v_IF_POInStockBillList_Source"; |
| | | 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)"); |
| | | 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"; |
| | |
| | | |
| | | 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(); |
| | |
| | | |
| | | if(HSourceBillType == "æ¶æéç¥å") |
| | | { |
| | | ordrlist.HFurnaceNO = dt.Rows[i]["çå·"].ToString(); |
| | | ordrlist.HCoilNO = dt.Rows[i]["é¢å·æå
å·"].ToString(); |
| | | ordrlist.HheatNO = dt.Rows[i]["çå¤ç"].ToString(); |
| | | 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 == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") |
| | |
| | | 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); |
| | |
| | | //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 //éç¨æ¹æ³ |
| | | { |
| | | //æ¡ç åç¼ = ç»ç»ä»£ç + ç©æä»£ç + å¹´ + æ + æ¥ |
| | |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSHlen = 5; |
| | | } |
| | | //else if (cmbHBarCodeType.Text == "æçæ¡ç ") |
| | | //{ |
| | | // TM = HOrgNumber + HNumber + LSH2; |
| | | //} |
| | | 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"; |
| | |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | if (HSelectBarCodeType == "å¯ä¸æ¡ç ") |
| | | if (HSelectBarCodeType == "å¯ä¸æ¡ç " || HSelectBarCodeType == "æçæ¡ç ") |
| | | { |
| | | //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· |
| | | TM = sTMNumber + LSH2; |