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();
 }