| | |
| | | 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 外购退料 外购入库(红字) * |
| | | |
| | |
| | | |
| | | //生成 委外出库 |
| | | 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) |
| | |
| | | } |
| | | #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 |
| | | } |
| | | } |