| | |
| | | sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); |
| | | } |
| | | |
| | | |
| | | //生成 生产汇报单 |
| | | string HReturn; |
| | | string HReturn2 = ""; |
| | |
| | | //更新关联数量 |
| | | oCn.RunProc("exec h_p_Sc_UpDateRelation_ICMOToICMOReport_Add " + oMain.HInterID.ToString()); |
| | | |
| | | //更新生产状态临时状态表数量 |
| | | oCn.RunProc("exec h_p_Sc_UpDateRelation_ICMOToICMOReport_Qty " + oMain.HMainSourceInterID.ToString() + "," + oMain.HMainSourceEntryID.ToString() + ""); |
| | | |
| | | if (oSystemParameterMain.Sc_ICMOReportBill_AutoCheck == "Y") //系统参数 自动审核 |
| | | { |
| | | //审核单据 |
| | |
| | | //获取CLOUD账号密码 |
| | | string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; |
| | | string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; |
| | | DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); |
| | | DataSet ds11 = get_SaveMESCLOUDUseNamePsd(oMain.HMaker); |
| | | if (ds11 == null || ds11.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | |
| | | ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); |
| | | string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 |
| | | bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); |
| | | string msgReport = dbId + ';' + sCLOUDUseName + ';' + sCLOUDPsd + ';' + 2052; |
| | | if (bLogin) |
| | | { |
| | | var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", |
| | |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "生成生产汇报单失败!登录失败!"; |
| | | sErrMsg = "生成生产汇报单失败!登录失败!"+ msgReport; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | //获取CLOUD账号密码(根据MES登录账号获取) |
| | | [WebMethod] |
| | | public DataSet get_SaveMESCLOUDUseNamePsd(string HMaker) |
| | | { |
| | | try |
| | | { |
| | | DataSet ds; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("exec h_p_LMES_GetCloudUserByBill " + HMaker.ToString(), "h_p_LMES_GetCloudUserByBill"); |
| | | if (ds == null && ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | return null; |
| | | } |
| | | else |
| | | { |
| | | return ds; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | return null; |
| | | } |
| | | } |
| | | |
| | | //单据上传前判断(物料属性判断 丸井) |
| | | [WebMethod] |
| | | public bool CheckAllowBeforeSave(Int64 HInterID, ref string sMsg) |