//获取用户信息
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);
}
