public List <Models.ScreenGroupPermissionDo> GetUserPermission(Models.UserCriteriaDo criteria) { List <Models.ScreenGroupPermissionDo> result = new List <Models.ScreenGroupPermissionDo>(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_UserPermission]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "UserName", criteria.UserName); command.AddParameter(typeof(int), "GroupID", criteria.GroupID); List <Models.ScreenPermissionDo> permissions = command.ToList <Models.ScreenPermissionDo>(); foreach (Models.ScreenPermissionDo p in permissions) { if (Utils.CommonUtil.IsNullOrEmpty(p.GroupNameEN) && Utils.CommonUtil.IsNullOrEmpty(p.GroupNameLC)) { Models.ScreenGroupPermissionDo grp = new Models.ScreenGroupPermissionDo(); grp.Screens = new List <Models.ScreenPermissionDo>(); result.Add(grp); grp.Screens.Add(p); } else { Models.ScreenGroupPermissionDo grp = result.Find(x => x.GroupNameEN == p.GroupNameEN && x.GroupNameLC == p.GroupNameLC); if (grp == null) { grp = new Models.ScreenGroupPermissionDo(); grp.GroupNameEN = p.GroupNameEN; grp.GroupNameLC = p.GroupNameLC; grp.GroupImageIcon = p.GroupImageIcon; grp.Screens = new List <Models.ScreenPermissionDo>(); result.Add(grp); } grp.Screens.Add(p); } } })); return(result); }
public Models.UserFSResultDo GetUserList(Models.UserCriteriaDo criteria) { Models.UserFSResultDo result = new Models.UserFSResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_UserList]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "UserName", criteria.UserName); command.AddParameter(typeof(int), "GroupID", criteria.GroupID); command.AddParameter(typeof(bool), "FlagActive", criteria.FlagActive); command.AddParameter(typeof(bool), "IncludeSystemAdmin", criteria.IncludeSystemAdmin); Utils.SQL.ISQLDbParameter output = command.AddSearchParameter(criteria); result.Rows = command.ToList <Models.UserFSDo>(); result.TotalRecordParameter(output); })); return(result); }
public Models.UserDo GetUser(Models.UserCriteriaDo criteria) { Models.UserDo result = null; db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_User]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "UserName", criteria.UserName); List <Models.UserDo> list = command.ToList <Models.UserDo>(); if (list != null) { if (list.Count > 0) { result = list[0]; } } })); return(result); }