From 8c0f02a6bfab6e36102fd3e045cb4691959f6054 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期五, 19 五月 2023 13:58:27 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs | 149 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 149 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs index d2fde60..9d779c3 100644 --- a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs +++ b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs @@ -143,5 +143,154 @@ } #endregion + + + #region 鎸夐挳璁剧疆 鍒楄〃 + [Route("Xt_ModuleButtonSet_WMES/moduleButtonSetWMESList")] + [HttpGet] + public object moduleButtonSetWMESList(string HModName, string HBillType) + { + try + { + ds = oCN.RunProcReturn("select * from Xt_ModuleButtonSet where HModuleName='" + HModName + "' and HBillType='" + HBillType + "'", "Xt_ModuleButtonSet"); + + objJsonResult.code = "1"; + objJsonResult.count = ds.Tables[0].Rows.Count; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鎸夐挳璁剧疆 娣诲姞/淇敼 + public class moduleButtonSet + { + public string BtnID; + public string BtnName; + public bool IsHide; + } + public class noEditList + { + public string HBillType; + public string HModuleName; + public string HButtonID; + public string HButtonName; + public int HOrder; + public bool HHideFlag; + public bool HEditFlag; + } + + [Route("Xt_ModuleButtonSet_WMES/AddModuleButtonSetWMES")] + [HttpPost] + public object AddModuleButtonSetWMES([FromBody] JObject sMainSub) + { + var _value = sMainSub["sMainSub"].ToString(); + string msg1 = _value.ToString(); + oCN.BeginTran(); + //淇濆瓨涓昏〃 + objJsonResult = AddButtonMain(msg1); + if (objJsonResult.code == "0") + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = objJsonResult.Message; + objJsonResult.data = null; + return objJsonResult; + } + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + public json AddButtonMain(string msg1) + { + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string sTableData = sArray[0].ToString(); + string HButtonIDList = sArray[1].ToString(); + string HButtonNameList = sArray[2].ToString(); + string HOrderList = sArray[3].ToString(); + string HModuleName = sArray[4].ToString(); + string HBillType = sArray[5].ToString(); + string NoEditList = sArray[6].ToString(); + + try + { + List<moduleButtonSet> button = Newtonsoft.Json.JsonConvert.DeserializeObject<List<moduleButtonSet>>(sTableData); + List<string> HButtonIDLists = Newtonsoft.Json.JsonConvert.DeserializeObject<List<string>>(HButtonIDList); + List<string> HButtonNameLists = Newtonsoft.Json.JsonConvert.DeserializeObject<List<string>>(HButtonNameList); + List<int> HOrderLists = Newtonsoft.Json.JsonConvert.DeserializeObject<List<int>>(HOrderList); + List<noEditList> noEditLists= Newtonsoft.Json.JsonConvert.DeserializeObject<List<noEditList>>(NoEditList); + + //鎻掑叆鍙紪杈戞寜閽殑淇℃伅璁板綍 + oCN.RunProc("delete from Xt_ModuleButtonSet where HModuleName= '" + HModuleName + "' and HBillType='" + HBillType + "'"); + for (int i = 0; i < button.Count; i++) + { + for(int j = 0; j < HButtonIDLists.Count; j++) + { + if (button[i].BtnID == HButtonIDLists[j]) + { + int HHideFlag = 0; + int HEditFlag = 1; + string HButtonID = HButtonIDLists[j].ToString(); + string HButtonName = HButtonNameLists[j].ToString(); + int HOrder = HOrderLists[j]; + if (button[i].IsHide) + { + HHideFlag = 1; + } + string sql = "exec h_p_Xt_ModuleButtonSet '" + HBillType + "','" + HModuleName + "','" + HButtonID + "','" + HButtonName + "'," + HOrder + "," + HHideFlag + "," + HEditFlag; + oCN.RunProc(sql); + } + } + } + + //閲嶆柊鎻掑叆涓嶅彲缂栬緫鎸夐挳鐨勪俊鎭褰� + for (int i = 0; i < noEditLists.Count; i++) + { + for (int j = 0; j < HButtonIDLists.Count; j++) + { + if (noEditLists[i].HButtonID == HButtonIDLists[j]) + { + int HHideFlag = noEditLists[i].HHideFlag?1:0; + int HEditFlag = 0; + string HButtonID = noEditLists[i].HButtonID; + string HButtonName = noEditLists[i].HButtonName; + int HOrder = HOrderLists[j]; + string sql = "exec h_p_Xt_ModuleButtonSet '" + HBillType + "','" + HModuleName + "','" + HButtonID + "','" + HButtonName + "'," + HOrder + "," + HHideFlag + "," + HEditFlag; + oCN.RunProc(sql); + } + } + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = null; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + 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