派生自 MES-WEB-API
WebAPI/WebServer.cs
@@ -5,7 +5,7 @@ using System.Data; using System.Linq; using System.Web; using Kingdee.BOS.WebApi.Client; //using Kingdee.BOS.WebApi.Client; namespace WebAPI @@ -53,6 +53,8 @@ //DAL.ClsIF_Department_View dal = new DAL.ClsIF_Department_View(); //return dal.GetList(sWhere); } /// <summary> /// 获取物料列表 @@ -123,10 +125,11 @@ } #endregion #region 一键扫码 入库模块 //一键扫码模式，根据条码前缀走 不同方法（仓库、仓位、部门）（源单、物料条码） 入库模块 public Model.ClsKf_ICStockBill_WMS get_CheckTypeByBarCode(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, string HMaker, Int64 HWhID, Int64 HSPID, Double HQty, bool HRedBlueFlag, bool SourceFlag, string HSourceBillNo, string HSourceBillType, Int64 HOWNERID, ref string sErrMsg) public Model.ClsKf_ICStockBill_WMS get_CheckTypeByBarCode(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, string HMaker, Int64 HWhID, Int64 HSPID, Double HQty, bool HRedBlueFlag, bool SourceFlag, string HSourceBillNo, string HSourceBillType, Int64 HOWNERID,Int64 HOrgID, ref string sErrMsg) { BLL.ClsKF_PonderationBillMain_Temp bll = new ClsKF_PonderationBillMain_Temp(); return bll.get_CheckTypeByBarCode(sBarCode, HBillID, HBillType, HBillNo, HMaker, HWhID, HSPID, HQty, HRedBlueFlag, SourceFlag, HSourceBillNo, HSourceBillType, HOWNERID, ref DBUtility.ClsPub.sExeReturnInfo); @@ -1121,6 +1124,7 @@ #endregion #region 外购退料 外购入库（红字） * public bool set_SavePOStockInBackBill_New(WebAPI.WebS.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg) @@ -1128,7 +1132,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SavePOStockInBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -1618,7 +1622,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveEntrustInBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -1856,7 +1860,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveProductInBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -1990,6 +1994,11 @@ public DataSet GetKf_ProductInBillList(string sWhere) { DAL.Cls_S_IF_ProductInBill_Lite dal = new DAL.Cls_S_IF_ProductInBill_Lite(); return dal.DisSourceBillList(sWhere); } public DataSet GetKf_MoveStockRequestBillList(string sWhere) { DAL.Cls_S_IF_MoveStockRequestBill_Lite dal = new DAL.Cls_S_IF_MoveStockRequestBill_Lite(); return dal.DisSourceBillList(sWhere); } #endregion @@ -2306,7 +2315,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMateOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -2863,7 +2872,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveSellOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -3832,6 +3841,28 @@ } } //根据托条码 获取条码档案列表唯一码信息 public DataSet GetBarCode(string HBarCode) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); // try { DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo); //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetHBW(long HBadType) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); @@ -3878,7 +3909,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMoveStockBill(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -3989,6 +4020,44 @@ //sErrMsg = "保存调拨单失败！" + sErrMsg; //return false; } //public bool set_SaveMoveStockBill_PD(WebAPI.WebS.ClsKf_MoveStockBillMain oMain, string sHSourceType, ref string sErrMsg) //{ // WebS.WebService1 oWebs = new WebS.WebService1(); // if (oWebs.set_SaveMoveStockBill_PD(oMain, sHSourceType, ref sErrMsg)) // { // sErrMsg = "保存成功！" + oMain.HBillNo; // return true; // } // else // { // sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg; // return false; // } //} public bool set_MoveStockStepOutBill(WebAPI.WebS.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, ref string sErrMsg) { WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMoveStockStepOutBill_New(oMain, sHSourceType, ref sErrMsg)) { //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else { sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg; return false; } } //删除记录 public bool set_DelPonderationBillMain_Temp_InterIDAndSource(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg) { @@ -4022,6 +4091,68 @@ return false; } } //删除单据临时表信息 public bool DeleteBill_AN(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg) { //DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); //if (dal.DeleteByInterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType)) //{ // sErrMsg = "删除成功！"; // return true; //} //else //{ // sErrMsg = "删除失败！"; // return false; //} WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref DBUtility.ClsPub.sErrInfo)) { sErrMsg = "删除成功！"; return true; } else { sErrMsg = "删除失败！"; return false; } //if (WebSoBar == null) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = DBUtility.ClsPub.sErrInfo; // objJsonResult.data = null; // return objJsonResult; //} //else //{ // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = DBUtility.ClsPub.sErrInfo; // objJsonResult.data = WebSoBar; // return objJsonResult; //} } //删除单据临时表信息 public bool DeleteBill(Int64 sHInterID, string HBillNo, string HBillType, string HBarCode, ref string sErrMsg) { DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); if (dal.DeleteBill(sHInterID, HBillNo, HBillType, HBarCode)) { sErrMsg = "删除成功！"; return true; } else { sErrMsg = "删除失败！"; return false; } } //public Model.ClsGy_BarCodeBill_WMS_Model_View get_InfoByBarCode_Source(string sBarCode, Int64 sInterID, ref bool sBool, ref string sErrMsg) //{ // SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -4054,7 +4185,7 @@ // return null; // } //} #endregion #region 外购入库 @@ -4261,6 +4392,19 @@ //return dal.GetInfoByID_View(HInterID, sBillType, sWhere); } public bool Get_CheckQtyByBarCode(string sBarcode, long HWHID, long HSPID, long HAuxPropID, string sBatchNo, string HMTONo, double sQty, ref double sRelQty) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); if (dal.CheckQtyByBarCode(sBarcode, HWHID, HSPID, HAuxPropID, sBatchNo, HMTONo, sQty, ref sRelQty)) { return true; } else { return false; } } public DataSet GetSPInfoByIDandHWHIDandOrg(long sItemID, long sHWHID, long HUSEORGID, ref string sErrMsg) { BLL.ClsIF_StockPlace_View bll = new BLL.ClsIF_StockPlace_View(); @@ -4408,11 +4552,20 @@ //返回缓存列表信息 同步资料 public DataSet GetKf_PonderationBillMain_TempList_New(string sHBillType, string sHMaker, Int64 sHOWNERID) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); return dal.GetKf_PonderationBillMain_TempList_New(sHBillType, sHMaker, sHOWNERID); } //返回缓存列表信息 同步资料 public DataSet GetKf_PonderationBillMain_TempList(string sHBillType, string sWhere) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); return dal.GetKf_PonderationBillMain_TempList(sHBillType, sWhere); } @@ -4469,12 +4622,12 @@ //判断是否反写成功 if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else { sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; //sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; return true; } } @@ -4484,6 +4637,60 @@ return false; } } public bool set_SaveICMOReportBill_Json(WebAPI.WebS.ClsSc_ICMOReportBillMain oMain, string sHSourceType, ref string sErrMsg) { //BLL.ClsKf_POStockInBill bll = new BLL.ClsKf_POStockInBill(); //return bll.set_SavePOStockInBill_New(oMain, sHSourceType, ref DBUtility.ClsPub.sExeReturnInfo); WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveICMOReportBill_New(oMain, sHSourceType, ref sErrMsg)) { //判断是否反写成功 //if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) //{ sErrMsg = "保存成功！" + oMain.HBillNo; return true; //} //else //{ // sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; // return true; //} } else { sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg; return false; } } //public bool set_SavePOInStockBill_NEW_Json(WebAPI.WebS.ClsCg_POInStockBillMain oMain, ref string sErrMsg) //{ // //BLL.ClsKf_POStockInBill bll = new BLL.ClsKf_POStockInBill(); // //return bll.set_SavePOStockInBill_New(oMain, sHSourceType, ref DBUtility.ClsPub.sExeReturnInfo); // WebS.WebService1 oWebs = new WebS.WebService1(); // if (oWebs.set_SavePOInStockBill_Json(oMain, ref sErrMsg)) // { // //判断是否反写成功 // //if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) // //{ // sErrMsg = "保存成功！" + oMain.HBillNo; // return true; // //} // //else // //{ // // sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; // // return true; // //} // } // else // { // sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg; // return false; // } //} /// <summary> /// 生成外购入库单K3 @@ -4645,7 +4852,19 @@ //DAL.Cls_S_IF_ICMOBill_Lite dal = new DAL.Cls_S_IF_ICMOBill_Lite(); //return dal.DisSourceBillList(sWhere); } /// <summary> /// 返回生产汇报单列表 源单 /// </summary> /// <param name="sWhere">过滤条件</param> /// <returns></returns> public DataSet GetSc_ICMOReportBillList(string sWhere) { WebS.WebService1 oWebs = new WebS.WebService1(); BLL.ClsKf_ProductInBill bll = new BLL.ClsKf_ProductInBill(); return oWebs.GetSc_ICMOReportBillList (sWhere); //DAL.Cls_S_IF_ICMOBill_Lite dal = new DAL.Cls_S_IF_ICMOBill_Lite(); //return dal.DisSourceBillList(sWhere); } /// <summary> /// 生成产品入库单K3 @@ -4827,17 +5046,19 @@ 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 { @@ -4917,7 +5138,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMateOutBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -5379,12 +5600,12 @@ //判断是否反写成功 if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else { sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; //sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！"; return true; } } @@ -5649,7 +5870,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveEntrustOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -6092,48 +6313,48 @@ //生成 委外出库 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) @@ -6175,7 +6396,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveEntrustOutBill_New(oMain, sHSourceType, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; //sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else @@ -6966,60 +7187,312 @@ } //生成其他入库单 public bool set_SaveOtherInBill_New(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, 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_OtherInBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE { if (SaveOtherInBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) { //"保存成功！"; sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else { //"保存失败！"; sErrMsg = sErrMsg; return false; } } if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "CLOUD") //判断同步模式是金蝶CLOUD { ////上传前必填项判断 //if (oMain.HDeptID == 0) //{ // sErrMsg = "部门没有选择！"; // return false; //} ////同步生成CLOUD单据 //if (set_SaveOtherInBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) //{ // //"保存成功！"; // return true; //} //else //{ // //"保存失败！"; return false; //} } //生成其他入库单 //public bool set_SaveOtherInBill_New(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, 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_OtherInBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE // { // if (SaveOtherInBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) // { // //"保存成功！"; // sErrMsg = "保存成功！" + oMain.HBillNo; // return true; // } // else // { // //"保存失败！"; // sErrMsg = sErrMsg; // return false; // } // } // if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "CLOUD") //判断同步模式是金蝶CLOUD // { // ////上传前必填项判断 // //if (oMain.HDeptID == 0) // //{ // // sErrMsg = "部门没有选择！"; // // return false; // //} // //同步生成CLOUD单据 // //if (SaveOtherInBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) // //{ // // //"保存成功！"; // // return true; // //} // //else // //{ // // //"保存失败！"; // // return false; // //} // } sErrMsg = "保存其他入库单失败！" + sErrMsg; return false; } // sErrMsg = "保存其他入库单失败！" + sErrMsg; // return false; //} public bool set_SaveOtherInBill_New(WebAPI.WebS.ClsKf_OtherInBillMain oMain, string sHSourceType, WebS.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) { WebS.WebService1 oWebs = new WebS.WebService1();//set_SaveOtherInBill_CLD_New if (oWebs.set_SaveOtherInBill_CLD_New(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg)) { sErrMsg = "保存成功！" + oMain.HBillNo; return true; } else { sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg; return false; } } ///生成其他入库单 public bool set_SaveOtherInBill(Model.ClsKf_OtherInBillMain oMain, ref string sErrMsg) public bool SaveOtherInBill_CLD(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { //判断会计期是否合理 string s = ""; int sYear = 0; int sPeriod = 0; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oMain.HDate, ref sYear, ref sPeriod, ref s) == false) { sErrMsg = s; return false; } oMain.HYear = sYear; oMain.HPeriod = sPeriod; oCn.BeginTran(); //生成出入库单据 //插入子表 oCn.RunProc("EXEC h_p_Kf_OtherInBillSub_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + sHSourceType + "'"); //插入主表 oCn.RunProc("Insert Into Kf_ICStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ",HStockStyle" + ",HSTOCKORGID,HOWNERID" + ") " + " values('1203','1203'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "',convert(varchar(10),getdate(),120),'" + oMain.HMainSourceBillType + "'" + ", " + oMain.HYear.ToString() + "," + oMain.HPeriod.ToString() + ",'" + oMain.HRemark + "','" + oMain.HMaker + "',convert(varchar(10),getdate(),120)" + ", " + oMain.HSupID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HEmpID.ToString() + "," + oMain.HManagerID.ToString() + "," + oMain.HSecManagerID.ToString() + ", " + oMain.HKeeperID.ToString() + "," + oMain.HDeptID.ToString() + ",'" + oMain.HExplanation + "','" + oMain.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(oMain.HRedBlueFlag) + ",'" + oMain.HStockStyle + "'" + ", " + oMain.HSTOCKORGID.ToString() + "," + oMain.HOWNERID.ToString() + ") "); //更新关联数量 if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数 自动审核 { //审核单据 oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + oMain.HInterID.ToString()); } //根据TMP表 返回 子表信息 DataSet Ds; Ds = oCn.RunProcReturn("exec h_p_Kf_GetOtherInBill_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetOtherInBill_CLD"); if (Ds == null || Ds.Tables[0].Rows.Count == 0 || Ds.Tables[1].Rows.Count == 0) { sErrMsg = "获取子表信息失败！"; oCn.RollBack(); return false; } else { string sJson_StockStyle = ""; if (oSystemParameterMain.WMS_CampanyName == "韩电") //系统参数 客户定制化名称 空白为通用 { sJson_StockStyle = "\"F_RKLX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_RKLX"]) + "\","; //入库类型 } else if (oSystemParameterMain.WMS_CampanyName == "四维尔") //系统参数 客户定制化名称 空白为通用 { sJson_StockStyle = "\"F_ABCD_COMBO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_ABCD_COMBO"]) + "\","; //其他入库业务类型 } else { sJson_StockStyle = ""; } string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\",\"IsEntryBatchFill\":\"True\",\"Model\":{\"FBillNo\":\"" + oMain.HBillNo + "\"," + //\"FID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FID"]) + "\"," + "\"FBillTypeID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBillTypeID"]) + "\"}," + "\"FStockOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockOrgId"]) + "\"}," + "\"FStockDirect\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockDirect"]) + "\"," + "\"FDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDate"]) + "\"," + //"\"FSUPPLIERID\":{\"FNumber\":\"" + oMain.HSupplyID.ToString() + "\"}," + "\"FDEPTID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDEPTID"]) + "\"}," + //"\"FSTOCKERID\":{\"FName\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERID"]) + "\"}," + //"\"FSTOCKERGROUPID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERGROUPID"]) + "\"}," + "\"FOwnerTypeIdHead\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerTypeIdHead"]) + "\"," + "\"FOwnerIdHead\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerIdHead"]) + "\"}," + "\"FNOTE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FNOTE"]) + "\"," + "\"FBaseCurrId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBaseCurrId"]) + "\"}," + "\"FScanBox\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FScanBox"]) + "\"," + sJson_StockStyle + "\"FEntity\":["; string sJson_Entry = ""; for (int i = 0; i < Ds.Tables[1].Rows.Count; i++) { if (sJson_Entry != "") { sJson_Entry = sJson_Entry + " , "; } string sJson_BatchNo = ""; string sJson_StockPlace = ""; string sJson_FAUXPROPID = ""; if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["HISBATCHMANAGE"]) == "1") //是否启用批次管理 { sJson_BatchNo = " \"FLOT\": {\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"}, \"FLOT_TEXT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\" , "; } else { sJson_BatchNo = ""; } if (oSystemParameterMain.WMS_CampanyName == "卓力") //系统参数 客户定制化名称 空白为通用 { sJson_StockPlace = "\"FStockLocId\":{\"FSTOCKLOCID__FF100002\":{\"FNUMBER\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},"; } else { if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) == "") { sJson_StockPlace = ""; } else { sJson_StockPlace = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},"; } } //辅助属性 if (oSystemParameterMain.WMS_CampanyName == "卓力" || oSystemParameterMain.WMS_CampanyName == "韩电") //系统参数 客户定制化名称 空白为通用 { sJson_FAUXPROPID = ""; } else { sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},"; } //自定义字段处理 sJson_Entry = sJson_Entry + "{\"FEntryID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntryID"]) + "\"," + "\"FMATERIALID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMATERIALID"]) + "\"}," + sJson_FAUXPROPID + //"\"FAuxPropId\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAuxPropId"]) + "\"}," + //"\"FAUXPROPID__FF100030\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID__FF100030"]) + "\"}," + //"\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID__FF100002"]) + "\"}}," + "\"FUnitID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FUnitID"]) + "\"}," + "\"FSTOCKSTATUSID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKSTATUSID"]) + "\"}," + "\"FQty\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FQty"]) + "," + "\"FBaseUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseUnitId"]) + "\"}," + "\"FSTOCKID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKID"]) + "\"}," + sJson_StockPlace + //"\"FStockLocId\":{\"FSTOCKLOCID__FF100002\":{\"FNUMBER\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}}," + //"\"FLOT\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"}," + sJson_BatchNo + "\"FEntryNote\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntryNote"]) + "\"," + //"\"FBOMID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBOMID"]) + "\"}," + //"\"FPRODUCEDATE\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPRODUCEDATE"]) + "," + //"\"FMTONO\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMTONO"]) + "," + "\"FExtAuxUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExtAuxUnitId"]) + "\"}," + //"\"FProjectNo\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProjectNo"]) + "," + "\"FExtAuxUnitQty\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExtAuxUnitQty"]) + "," + "\"FOWNERTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERTYPEID"]) + "\"," + "\"FOWNERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERID"]) + "\"}," + "\"FKEEPERTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEEPERTYPEID"]) + "\"," + "\"FKEEPERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEEPERID"]) + "\"}} "; } //"\"FInStockEntry_Link_FSId\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FInStockEntry_Link_FSId"]) + string sJson_End = " ] }}"; string sJson = sJson_Main + sJson_Entry + sJson_End; //从配置文件获取 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"]); } //生成 其他入库单 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 }); // 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 }); // 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; //} } } catch (Exception e) { sErrMsg = "其他入库单失败！" + e.Message; oCn.RollBack(); return false; } } ///生成其他入库单 public bool set_SaveOtherInBill(Model.ClsKf_OtherInBillMain oMain, ref string sErrMsg) { //获取系统参数 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); @@ -7247,55 +7720,20 @@ //生成其他出库单 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; } } @@ -7538,5 +7976,105 @@ } #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 #region [获取默认打印模板] /// <summary> /// 默认打印模板 /// </summary> /// <param name="sWhere"></param> /// <param name="sErr"></param> /// <returns></returns> public DataSet GetDefaultOpenTmp(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 //返回条码临时表 /// <summary> /// 返回条码临时表 /// </summary> public DataSet GetBarCode_Temp(long HInterID, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBillType, string sWhere) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); return dal.GetBarCodeByID_View(HInterID, sBillType, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere); } //删除出入库条码临时表(根据条码) public bool set_DelPonderationBillMain_Temp_BarCode(long HInterID, string sBarCode, string sHBillType, ref string sErrMsg) { DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); if (dal.DeleteByBarCode(HInterID, sBarCode, sHBillType)) { sErrMsg = "删除成功！"; return true; } else { sErrMsg = "删除失败！"; return false; } } /// <summary> /// 返回扫码明细信息 /// </summary> public DataSet GetBarcodeList(long HInterID, string HBillNo, string sBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg) { DAL.ClsKF_PonderationBillMain_Temp_View bll = new DAL.ClsKF_PonderationBillMain_Temp_View(); return bll.GetBillEntry_TmpList(HInterID, HBillNo, sBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref sErrMsg); //DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); //return dal.GetInfoByID_View(HInterID, sBillType, sWhere); } //撤销缓存列表选中数据 public bool RescindBillList(Int64 sHInterID, string sBillNo, string sBillType, ref string sErrMsg) { DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); if (dal.DeleteICStockBillAndWMS(sHInterID, sBillNo, sBillType, ref sErrMsg)) { sErrMsg = "删除成功！"; return true; } else { sErrMsg = "删除失败！"; return false; } } //返回缓存列表已上传列表信息 public DataSet GetDisBillUpdateLoad_Json(string sHBillType, string HMaker, Int64 HOrgID) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID); } //返回缓存列表查询已上传列表信息 public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo) { DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo); } } }
