From 2ac90163499626a2e2c4b4a46219b944dc6c9b17 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期三, 06 九月 2023 13:45:30 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/LMESController.cs | 268 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 268 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index 6b74fad..12bc5d0 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -117,6 +117,274 @@ } } + + /// <summary> + /// 宸ュ簭娴佽浆鍗″彧鏄剧ず宸ュ簭鏌撳巶鐨勬暟鎹� + /// </summary> + /// <param name="sWhere"></param> + /// <param name="user"></param> + /// <returns></returns> + [Route("LEMS/MES_ProcessExchangeBillList_Json")] + [HttpGet] + public object MES_ProcessExchangeBillList_Json(string sWhere, string user,int OperationType) + { + DataSet ds; + try + { + List<object> columnNameList = new List<object>(); + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡璇㈡潈闄�!"; + objJsonResult.data = null; + return objJsonResult; + } + + if (OperationType == 1) { + //鑾峰彇绯荤粺鍙傛暟 + string Ret = ""; + if (oSystemParameter.ShowBill(ref Ret)) + { + //鍒ゆ柇瀹㈡埛涓轰箶涓� + if (oSystemParameter.omodel.WMS_CampanyName == "涔斾竴") + { + sWhere += " and 宸ュ簭='鏌撳巶' "; + + } + else { + sWhere += " and 宸ュ簭='绮楃(' "; + } + } + + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillList"); + } + else + { + //鑾峰彇绯荤粺鍙傛暟 + string Ret = ""; + if (oSystemParameter.ShowBill(ref Ret)) + { + //鍒ゆ柇瀹㈡埛涓洪緳灞辨苯閰� + if (oSystemParameter.omodel.WMS_CampanyName == "涔斾竴") + { + + + } + } + + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeArrangementList where 1 = 1 " + sWhere , "h_v_Sc_ProcessExch_v_Sc_ProcessExchangeArrangementListhangeBillList"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.list = columnNameList; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "寮傚父锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + #region 鎺掔几鍔熻兘 + [Route("LEMS/ProcessExchangeArrangement_Add")] + [HttpGet] + public object ProcessExchangeArrangement_Add(string HInterID_S, int HSourceID,long HOrgID,string user) + { + DataSet ds; + DataSet ds1; + try + { + var HNum = HInterID_S.Split(','); + + oCN.BeginTran(); + + for (int j = 0; j < HNum.Length; j++) + { + long HInterID = long.Parse(HNum[j].Split('|')[0]); + long HEntryID = long.Parse(HNum[j].Split('|')[1]); + ds = oCN.RunProcReturn(@"select a.HMaterID,b.HProcID,a.HBillNo from Sc_ProcessExchangeBillMain a inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID +where a.HInterID=" + HInterID + " and b.HEntryID=" + HEntryID, "Sc_ProcessExchangeBillMain"); + if (ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤姝ゅ伐搴忔祦杞崱锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + //鏌ヨ瀛愬伐鑹鸿矾绾跨墿鏂� 宸ュ簭 + string HMaterID = ds.Tables[0].Rows[0]["HMaterID"].ToString(); + string HProcID = ds.Tables[0].Rows[0]["HProcID"].ToString(); + + ds1 = oCN.RunProcReturn(@"select a.HMaterID,a.HMainProcID,b.* from Gy_RoutingBillMain a inner join Gy_RoutingBillSub b on a.HInterID=b.HInterID where a.HMaterID=" + HMaterID + " and a.HMainProcID=" + HProcID + " and a.HBillSubType='SUB'", "Gy_RoutingBillMain"); + if (ds1.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鐩稿搴旂殑榛樿宸ヨ壓璺嚎,璇峰厛璁剧疆宸ヨ壓璺嚎锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); + string sReturn = ""; + DBUtility.ClsPub.HOrgID = HOrgID; + oBill.ShowBill(HInterID, ref sReturn); + + long HInterID1 = DBUtility.ClsPub.CreateBillID(oBill.omodel.HBillType, ref DBUtility.ClsPub.sExeReturnInfo); + string HBillNo = DBUtility.ClsPub.CreateBillCode(oBill.omodel.HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); + oBill.omodel.HInterID = HInterID1; + oBill.omodel.HBillNo = HBillNo; + oBill.omodel.HBillSubType = "SUB"; + oBill.omodel.HDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); + oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); + oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); + oBill.omodel.HMaker = user; + oBill.omodel.HMakeDate = DateTime.Now.ToString(); + oBill.omodel.HMainSourceInterID = HInterID; + oBill.omodel.HMainSourceEntryID = HEntryID; + oBill.omodel.HMainSourceBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); + + oBill.DetailColl.Clear(); + + + for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) + { + Model.ClsSc_ProcessExchangeBillSub oSub = new Model.ClsSc_ProcessExchangeBillSub(); + oSub.HInterID = HInterID1; + oSub.HEntryID = (i + 1); + oSub.HProcNo = long.Parse(ds1.Tables[0].Rows[i]["HProcNo"].ToString()); + oSub.HProcID = long.Parse(ds1.Tables[0].Rows[i]["HProcID"].ToString()); + oSub.HWorkRemark = ds1.Tables[0].Rows[i]["HRemark"].ToString(); + oSub.HCenterID = long.Parse(ds1.Tables[0].Rows[i]["HCenterID"].ToString()); + oSub.HSupID = long.Parse(ds1.Tables[0].Rows[i]["HSupID"].ToString()); + oSub.HSupFlag = ds1.Tables[0].Rows[i]["HSupFlag"].ToString() == "1" ? true : false; + oSub.HQty = oBill.omodel.HQty; + oSub.HTechnologyParameter = ""; + oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); + oBill.DetailColl.Add(oSub); + } + + + bool bResult = false; + bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + + oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=" + HSourceID + " where HInterID=" + HInterID + " and HEntryID=" + HEntryID); + + if (!bResult) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娲惧伐澶辫触锛�" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + + 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 = "寮傚父锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鍙栨秷鎺掔几鍔熻兘 + [Route("LEMS/ProcessExchangeArrangementDel")] + [HttpGet] + public object ProcessExchangeArrangementDel(string HInterID_S, int HSourceID, long HOrgID, string user) + { + DataSet ds; + DataSet ds1; + try + { + var HNum = HInterID_S.Split(','); + + oCN.BeginTran(); + + for (int j = 0; j < HNum.Length; j++) + { + + ds = oCN.RunProcReturn(@"select * from Sc_ProcessExchangeBillMain a where a.HInterID=" + HNum[j], "Sc_ProcessExchangeBillMain"); + if (ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤姝ゅ瓙宸ュ簭娴佽浆鍗★紒"; + objJsonResult.data = null; + return objJsonResult; + } + + string HMainSourceInterID = ds.Tables[0].Rows[0]["HMainSourceInterID"].ToString(); + string HMainSourceEntryID = ds.Tables[0].Rows[0]["HMainSourceEntryID"].ToString(); + + ds1 = oCN.RunProcReturn(@"select * from Sc_ProcessExchangeBillMain where HInterID=" + HMainSourceInterID, "Sc_ProcessExchangeBillMain"); + if (ds1.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤姝ゅ瓙宸ュ簭娴佽浆鍗″搴旂殑涓诲伐搴忔祦杞崱锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=0 where HInterID=" + HMainSourceInterID + " and HEntryID=" + HMainSourceEntryID); + oCN.RunProc("delete from Sc_ProcessExchangeBillMain where HInterID=" + HNum[j]); + oCN.RunProc("delete from Sc_ProcessExchangeBillSub where HInterID=" + HNum[j]); + } + + 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 = "寮傚父锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + /// <summary> /// 杩斿洖宸ュ簭娴佽浆鍗$淮鎶ゅ垪琛ㄤ粠琛� ///鍙傛暟锛歴tring sql銆� -- Gitblit v1.9.1