From bae6f41fd7ab5f4c572e196a0646f61ec6fb03f2 Mon Sep 17 00:00:00 2001 From: 杨乐 <yang.le.192@qq.com> Date: 星期三, 26 一月 2022 16:25:36 +0800 Subject: [PATCH] 条码主档 采购管理 权限编辑 --- WebAPI/WebServer.cs | 204 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 203 insertions(+), 1 deletions(-) diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs index 97255aa..897c588 100644 --- a/WebAPI/WebServer.cs +++ b/WebAPI/WebServer.cs @@ -54,6 +54,8 @@ //return dal.GetList(sWhere); } + + /// <summary> /// 鑾峰彇鐗╂枡鍒楄〃 /// </summary> @@ -1122,6 +1124,7 @@ #endregion + #region 澶栬喘閫�鏂� 澶栬喘鍏ュ簱锛堢孩瀛楋級 * public bool set_SavePOStockInBackBill_New(WebAPI.WebS.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg) @@ -1991,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 @@ -3990,6 +3998,25 @@ //sErrMsg = "淇濆瓨璋冩嫧鍗曞け璐ワ紒" + 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) { @@ -4023,6 +4050,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(); @@ -4055,7 +4144,7 @@ // return null; // } //} - + #endregion #region 澶栬喘鍏ュ簱 @@ -4409,11 +4498,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); } + @@ -4485,6 +4583,33 @@ 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; + } + } + /// <summary> /// 鐢熸垚澶栬喘鍏ュ簱鍗昁3 @@ -7770,5 +7895,82 @@ } #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 + + //杩斿洖鏉$爜涓存椂琛� + /// <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); + } + } } \ No newline at end of file -- Gitblit v1.9.1