From 9e13bff7663cbf3aaf112364c9f81664cb1229d5 Mon Sep 17 00:00:00 2001 From: wyb <1qaz@123> Date: 星期四, 27 五月 2021 17:49:30 +0800 Subject: [PATCH] 职务列表查询逻辑编写 --- WebAPI/WebServer.cs | 118 +++++++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 95 insertions(+), 23 deletions(-) diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs index b4871e7..8ed27bd 100644 --- a/WebAPI/WebServer.cs +++ b/WebAPI/WebServer.cs @@ -53,6 +53,34 @@ //DAL.ClsIF_Department_View dal = new DAL.ClsIF_Department_View(); //return dal.GetList(sWhere); } + + /// <summary> + /// 鑾峰彇鐗╂枡鍒楄〃 + /// </summary> + /// <param name="sWhere"></param> + /// <param name="sErr"></param> + /// <returns></returns> + public DataSet GetMaterialList(string sWhere, ref string sErr) + { + BLL.ClsIF_Material_View bll = new BLL.ClsIF_Material_View(); + return bll.GetList(sWhere, ref DBUtility.ClsPub.sExeReturnInfo); + } + + //ClsGy_Unit_View + /// <summary> + /// 鑾峰彇鍗曚綅鍒楄〃 + /// </summary> + /// <param name="sWhere"></param> + /// <param name="sErr"></param> + /// <returns></returns> + public DataSet GetUnitList(string sWhere, ref string sErr) + { + + DAL.ClsGy_Unit_View dal = new DAL.ClsGy_Unit_View(); + return dal.GetList(sWhere); + } + + /// <summary> /// 鑱屽憳鍒楄〃 /// </summary> @@ -4438,8 +4466,17 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SavePOStockInBill_New(oMain, sHSourceType, ref sErrMsg)) { - sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo; - return true; + //鍒ゆ柇鏄惁鍙嶅啓鎴愬姛 + if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) + { + sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo; + return true; + } + else + { + sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo + "鐘舵�佸弽鍐欏け璐ワ紒"; + return true; + } } else { @@ -4790,8 +4827,17 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveProductInBill_New(oMain, sHSourceType, ref sErrMsg)) { - sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo; - return true; + //鍒ゆ柇鏄惁鍙嶅啓鎴愬姛 + if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) + { + sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo; + return true; + } + else + { + sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo + "鐘舵�佸弽鍐欏け璐ワ紒"; + return true; + } } else { @@ -4800,15 +4846,29 @@ } } + //鏍规嵁id鍙嶅啓鏉$爜妗f琛ㄧ姸鎬� + public bool set_UpdateHStatus(long HinterID, string HMESSPName) + { + try + { + new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_WMS_UpdateMESSPtoBarCode " + HinterID + "," + "'" + HMESSPName + "'", "h_p_WMS_UpdateMESSPtoBarCode"); + return true; + } + catch (Exception ex) + { + return false; + } + } - /// <summary> - /// 鐢熸垚浜у搧鍏ュ簱鍗� - /// </summary> - /// <param name="oMain"></param> - /// <param name="sHSourceType"></param> - /// <param name="sErrMsg"></param> - /// <returns></returns> - public bool set_SaveProductInBill(Model.ClsKf_ProductInBillMain oMain, ref string sErrMsg) + + /// <summary> + /// 鐢熸垚浜у搧鍏ュ簱鍗� + /// </summary> + /// <param name="oMain"></param> + /// <param name="sHSourceType"></param> + /// <param name="sErrMsg"></param> + /// <returns></returns> + public bool set_SaveProductInBill(Model.ClsKf_ProductInBillMain oMain, ref string sErrMsg) { DAL.ClsKf_ProductInBill dal = new DAL.ClsKf_ProductInBill(); dal.omodel = oMain; @@ -5164,18 +5224,21 @@ DAL.Cls_S_IF_SellOutBill_Lite dal = new DAL.Cls_S_IF_SellOutBill_Lite(); return dal.DisSourceBillList(sWhere); } - #endregion + + + + #endregion #region 濮斿鍏ュ簱 - /// <summary> - /// 鐢熸垚濮斿鍏ュ簱鍗昁3 - /// </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> + /// 鐢熸垚濮斿鍏ュ簱鍗昁3 + /// </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(); @@ -5313,9 +5376,18 @@ WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveEntrustInBill_New(oMain, sHSourceType, ref sErrMsg)) { - sErrMsg = "淇濆瓨鎴愬姛锛�" + oMain.HBillNo; - return true; - } + //鍒ゆ柇鏄惁鍙嶅啓鎴愬姛 + 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; -- Gitblit v1.9.1