コード例 #1
0
        /// <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));
        }
コード例 #2
0
        /// <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));
        }