| | |
| | | } |
| | | #region [从数据库加载菜单 APP] |
| | | |
| | | //public class AppMenuLoad { |
| | | //public class AppMenuLoad |
| | | //{ |
| | | // public string HitemID { get; set; } // 主键 |
| | | // public string HPartentID { get; set; } = "0"; // 父节点ID |
| | | // public string HEntryID { get; set; } // 菜单节点id |
| | |
| | | //} |
| | | //[Route("Web/MenuList_APP")] |
| | | //[HttpGet] |
| | | //public object MenuList_APP() |
| | | //public object MenuList_APP(string HMaker, string HType) |
| | | //{ |
| | | // return null; |
| | | // try { |
| | | // DataSet ds = oCN.RunProcReturn("exec h_p_Gy_MenuDefineSet_APP_Get" + |
| | | // "@HMaker = '" + HMaker + "'" + |
| | | // "@HType = '" + HType + "'" |
| | | // , "h_p_Gy_MenuDefineSet_APP_Get"); |
| | | |
| | | // if((bool)ds.Tables[0].Rows[0]["returntype"] == true) |
| | | // { |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = ds.Tables[0].Rows[0]["mesg"].ToString(); |
| | | // objJsonResult.data = ds.Tables[1]; |
| | | // return objJsonResult; |
| | | // } |
| | | // else |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = ds.Tables[0].Rows[0]["mesg"].ToString(); |
| | | // return objJsonResult; |
| | | // } |
| | | |
| | | // } |
| | | // catch(Exception e) |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = e.ToString(); |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | |
| | | //} |
| | | |
| | | //[Route("Web/SetMenuList_APP")] |
| | |
| | | // string MenuName = sArray[2].ToString(); |
| | | // string type = sArray[3].ToString(); |
| | | |
| | | // if(String.Equals(type, "APP", StringComparison.InvariantCultureIgnoreCase)) |
| | | // if (String.Equals(type, "APP", StringComparison.InvariantCultureIgnoreCase)) |
| | | // { |
| | | // oCN.BeginTran(); |
| | | // List<AppMenuLoad> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<AppMenuLoad>>(msg2); |
| | | // string sql2 = ""; |
| | | |
| | | // foreach (AppMenuLoad one in list) |
| | | // string sql1 = "delete from Gy_MenuDefineSet_APP where HMenuName = '" + MenuName + "' and HMaker = '" + user + "'"; |
| | | // oCN.RunProcReturn(sql1, "Gy_MenuDefineSet_APP"); |
| | | // list.ForEach(one => |
| | | // { |
| | | // StringBuilder sqlFragment = new StringBuilder(); |
| | | // sqlFragment.Append("insert into Gy_MenuDefineSet("); |
| | | // var oneType = one.GetType(); |
| | | // } |
| | | // string sql2 = "insert into Gy_MenuDefineSet_APP( HEntryID, HIndex, HName, HMenuName, HPicNum, HShowMode, HMaker)" + |
| | | // "Values('" + one.HEntryID + "','" + one.HIndex + "','" + one.HName + "','" + one.HName + |
| | | // "','" + MenuName + "','" + one.HPicNum + "','" + one.HShowMode + "','" + user + "')"; |
| | | // oCN.RunProcReturn(sql2, "Gy_MenuDefineSet_APP"); |
| | | // }); |
| | | |
| | | // oCN.Commit(); |
| | | |
| | | // return null; |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = "设置成功!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // else |
| | | // { |
| | |
| | | // } |
| | | |
| | | // } |
| | | // catch(Exception e) |
| | | // catch (Exception e) |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |