| | |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Web; |
| | | using Kingdee.BOS.WebApi.Client; |
| | | //using Kingdee.BOS.WebApi.Client; |
| | | |
| | | |
| | | namespace WebAPI |
| | |
| | | //DAL.ClsIF_Department_View dal = new DAL.ClsIF_Department_View(); |
| | | //return dal.GetList(sWhere); |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取物料列表 |
| | |
| | | } |
| | | #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); |
| | |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region 外购退料 外购入库(红字) * |
| | | |
| | | public bool set_SavePOStockInBackBill_New(WebAPI.WebS.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg) |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SavePOStockInBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveEntrustInBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveProductInBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | 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 |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveMateOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveSellOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | } |
| | | } |
| | | |
| | | //根据托条码 获取条码档案列表唯一码信息 |
| | | 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(); |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveMoveStockBill(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | //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) |
| | | { |
| | |
| | | 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(); |
| | |
| | | // return null; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 外购入库 |
| | |
| | | //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(); |
| | |
| | | |
| | | |
| | | //返回缓存列表信息 同步资料 |
| | | 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); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | |
| | | //判断是否反写成功 |
| | | 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; |
| | | } |
| | | } |
| | |
| | | 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 |
| | |
| | | //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 |
| | |
| | | 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 |
| | | { |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveMateOutBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | DAL.Cls_S_IF_SellOutBill_Lite dal = new DAL.Cls_S_IF_SellOutBill_Lite(); |
| | | return dal.DisSourceBillList(sWhere); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 委外入库 |
| | | |
| | | |
| | | /// <summary> |
| | | /// 生成委外入库单K3 |
| | | /// </summary> |
| | | /// <param name="oMain"></param> |
| | | /// <param name="sErrMsg"></param> |
| | | /// <returns></returns> |
| | | public bool SaveEntrustInBill_K3(Model.ClsKf_EntrustInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | /// <summary> |
| | | /// 生成委外入库单K3 |
| | | /// </summary> |
| | | /// <param name="oMain"></param> |
| | | /// <param name="sErrMsg"></param> |
| | | /// <returns></returns> |
| | | public bool SaveEntrustInBill_K3(Model.ClsKf_EntrustInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DAL.ClsKf_EntrustInBill dal = new DAL.ClsKf_EntrustInBill(); |
| | |
| | | //判断是否反写成功 |
| | | 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; |
| | | } |
| | | } |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveEntrustOutBackBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //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) |
| | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | if (oWebs.set_SaveEntrustOutBill_New(oMain, sHSourceType, ref sErrMsg)) |
| | | { |
| | | sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | //sErrMsg = "保存成功!" + oMain.HBillNo; |
| | | return true; |
| | | } |
| | | else |
| | |
| | | } |
| | | |
| | | |
| | | //生成其他入库单 |
| | | 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(); |
| | |
| | | |
| | | |
| | | //生成其他出库单 |
| | | 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 |
| | | |
| | | #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); |
| | | } |
| | | |
| | | } |
| | | } |