| | |
| | | entryid_PGD = arr[1]; |
| | | } |
| | | |
| | | |
| | | //æªåæ¡ç ç±»å åä¸ä½ |
| | | string BillNoType = BillNo_PGD.Substring(0, Math.Min(3, BillNo_PGD.Length)); |
| | | //æªåæ¡ç ç±»å2 ååä½ |
| | | string BillNoType2 = BillNo_PGD.Substring(0, Math.Min(4, BillNo_PGD.Length)); |
| | | |
| | | //æªåå
ç |
| | | string BillNo = BillNo_PGD.Substring(3, Math.Min(BillNo_PGD.Length - 3, BillNo_PGD.Length)); |
| | | |
| | | string sErr = ""; |
| | | |
| | | switch (BillNoType2) |
| | | { |
| | | case "GXLX"://æµè½¬å¡ |
| | | string sErr = ""; |
| | | |
| | | string sql = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "ä¹ä¸") |
| | |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where åæ®å·= '" + BillNo_PGD + "'", "h_v_Sc_ProcessExchangeBillList"); |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) |
| | | { |
| | | case "å·¥åº": |
| | | sql = "exec h_p_QC_ProcessCheck_GetProcessExchangeBillList " + "'å·¥åº','" + BillNo_PGD + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetProcessExchangeBillList"); |
| | | break; |
| | | case "ç©æ": |
| | | sql = "exec h_p_QC_ProcessCheck_GetProcessExchangeBillList " + "'ç©æ','" + BillNo_PGD + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetProcessExchangeBillList"); |
| | | break; |
| | | case "å·¥èºè·¯çº¿": |
| | | sql = "exec h_p_QC_ProcessCheck_GetProcessExchangeBillList " + "'å·¥èºè·¯çº¿','" + BillNo_PGD + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetProcessExchangeBillList"); |
| | | break; |
| | | } |
| | | |
| | | } |
| | | } |
| | | } |
| | | break; |
| | | case "GXCZ": |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillMain where HBillNo = '" + HBarCode + "'", "Sc_StationOutBillMain"); |
| | | Int64 HStationOutInterID = 0; |
| | | |
| | | if (ds != null || ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | HStationOutInterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]); |
| | | } |
| | | |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) |
| | | { |
| | | case "å·¥åº": |
| | | sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'å·¥åº','" + HStationOutInterID + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetStationOutBillList"); |
| | | break; |
| | | case "ç©æ": |
| | | sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'ç©æ','" + HStationOutInterID + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetStationOutBillList"); |
| | | break; |
| | | case "å·¥èºè·¯çº¿": |
| | | sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'å·¥èºè·¯çº¿','" + HStationOutInterID + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetStationOutBillList"); |
| | | break; |
| | | } |
| | | |
| | | } |
| | | break; |
| | | case "MO00": |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) |
| | | { |
| | | case "å·¥åº": |
| | | sql = "exec h_p_QC_ProcessCheck_GetICMOList " + "'å·¥åº','" + HBarCode + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetICMOList"); |
| | | break; |
| | | case "ç©æ": |
| | | sql = "exec h_p_QC_ProcessCheck_GetICMOList " + "'ç©æ','" + HBarCode + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetICMOList"); |
| | | break; |
| | | case "å·¥èºè·¯çº¿": |
| | | sql = "exec h_p_QC_ProcessCheck_GetICMOList " + "'å·¥èºè·¯çº¿','" + HBarCode + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetICMOList"); |
| | | break; |
| | | } |
| | | |
| | | } |
| | | break; |
| | | default: |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡ç é误!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "ä¹ä¸") |
| | | { //ç³»ç»åæ°æ¯å¦ä¸ºåªæ¾ç¤ºå½åç»å½ç¨æ·å
³èçå·¥åºä¿¡æ¯,N为å¦ï¼Yä¸ºæ¯ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡ç é误!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | break; |
| | | } |
| | | } |
| | | |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | |
| | | switch (BillNoType) |
| | | //å¾å°ä¿¡æ¯ |
| | | { |
| | | case "HCX"://çäº§èµæºç |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList where æ¡ç ç¼å· = '" + BillNo + "'", "h_v_Gy_SourceList"); |
| | | break; |
| | | } |
| | | |
| | | if (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 = ""; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |