public UserInfo GetUserInfo(string userName, string password) { string sql = "select * from T_UserInfo where Name=@userName and Password=@password"; SqlParameter[] pars = { new SqlParameter("@userName", SqlDbType.VarChar, 50), new SqlParameter("password", SqlDbType.VarChar, 50) }; pars[0].Value = userName; pars[1].Value = password; DataTable dt = SqlHelper.GetTable(sql, CommandType.Text, pars); UserInfo userInfo = null; if (dt.Rows.Count > 0) { userInfo = new UserInfo(); LoadEntity(userInfo, dt.Rows[0]); } return userInfo; }
public void LoadEntity(UserInfo userInfo, DataRow dr) { userInfo.Id = Convert.ToInt32(dr["Id"]); userInfo.Name = dr["Name"].ToString();//dr["Name"]!=DBNull.Value ? dr["Name"].ToString():string.Empty userInfo.Password = dr["Password"].ToString(); }