| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MoveStockBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MoveStockBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveMoveStockBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MoveStockBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MoveStockBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核直接调拨单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | [WebMethod] |
| | | private bool set_SaveMoveStockBill_CLD_BillCheck_Verify(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MoveStockBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_MoveStockBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_MoveStockBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_MoveStockBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "STK_TransferDirect", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "STK_TransferDirect", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核直接调拨单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核直接调拨单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核直接调拨单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核直接调拨单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核直接调拨单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_SellOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_SellOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | if (set_SaveSellOutBill_CLD_BillCheck_Verify(oMain, ref sErrMsg) == true) |
| | | if (set_SaveSellOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_SellOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_SellOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | } |
| | | |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveSellOutBill_CLD_BillCheck_Verify(Model.ClsKf_SellOutBillMain oMain, ref string sErrMsg) |
| | | private bool set_SaveSellOutBill_CLD_BillCheck_Verify(Model.ClsKf_SellOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_SellOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "'", "h_p_WMS_BeforeUpload_SellOutBillCheck_Verify"); |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_SellOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_SellOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_SellOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "'"); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_SellOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MateOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MateOutBillCheck_SourceBarCodeCtl == "Y" |
| | | ) |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveMateOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MateOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MateOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核生产领料单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveMateOutBill_CLD_BillCheck_Verify(Model.ClsKf_MateOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MateOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_MateOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_MateOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_MateOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "PRD_PickMtrl", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "PRD_PickMtrl", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核生产领料单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("核对校验审核生产领料单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产领料单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("核对校验审核生产领料单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产领料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveMateReplenishOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveMateReplenishOutBill_CLD_BillCheck_Verify(Model.ClsKf_MateReplenishOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MateReplenishOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_MateReplenishOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_MateReplenishOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_MateReplenishOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "PRD_FeedMtrl", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "PRD_FeedMtrl", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核生产补料单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核生产补料单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产补料单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核生产补料单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产补料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核生产补料单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //WMS 原单据非扫码生成 只生成WMS单据 |
| | | private bool set_SaveMateReplenishOutBill_WMS_BillCheck(Model.ClsKf_MateReplenishOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveEntrustReplenishOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外补料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveEntrustReplenishOutBill_CLD_BillCheck_Verify(Model.ClsKf_EntrustReplenishOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_EntrustReplenishOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_EntrustReplenishOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_EntrustReplenishOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_EntrustReplenishOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "SUB_FEEDMTRL", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "SUB_FEEDMTRL", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核委外补料单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核委外补料单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外补料单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核委外补料单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外补料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核委外补料单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_EntrustOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveEntrustOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_EntrustOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外领料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveEntrustOutBill_CLD_BillCheck_Verify(Model.ClsKf_EntrustOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_EntrustOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_EntrustOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_EntrustOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_EntrustOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "SUB_PickMtrl", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "SUB_PickMtrl", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核委外领料单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核委外领料单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外领料单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核委外领料单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核委外领料单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核委外领料单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_OtherOutBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_OtherOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveOtherOutBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_OtherOutBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_OtherOutBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核其他出库单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | public bool set_SaveOtherOutBill_CLD_BillCheck_Verify(Model.ClsKf_OtherOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_OtherOutBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_OtherOutBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_OtherOutBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_OtherOutBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "STK_MisDelivery", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "STK_MisDelivery", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核其他出库单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核其他出库单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核其他出库单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核其他出库单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核其他出库单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_POStockInBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_POStockInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SavePOStockInBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_POStockInBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_POStockInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核采购入库单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SavePOStockInBill_CLD_BillCheck_Verify(Model.ClsKf_POStockInBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_POStockInBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_POStockInBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_POStockInBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_POStockInBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "STK_InStock", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "STK_InStock", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核采购入库单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核采购入库单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核采购入库单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核采购入库单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核采购入库单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_ProductInBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_ProductInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | | if (set_SaveProductInBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //上传失败 |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";上传单据失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | //原单据非扫码生成 |
| | | else |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_ProductInBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_ProductInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "校验审核生产入库单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //CLOUD 免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveProductInBill_CLD_BillCheck_Verify(Model.ClsKf_ProductInBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_ProductInBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_ProductInBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_ProductInBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ",单据ID:" + oMain.HInterID + ";" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_ProductInBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; |
| | | return false; |
| | | } |
| | | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | //金蝶云审核单据 |
| | | string HReturn; |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | if (bLogin) |
| | | { |
| | | //提交单据 |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "PRD_INSTOCK", sJson2 }); |
| | | //审核单据 |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "PRD_INSTOCK", sJson3 }); |
| | | |
| | | HReturn = result3.ToString(); |
| | | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | //反序列化json数据 |
| | | var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn); |
| | | //接收金蝶报错信息 |
| | | var strErrorMsg = string.Empty; |
| | | //遍历获取报错信息 |
| | | foreach (var item in retModel.Result.ResponseStatus.Errors) |
| | | { |
| | | strErrorMsg += item.Message + "\r\n"; |
| | | }; |
| | | sErrMsg = "校验审核生产入库单失败!金蝶云提示:" + strErrorMsg; |
| | | LogService.Write("校验审核生产入库单失败!" + HReturn); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产入库单成功!单据号为:" + oMain.HBillNo; |
| | | LogService.Write("校验审核生产入库单成功!单据号为:" + oMain.HBillNo); //写入txt文本 |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "校验审核生产入库单失败!金蝶云登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_OtherInBillCheck_ERPMode.ToUpper() == "CLOUD") |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_OtherInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | if (set_SaveOtherInBill_CLD_BillCheck_Verify(oMain, ref sErrMsg) == true) |
| | | if (set_SaveOtherInBill_CLD_BillCheck_Verify(oMain, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | { |
| | | //上传成功 |
| | | return true; |
| | |
| | | } |
| | | else if (oSystemParameter.omodel.Kf_OtherInBillCheck_ERPMode.ToUpper() == "WMS") //只生成WMS单据 |
| | | { |
| | | //免扫物料条码模式(只扫描源单进行审核,不扫描物料条码) |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_SourceBarCodeCtl == "Y") |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_AutoBarCode == "Y" |
| | | || oSystemParameter.omodel.Kf_OtherInBillCheck_SourceBarCodeCtl == "Y") |
| | | { |
| | | sErrMsg = "暂不支持扫码生成单据的校验功能!"; |
| | | return false; |
| | |
| | | } |
| | | |
| | | //CLOUD 原单据为扫码生成,对原扫描的条码进行核对 |
| | | private bool set_SaveOtherInBill_CLD_BillCheck_Verify(Model.ClsKf_OtherInBillMain oMain, ref string sErrMsg) |
| | | private bool set_SaveOtherInBill_CLD_BillCheck_Verify(Model.ClsKf_OtherInBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | //上传前判断 |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_OtherInBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "'", "h_p_WMS_BeforeUpload_OtherInBillCheck_Verify"); |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_OtherInBillCheck_Verify " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "','" + oSystemParameterMain.Kf_OtherInBillCheck_AutoBarCode + "'", "h_p_WMS_BeforeUpload_OtherInBillCheck_Verify"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "校验上传前判断,发生错误!"; |
| | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //写入条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "'"); |
| | | //写入出入库校验表、条码出入库校验表 |
| | | oCn.RunProc("EXEC h_p_Kf_ICStockBillSub_WMS_Verify_Insert " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + oMain.HBillNo + "','" + oSystemParameterMain.Kf_OtherInBillCheck_AutoBarCode + "'"); |
| | | |
| | | //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | |
| | | sErrMsg = "获取系统参数失败! " + sErrMsg; |
| | | return null; |
| | | } |
| | | string sAutoBarCode = "N"; //免扫物料条码模式('Y'为不扫物料条码) |
| | | string sSourceBarCodeCtl = "N"; //校验-是否进行源单对应条码核对('Y'为核对) |
| | | string sWHSPCtl = "Y"; //校验-是否校对仓库仓位('Y'为校对) |
| | | string sERPMode = "CLOUD"; //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_SourceBarCodeCtl.ToUpper() == "Y") |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_POStockInBillCheck_ERPMode == "WMS") |
| | |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_ProductInBillCheck_ERPMode == "WMS") |
| | | { |
| | |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_SourceBarCodeCtl.ToUpper() == "Y") |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_OtherInBillCheck_ERPMode == "WMS") |
| | |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_MateOutBillCheck_ERPMode == "WMS") |
| | | { |
| | |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_SourceBarCodeCtl.ToUpper() == "Y") |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_SellOutBillCheck_ERPMode == "WMS") |
| | |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_OtherOutBillCheck_ERPMode == "WMS") |
| | | { |
| | |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_SourceBarCodeCtl.ToUpper() == "Y") |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_EntrustOutBillCheck_ERPMode == "WMS") |
| | |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_MateReplenishOutBillCheck_ERPMode == "WMS") |
| | | { |
| | |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_SourceBarCodeCtl.ToUpper() == "Y") |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_EntrustReplenishOutBillCheck_ERPMode == "WMS") |
| | |
| | | { |
| | | sSourceBarCodeCtl = "Y"; |
| | | } |
| | | //免扫物料条码模式('Y'为不扫物料条码) |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_AutoBarCode.ToUpper() == "Y") |
| | | { |
| | | sAutoBarCode = "Y"; |
| | | } |
| | | //WMS系统同步至ERP的类型(WISE、CLOUD、WMS) |
| | | if (oSystemParameter.omodel.Kf_MoveStockBillCheck_ERPMode == "WMS") |
| | | { |
| | |
| | | } |
| | | #endregion |
| | | |
| | | //原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (sSourceBarCodeCtl == "Y") |
| | | //免扫物料条码模式 或 原单据为扫码生成,对原扫描的条码进行核对 |
| | | if (sAutoBarCode == "Y" || sSourceBarCodeCtl == "Y") |
| | | { |
| | | //将单据信息、单据对应条码信息写入条码出入库校验临时表KF_PonderationBillMain_Temp_Verify |
| | | DataSet dsVerify = oCn.RunProcReturn("exec h_p_WMS_AddBillBarCode_BillCheckVerify '" + HBillNo + "','" + HBillType + "','" + HMaker + "'," + HOWNERID.ToString(), "h_p_WMS_AddBillBarCode_BillCheckVerify"); |