//获取用户信息 public static User GetUserByAccount(string account) { User user = new User(); string sql = string.Format("SELECT [ID] FROM [WaterSupplySecurity].[dbo].[User] where [Account]='{0}'", account); user = DataAcccessHelper.QueryFirstOrDefault <User>(sql); return(user); }
//获取用户登录提交和得分情况 public static UserScoreModel GetUserScore(string userId) { UserScoreModel model = new UserScoreModel(); string sql = string.Format(@"SELECT [IsSubmit] ,[CreateTime] ,[Score] ,[UpdateTime] FROM[WaterSupplySecurity].[dbo].[UserScore] where UserID = {0}", userId); model = DataAcccessHelper.QueryFirstOrDefault <UserScoreModel>(sql); return(model); }