public static User Get(string username)
{
string sql = "select Id,UserName,Password,RealName,RoleType,Status,bugzillaid from Users where UserName=@UserName";
SqlParam p = new SqlParam();
p.AddParam("@UserName", username, SqlDbType.VarChar, 100);
DataTable dt = ProjectDB.GetDt(sql, p);
if (St.CheckDt(dt))
{
User o = new User();
o.Id = St.ToInt32(dt.Rows[0]["Id"], 0);
o.UserName = dt.Rows[0]["UserName"].ToString();
o.Password = dt.Rows[0]["Password"].ToString();
o.RealName = dt.Rows[0]["RealName"].ToString();
o.RoleType = St.ToInt32(dt.Rows[0]["RoleType"], 0);
o.Status = St.ToInt32(dt.Rows[0]["Status"], 0);
o.BugzillaId = St.ToInt32(dt.Rows[0]["bugzillaid"], 0);
return(o);
}
else
{
return(new User());
}
}
