派生自 MES-WEB-API
WebAPI/Controllers/WebAPIController.cs
@@ -2663,7 +2663,7 @@ try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select a.HItemID ,HNumber 核算方式组代码,HName 核算方式组名称,HDeptID,b.部门名称 部门 from Gy_ClassTimePrjGroup a left join h_v_Gy_Department b on a.HDeptID=b.HItemID"; string sql = "Select a.HItemID ,HNumber 核算方式组代码,HName 核算方式组名称,HDeptID,b.部门代码,b.部门名称 部门 from Gy_ClassTimePrjGroup a left join h_v_Gy_Department b on a.HDeptID=b.HItemID"; if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); @@ -3410,7 +3410,7 @@ { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } @@ -3466,7 +3466,63 @@ { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; objjson.list = columnNameList; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取检仪器列表 /// </summary> /// <returns></returns> [Route("Web/GetGy_InspectInstruMent")] [HttpGet] public object GetGy_InspectInstruMent(string InspectInstruMent, int OrganizationID) { if (InspectInstruMent != "") { sWhere = " and ( 检验仪器代码 like '%" + InspectInstruMent + "%' or 检验仪器名称 like '%" + InspectInstruMent + "%' ) "; } try { List<object> columnNameList = new List<object>(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select * from h_v_Gy_InspectInstruMent where 1 = 1 " + sWhere + "Order by HItemID "; ds = oCN.RunProcReturn(sql, "h_v_Gy_InspectInstruMent"); //添加列名 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));//获取到DataColumn列对象的列名 } if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } @@ -4023,19 +4079,33 @@ #region [从数据库加载菜单] public class MenuLoad { //public int HitemID { get; set; } public string HitemID { get; set; } //public int? HPartentID { get; set; } public string HPartentID { get; set; } public string HNumber { get; set; } public string HName { get; set; } public int HLevel { get; set; } public string Hurl { get; set; } public string HPicNum { get; set; } public List<MenuLoad> childMenus { get; set; } } [Route("Web/MenuList")] [HttpGet] public object MenuList(string HMakeName) public object MenuList(string HMakeName, string HType) { try { List<Menu> mu = new List<Menu>(); //以父子级结构存放菜单清单信息 List<MenuLoad> mu = new List<MenuLoad>(); //以父子级结构存放菜单清单信息 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //数据库操作工具 string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' order by HItemID"; string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HType + "' order by HPosition"; ds = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); //查询当前用户的自定义菜单数据 if (ds.Tables[0]==null || ds.Tables[0].Rows.Count == 0) //判断当前用户是否有设置过自定义信息，若记录数为0，则没有设置过，加载所有的菜单信息 { sql = "Select * from Gy_Menu_1 Order by HItemID "; sql = "Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HPosition "; ds = oCn.RunProcReturn(sql, "Gy_Menu"); } @@ -4043,17 +4113,21 @@ { if (ds.Tables[0].Rows[i]["HPartentID"].ToString() == "0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //判断是否最外层根节点 { Menu tbj = new Menu(); MenuLoad tbj = new MenuLoad(); tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString(); tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString(); tbj.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString(); tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); if (ds.Tables[0].Rows[i]["HPicNum"] != null) { tbj.HPicNum = ds.Tables[0].Rows[i]["HPicNum"].ToString(); } mu.Add(tbj); } } ToHierarchy.digui(ds.Tables[0], mu); //使用递归，将需要加载的数据以父子级的结构存放在mu中 diguiLoad(ds.Tables[0], mu); //使用递归，将需要加载的数据以父子级的结构存放在mu中 objJsonResult.code = "1"; @@ -4071,6 +4145,38 @@ return objJsonResult; } } public void diguiLoad(DataTable dt, List<MenuLoad> tree) { for (int m = 0; m < tree.Count; m++) { tree[m].childMenus = new List<MenuLoad>(); for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集 { if (tree[m].HitemID.ToString() == dt.Rows[i]["HPartentID"].ToString() && dt.Rows[i]["HitemID"].ToString() != dt.Rows[i]["HPartentID"].ToString()) { MenuLoad tbjson = new MenuLoad(); tbjson.HitemID = dt.Rows[i]["HitemID"].ToString(); tbjson.HPartentID = dt.Rows[i]["HPartentID"].ToString(); tbjson.HNumber = dt.Rows[i]["HNumber"].ToString(); tbjson.HName = dt.Rows[i]["HName"].ToString(); tbjson.HLevel = tree[m].HLevel; tbjson.Hurl = dt.Rows[i]["Hurl"].ToString(); if (dt.Rows[i]["HPicNum"] != null) { tbjson.HPicNum = dt.Rows[i]["HPicNum"].ToString(); } tree[m].childMenus.Add(tbjson); } } for (int i = 0; i < tree[m].childMenus.Count; i++) { diguiLoad(dt, tree[m].childMenus);//再次用子集去循环，拿出子集的子集 } } } #endregion @@ -4114,7 +4220,7 @@ //自定义菜单：获取树组件数据 [Route("Web/MenuDefineSet")] [HttpGet] public object MenuDefineSet(string HMakeName) public object MenuDefineSet(string HMakeName, string HType) { try { @@ -4122,7 +4228,7 @@ List<MenuInit> menuInitList = new List<MenuInit>(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); ds = oCn.RunProcReturn("Select * from Gy_Menu_1 Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" +HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 DataSet ds1 = new DataSet(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中， @@ -4211,6 +4317,7 @@ string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HMakeName = sArray[1].ToString(); string saveData = sArray[0].ToString(); string HTypes = sArray[2].ToString(); List<SaveDefineMenu> saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SaveDefineMenu>>(saveData); //声明数据库操作工具 @@ -4220,7 +4327,7 @@ oCN.BeginTran(); //删除当前用户的自定义数据 string sql = "delete from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "'"; string sql = "delete from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HTypes + "'"; oCN.RunProc(sql); //插入当前用户最新的自定义数据 @@ -4235,9 +4342,20 @@ int HLevel = int.Parse(ds.Tables[0].Rows[0]["HLevel"].ToString()); string Hurl = ds.Tables[0].Rows[0]["Hurl"].ToString(); string HType = ds.Tables[0].Rows[0]["HType"].ToString(); string HPicNum = ds.Tables[0].Rows[0]["HPicNum"].ToString(); sql = "insert into Gy_MenuDefineSet values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "')"; oCN.RunProc(sql); if(HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"].ToString()) { string HPosition = ds.Tables[0].Rows[0]["HPosition"].ToString(); sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','" + HPosition + "')"; oCN.RunProc(sql); } else { sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','z')"; oCN.RunProc(sql); } } } //提交数据库操作 @@ -4273,7 +4391,7 @@ //快捷方式自定义菜单：获取树组件数据 [Route("Web/Xt_UserFastMenu_Display")] [HttpGet] public object Xt_UserFastMenu_Display(string HMakeName) public object Xt_UserFastMenu_Display(string HMakeName, string HType) { try { @@ -4281,7 +4399,7 @@ List<MenuInit> menuInitList = new List<MenuInit>(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); ds = oCn.RunProcReturn("Select * from Gy_Menu_1 Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 DataSet ds1 = new DataSet(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中， @@ -4365,6 +4483,7 @@ string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HMakeName = sArray[1].ToString(); string saveData = sArray[0].ToString(); string HTypes = sArray[2].ToString(); List<SaveDefineMenu> saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SaveDefineMenu>>(saveData); //声明数据库操作工具 @@ -4374,7 +4493,7 @@ oCN.BeginTran(); //删除当前用户的自定义数据 string sql = "delete from Xt_UserFastMenu where HUserID = '" + HMakeName + "'"; string sql = "delete from Xt_UserFastMenu where HUserID = '" + HMakeName + "' and HType = '" + HTypes + "'"; oCN.RunProc(sql); //插入当前用户最新的自定义数据 @@ -4391,8 +4510,9 @@ string HUserID = HMakeName; string HSubFuncID = ds.Tables[0].Rows[0]["HItemID"].ToString(); string HCaption = ds.Tables[0].Rows[0]["HName"].ToString(); string HType = ds.Tables[0].Rows[0]["HType"].ToString(); sql = "insert into Xt_UserFastMenu(HUserID,HSubFuncID,HCaption) values('" + HUserID + "','" + HSubFuncID + "','" + HCaption + "')"; sql = "insert into Xt_UserFastMenu(HUserID,HSubFuncID,HCaption,HType) values('" + HUserID + "','" + HSubFuncID + "','" + HCaption + "','" + HType + "')"; oCN.RunProc(sql); } } @@ -4422,12 +4542,68 @@ //快捷方式自定义菜单：获取树组件数据 [Route("Web/Xt_UserFastMenu_Init")] [HttpGet] public object Xt_UserFastMenu_Init(string HMakeName) public object Xt_UserFastMenu_Init(string HMakeName, string HType) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "select a.HSubFuncID, a.HCaption,a.HPicNum,b.Hurl from Xt_UserFastMenu as a join Gy_Menu_1 as b on a.HSubFuncID = b.HItemID where a.HUserID = '" + HMakeName + "' Order by a.HItemID"; string sql = "select a.HSubFuncID, a.HCaption,a.HPicNum,b.Hurl from Xt_UserFastMenu as a join Gy_Menu_1 as b on a.HSubFuncID = b.HItemID where a.HUserID = '" + HMakeName + "' and b.HType = '" + HType + "' Order by a.HItemID"; ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 保存快捷方式的图标 [Route("Web/Xt_UserFastMenu_IconSave")] [HttpGet] public object Xt_UserFastMenu_IconSave(string Icon, string HItemID, string HMakeName) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "update Xt_UserFastMenu set HPicNum = '" + Icon + "' where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'"; oCN.RunProc(sql); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 获取快捷方式的图标 [Route("Web/Xt_UserFastMenu_IconGet")] [HttpGet] public object Xt_UserFastMenu_IconGet(string HItemID, string HMakeName) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "select HPicNum from Xt_UserFastMenu where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'"; ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1";
