//复权 public Dictionary <string, object> CreateModuleOperate() { var context = (HttpContextBase)Request.Properties["MS_HttpContext"]; var request = context.Request; string operate = request.Form["operate"]; string roleid = request.Form["roleid"]; OpeateModuleView model = operate.JsonToEntity <OpeateModuleView>(); IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { StringBuilder sbModuleOperateRole = new StringBuilder("delete ModuleOperateRole where RoleId=@RoleId"); SqlParameter[] par = { new SqlParameter("@RoleId", SqlDbType.Int) }; par[0].Value = int.Parse(roleid); int newid = database.ExecuteBySql(sbModuleOperateRole, par, isOpenTrans); StringBuilder sbModuleRole = new StringBuilder("delete ModuleRole where RoleId=@RoleId"); int newid1 = database.ExecuteBySql(sbModuleRole, par, isOpenTrans); foreach (var item in model.ModuleList) { if (item.ischecked) { ModuleRole moduleRole = new ModuleRole(); moduleRole.RoleId = int.Parse(roleid); moduleRole.ModuleId = item.ModuleId; database.Insert(moduleRole, isOpenTrans); foreach (var item1 in item.List) { if (item1.IsCheck) { ModuleOperateRole moduleOperateRole = new ModuleOperateRole(); moduleOperateRole.RoleId = int.Parse(roleid); moduleOperateRole.ModuleOperateId = item1.OperateId; database.Insert(moduleOperateRole, isOpenTrans); } } } } database.Commit(); return(new Dictionary <string, object> { { "code", "1" } }); } catch (Exception) { database.Rollback(); return(new Dictionary <string, object> { { "code", "0" } }); } }
public Dictionary <string, object> GetAllOperate() { IDatabase database = DataFactory.Database(); var context = (HttpContextBase)Request.Properties["MS_HttpContext"]; var request = context.Request; string roleid = request.Form["roleid"]; ModuleBll ModuleBll = new ModuleBll(); ModuleOperateBll ModuleOperateBll = new ModuleOperateBll(); List <Module> listmodel = ModuleBll.GetModuleList(); List <ModuleOperate> moduleoperate = ModuleOperateBll.GetList(); Dictionary <string, object> dic = new Dictionary <string, object>(); OpeateModuleView model = new OpeateModuleView(); List <ModuleView> listModuleView = new List <ModuleView>(); List <ModuleRole> listmodulerole = database.FindList <ModuleRole>(" and RoleId=" + roleid); List <ModuleOperateRole> listmoduleoperaterole = database.FindList <ModuleOperateRole>(" and RoleId = " + roleid); foreach (var item in listmodel) { ModuleView ModuleView = new ModuleView(); ModuleView.ModuleId = item.ModuleId; ModuleView.ModuleName = item.ModuleName; ModuleView.ParentId = item.ParentId; int flag = 0; if (listmodulerole.Where(a => a.ModuleId == item.ModuleId).ToList().Count > 0) { flag = 1; ModuleView.ischecked = true; } else { ModuleView.ischecked = false; } ModuleView.id = item.ModuleId; List <ModuleOperateView> listModuleOperateView = new List <ModuleOperateView>(); foreach (var item1 in moduleoperate) { ModuleOperateView moduleOperateView = new ModuleOperateView(); if (item.ModuleId == item1.ModuleId) { if (flag == 0) { moduleOperateView.IsCheck = false; } else { if (listmoduleoperaterole.Where(a => a.ModuleOperateId == item1.ModuleOperateId).ToList().Count > 0) { moduleOperateView.IsCheck = true; } else { moduleOperateView.IsCheck = false; } } moduleOperateView.OperateId = item1.ModuleOperateId; moduleOperateView.OperateName = item1.ModuleOperateName; listModuleOperateView.Add(moduleOperateView); } } ModuleView.List = listModuleOperateView; listModuleView.Add(ModuleView); } model.ModuleList = listModuleView; dic.Add("module", model); return(dic); }