From 10257764d75ae8fd6ca9419e80ebaa66c80e95fa Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期一, 03 一月 2022 13:52:48 +0800 Subject: [PATCH] nothing --- WebAPI/Controllers/BarCodeController.cs | 140 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 138 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/BarCodeController.cs b/WebAPI/Controllers/BarCodeController.cs index 568d55b..c8bb13e 100644 --- a/WebAPI/Controllers/BarCodeController.cs +++ b/WebAPI/Controllers/BarCodeController.cs @@ -1385,7 +1385,7 @@ for (int i = 0; i < HBQty; i++) { // 瀹夌憺鏉$爜瑙勫垯锛氱墿鏂欑紪鐮侊紙绯荤粺浠e叆锛堾鐗╂枡鍚嶇О锛堢郴缁熶唬鍏ワ級@瑙勬牸鍨嬪彿锛堢郴缁熶唬鍏ワ級@鐢熶骇鏃ユ湡锛堟墜宸ヨ緭鍏ワ級@鏁伴噺锛堟墜宸ヨ緭鍏ワ級@澶辨晥鏃ユ湡锛堟墜宸ヨ緭鍏ワ級@鎵规鍙凤紙鎵嬪伐浠e叆锛堾渚涘簲鍟嗗悕绉帮紙绯荤粺浠e叆锛堾閲囪喘璁㈠崟鍙凤紙绯荤粺浠e叆锛� - TM =$"{oItemSub.HMaterNumber}@{oItemSub.HMaterName}@{oItemSub.HMaterModel}@{oItemSub.HKFDate}@{oItemSub.HQty}@{oItemSub.HKFDQDate}@{oItemSub.HBatchNo}@{oItemSub.HSupName}@{oItemSub.HSourceBillNo}"; + TM = $"{oItemSub.HMaterNumber}@{oItemSub.HMaterName}@{oItemSub.HMaterModel}@{oItemSub.HKFDate}@{oItemSub.HQty}@{oItemSub.HKFDQDate}@{oItemSub.HBatchNo}@{oItemSub.HSupName}@{oItemSub.HSourceBillNo}"; if (HSumQty - HMinQty > 0) { @@ -1604,7 +1604,7 @@ + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1" + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')"); - + } } //鏆傛椂鍙洖濉叧鑱旀暟閲� @@ -1629,5 +1629,141 @@ return objJsonResult; } #endregion + + #region 濮斿璁㈠崟鏉$爜鐢熸垚鍔熻兘锛堝畨鐟烇級 + [Route("GetHBarCodeShowBillMainBywy")] + /// <summary> + /// 鏉$爜鐢熸垚琛ㄥご锛堥噰璐鍗曪級 + /// </summary> + /// <param name="sMsg"></param> + /// <returns></returns> + public object GetHBarCodeShowBillMainBywy(string sMsg) + { + try + { + DataSet ds; + string s = ""; + string ShowItem = " * ";//鏄剧ず鐨勫瓧娈� + if (DBUtility.ClsPub.isLong(sMsg) == 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触"; + objjson.data = null; + return objjson; + } + DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill(); + string sql = string.Format(@"select * from h_v_SRM_EntrustOrderBillMain_ForWeb2 where HInterID = " + sMsg); + ds = oCn.RunProcReturn(sql, "h_v_SRM_EntrustOrderBillMain_ForWeb2"); + //ds = oClsWeb_BarCodeBill.ShowBillMain1(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触"; + objjson.data = null; + return objjson; + } + else + { + + objjson.code = "0"; + objjson.count = 10000; + objjson.Message = "鑾峰彇鎴愬姛"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception e) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + e.ToString(); + objjson.data = null; + return objjson; + } + } + [Route("GetHBarCodeShowBillSubBywy")] + [HttpGet] + /// <summary> + /// 鏉$爜鐢熸垚琛ㄤ綋锛堥噰璐鍗曪級 + /// </summary> + /// <param name="sMsg"></param> + /// <returns></returns> + public object GetHBarCodeShowBillSubBywy(string sMsg) + { + try + { + DataSet ds; + string s = ""; + string ShowItem = " * ";//鏄剧ず鐨勫瓧娈� + if (DBUtility.ClsPub.isLong(sMsg) == 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触"; + objjson.data = null; + return objjson; + } + DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill(); + string sql = string.Format(@"select * from h_v_srm_EntrustOrderBillSub_ForWeb2 where HInterID = " + sMsg); + ds = oCn.RunProcReturn(sql, "h_v_srm_EntrustOrderBillSub_ForWeb2"); + //ds = oClsWeb_BarCodeBill.ShowBillSub(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触"; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "0"; + objjson.count = 10000; + objjson.Message = "鑾峰彇鎴愬姛"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception e) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + e.ToString(); + objjson.data = null; + return objjson; + } + } + + [Route("DeltetBarCodeBill")] + [HttpGet] + public object DeltetBarCodeBill(string HInterID, string HUserName) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + try + { + WebAPIController.Add_Log("鏉$爜妗f鍒犻櫎", HUserName, "鏉$爜妗f鍒犻櫎"); + oCN.BeginTran(); + //LogService.Write("Delete From Gy_BarCodeBill where HItemID in(" + HInterID + ")") ; + oCN.RunProc("Delete From Gy_BarCodeBill where HItemID in(" + HInterID + ") "); + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1