| | |
| | | { |
| | | //sCloudModeï¼ç³»ç»åæ° æ¯å¦ä¸ºç§æäºæ¨¡å¼(N为å
¬æäºæ¨¡å¼ï¼Yä¸ºç§æäºæ¨¡å¼)ï¼ |
| | | //sERPModeï¼ç³»ç»åæ° åºåæ§å¶-WMSåºåæ§å¶ERPæ¨¡å¼ (WISEãCLOUDãMES)ï¼ |
| | | //sHTypeï¼å¼ 1 对åºç¼åå表å é¤ï¼å¼ 2 对åºå·²ä¸ä¼ æ¤éï¼ |
| | | //sHTypeï¼å¼ 1 对åºç¼åå表å é¤ï¼å¼ 2 对åºå·²ä¸ä¼ æ¤éï¼å¼ 3 å¯¹åºæ ¡éªæ¨¡åå·²ä¸ä¼ æ¤éï¼ |
| | | |
| | | //å
¬æäºæ¨¡å¼ |
| | | if (sCloudMode == "N") |
| | |
| | | var sJson = new |
| | | { |
| | | FormId = sFormId, |
| | | FieldKeys = "FBillNo", |
| | | FieldKeys = "FBillNo,FAPPROVERID", |
| | | FilterString = $@"FBillNo='{HBillNo}'", |
| | | OrderString = "", |
| | | TopRowCount = 0, |
| | |
| | | } |
| | | } |
| | | //sHType = 2对åºå·²ä¸ä¼ æ¤é |
| | | else |
| | | else if(sHType == 2) |
| | | { |
| | | //夿è¿åçæ°ç»æ°æ®ä¸æ¯å¦åå¨"false"ï¼åå¨ä»£è¡¨éå
¥çä¸å¡å¯¹è±¡è¡¨åId䏿£ç¡® |
| | | if (_saveObj[0][0].ToString().Contains("false") == true) |
| | |
| | | return false; |
| | | } |
| | | } |
| | | //sHType = 3å¯¹åºæ ¡éªæ¨¡åå·²ä¸ä¼ æ¤é |
| | | else if (sHType == 3) |
| | | { |
| | | //夿è¿åçæ°ç»æ°æ®ä¸æ¯å¦åå¨"false"ï¼åå¨ä»£è¡¨éå
¥çä¸å¡å¯¹è±¡è¡¨åId䏿£ç¡® |
| | | if (_saveObj[0][0].ToString().Contains("false") == true) |
| | | { |
| | | sErrMsg = "æ¤æ¨¡åæä¸æ¯ææ¤éåè½ï¼"; |
| | | return false; |
| | | } |
| | | else if (_saveObj[0][1].ToString() != "0") |
| | | { |
| | | sErrMsg = "æ ¡éªæ¤éåæ®å¤±è´¥ï¼åæ®å·ï¼" + HBillNo + "ï¼éè¶äºéå·²å®¡æ ¸ï¼ä¸å
许æ¤éï¼"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "sHTypeå¼éå
¥é误ï¼"; |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | //ç§æäºæ¨¡å¼ |
| | | else |
| | | { |
| | | //sHType = 3 æ«ç æ ¡éªæ¨¡å |
| | | if (sHType == 3) |
| | | { |
| | | ds = oCn.RunProcReturn("exec h_p_WMS_BillQuery_BillCheck " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + sERPMode + "'", "h_p_WMS_BillQuery_BillCheck"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "åæ®æ¥è¯¢åçé误ï¼"; |
| | | return false; |
| | | } |
| | | else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1) |
| | | { |
| | | sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | //sHType = 1 æ sHType = 2 æ«ç æ°å¢æ¨¡å |
| | | else |
| | | { |
| | | ds = oCn.RunProcReturn("exec h_p_WMS_BillQuery " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + sERPMode + "'," + sHType.ToString(), "h_p_WMS_BillQuery"); |
| | |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | #endregion |
| | | |
| | | //æ¤éå夿éè¶äºä¸åæ®æ¯å¦åå¨ |
| | | if (!GetBillQuery_WMS(HInterID, HBillNo, HBillType, HMaker, oSystemParameter.omodel.WMS_CloudMode, sERPMode, 3, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |