| | |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Web; |
| | | using Kingdee.BOS.WebApi.Client; |
| | | //using Kingdee.BOS.WebApi.Client; |
| | | |
| | | |
| | | namespace WebAPI |
| | |
| | | //return dal.GetList(sWhere); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region 一键扫码 入库模块 |
| | | |
| | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region 外购退料 外购入库(红字) * |
| | | |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveProductInBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | //判断是否反写成功 |
| | | if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; |
| | | return true; |
| | | } |
| | | ////判断是否反写成功 |
| | | //if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) |
| | | //{ |
| | | // sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | // return true; |
| | | //} |
| | | //else |
| | | //{ |
| | | // sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; |
| | | // return true; |
| | | //} |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | |
| | | |
| | | //生成 委外出库 |
| | | 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) |
| | | { |
| | | var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", |
| | | new object[] { "SUB_PickMtrl", sJson }); |
| | | //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) |
| | | //{ |
| | | // var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", |
| | | // new object[] { "SUB_PickMtrl", sJson }); |
| | | |
| | | if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数 自动审核 |
| | | { |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "SUB_PickMtrl", sJson2 }); |
| | | // if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数 自动审核 |
| | | // { |
| | | // 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 }); |
| | | // string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | // var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | // new object[] { "SUB_PickMtrl", sJson3 }); |
| | | |
| | | HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); |
| | | } |
| | | else |
| | | { |
| | | HReturn = result.ToString(); |
| | | } |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | sErrMsg = "生成委外出库单失败!" + HReturn + sJson; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | oCn.Commit(); |
| | | // HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); |
| | | // } |
| | | // else |
| | | // { |
| | | // HReturn = result.ToString(); |
| | | // } |
| | | // if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | // { |
| | | // sErrMsg = "生成委外出库单失败!" + HReturn + sJson; |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | // } |
| | | // else |
| | | // { |
| | | // oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "生成委外出库单失败!登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | //} |
| | | //} |
| | | //else |
| | | //{ |
| | | // sErrMsg = "生成委外出库单失败!登录失败!"; |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | |
| | | //生成 其他入库单 1个物料1单 |
| | | 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) |
| | | { |
| | | var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", |
| | | new object[] { "STK_MISCELLANEOUS", sJson }); |
| | | //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) |
| | | //{ |
| | | // var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", |
| | | // new object[] { "STK_MISCELLANEOUS", sJson }); |
| | | |
| | | if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数 自动审核 |
| | | { |
| | | string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | new object[] { "STK_MISCELLANEOUS", sJson2 }); |
| | | // if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数 自动审核 |
| | | // { |
| | | // string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | // var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", |
| | | // new object[] { "STK_MISCELLANEOUS", sJson2 }); |
| | | |
| | | string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | new object[] { "STK_MISCELLANEOUS", sJson3 }); |
| | | // string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; |
| | | // var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", |
| | | // new object[] { "STK_MISCELLANEOUS", sJson3 }); |
| | | |
| | | HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); |
| | | } |
| | | else |
| | | { |
| | | HReturn = result.ToString(); |
| | | } |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | sErrMsg = "其他入库单失败!" + HReturn + sJson; |
| | | oCn.RollBack(); |
| | | // HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); |
| | | // } |
| | | // else |
| | | // { |
| | | // HReturn = result.ToString(); |
| | | // } |
| | | // if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | // { |
| | | // sErrMsg = "其他入库单失败!" + HReturn + sJson; |
| | | // oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "其他入库单失败!登录失败!"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | //} |
| | | //else |
| | | //{ |
| | | // oCn.Commit(); |
| | | // return true; |
| | | //} |
| | | //} |
| | | //else |
| | | //{ |
| | | // sErrMsg = "其他入库单失败!登录失败!"; |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | } |
| | | } |
| | | catch (Exception e) |
| | |
| | | |
| | | |
| | | //生成其他出库单 |
| | | public bool set_SaveOtherOutBill_New(Model.ClsKf_OtherOutBillMain oMain, string sHSourceType, ref string sErrMsg) |
| | | public bool set_SaveOtherOutBill_New(WebAPI.WebS.ClsKf_OtherOutBillMain oMain, string sHSourceType, WebS.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | //获取系统参数 |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | if (oSystemParameter.ShowBill(ref sErrMsg) == false) |
| | | { |
| | | sErrMsg = "获取系统参数失败! " + sErrMsg; |
| | | return false; |
| | | } |
| | | // |
| | | if (oSystemParameter.omodel.Kf_OtherOutBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE |
| | | { |
| | | if (SaveOtherOutBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) |
| | | { |
| | | //"保存成功!"; |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | //"保存失败!"; |
| | | sErrMsg = sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | if (oSystemParameter.omodel.Kf_OtherOutBill_ERPMode.ToUpper() == "CLOUD") //判断同步模式是金蝶CLOUD |
| | | { |
| | | //上传前必填项判断 |
| | | //if (oMain.HDeptID == 0) |
| | | //{ |
| | | // sErrMsg = "部门没有选择!"; |
| | | // return false; |
| | | //} |
| | | ////同步生成CLOUD单据 |
| | | //if (set_SaveOtherOutBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) |
| | | //{ |
| | | // //"保存成功!"; |
| | | // return true; |
| | | //} |
| | | //else |
| | | //{ |
| | | //"保存失败!"; |
| | | return false; |
| | | //} |
| | | } |
| | | |
| | | sErrMsg = "保存其他出库单失败!" + sErrMsg; |
| | | return false; |
| | | } |
| | | WebS.WebService1 oWebs = new WebS.WebService1();//set_SaveOtherInBill_CLD_New |
| | | if (oWebs.set_SaveOtherOutBill_CLD_New(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "单据号:" + oMain.HBillNo + ", 单据ID:" + oMain.HInterID + ";" + sErrMsg; |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region [获取打印模板] |
| | | /// <summary> |
| | | /// 打印模板列表 |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <param name="sErr"></param> |
| | | /// <returns></returns> |
| | | public DataSet GetOpenTmpList(string sWhere, ref string sErr) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds = new DataSet(); |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_OpenTmpList " + sWhere, "h_v_IF_OpenTmpList"); |
| | | return ds; |
| | | } |
| | | #endregion |
| | | } |
| | | } |