62,041
社区成员
发帖
与我相关
我的任务
分享
<connectionStrings>
<add name="connectionString"
connectionString="Data Source=.;Initial Catalog=WareHouse;User ID=sa;Password=000"
providerName="System.Data.SqlClient" />
</connectionStrings>
public SqlDataReader ExecuteReader(string query, params SqlParameter[] parameters)
{
cnn = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand(query, cnn);
if (query.StartsWith("SELECT") | query.StartsWith("select"))
{
cmd.CommandType = CommandType.Text;
}
else
{
cmd.CommandType = CommandType.StoredProcedure;
}
for (int i = 0; i <= parameters.Length - 1; i++)
{
cmd.Parameters.Add(parameters[i]);
}
SqlDataReader dr;
try
{
cnn.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception exp)
{
throw exp;
}
finally
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
}
return dr;
}
public UserInfo GetByUserName(string userName)
{
UserInfo item = null;
SqlHelper sqlHelper = new SqlHelper();
SqlParameter[] prams ={ new SqlParameter("@userName", SqlDbType.VarChar) };
prams[0].Value = userName;
string sqlStr = "select [User].userName,[User].passWord,[User].realName,[User].departmentId,Department.Dname,[User].phoneNumber,[User].email,[User].flag from [User] right join Department on [User].departmentId=Department.id where User.userName=@userName";
SqlDataReader rdr = sqlHelper.ExecuteReader(sqlStr, prams);
if (rdr.Read())
{
item = new UserInfo(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetInt32(4), rdr.GetString(5), rdr.GetInt32(6), rdr.GetString(7), rdr.GetString(8));
}
return item;
}