/// <summary> /// 获取退票列表 /// </summary> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <param name="model"></param> /// <returns></returns> public User GetUser(User model) { string wherestr = string.Empty; if (model.UserId != -1) { wherestr += " AND UserId = @0"; } string sql = string.Format(@"select * from [dbo].[User] WHERE 1 = 1 {0}", wherestr); return(CgtUserDB.GetInstance().SingleOrDefault <User>(sql, model.UserId)); }
/// <summary> /// 获取角色仓储 /// </summary> /// <returns></returns> public Role GetRole(int RoleId) { string wherestr = string.Empty; wherestr += " AND RoleId = @0"; string sql = string.Format( @"select * from [dbo].[Role] WHERE 1 = 1 {0}", wherestr); return(CgtUserDB.GetInstance().SingleOrDefault <Role>(sql, RoleId)); }