项目运行非常慢

NeverCooldowN 2009-04-24 06:01:27

这是我的一段登录提交代码，帮我看看，是哪里不好么，怎么发布到iis上后就非常之缓慢了？

//提交按钮
protected void btnSubmit_Click(object sender, EventArgs e)
{
string id = txtId.Text;
string password = txtPassword.Text;
if (id.Equals(""))
{
Response.Write("<script>alert('工牌号不能为空!');</script>");
return;
}
if (password.Equals(""))
{
Response.Write("<script>alert('密码不能为空!');</script>");
return;
}
User user = UserManager.GetUserById(id);
if (user==null)
{
Response.Write("<script>alert('工牌号不存在!');</script>");
return;
}
if (!user.Password.Equals(password))
{
Response.Write("<script>alert('密码错误!');</script>");
return;
}
Session["loginUser"] = user;
Response.Redirect("Index.aspx");
}

/// <summary>
/// 根据编号获取系统用户信息
/// </summary>
/// <param name="id">编号 </param>
/// <returns>系统用户信息 </returns>
public static User GetUserById(string id)
{
sqlQuery = "select * from [user] where State = 1 and Id='" + id + "'";
User user = null;
SqlDataReader reader = DBHelper.GetReader(sqlQuery);
try
{
if (reader.Read())
{
user = new User();
user.Id = reader["Id"].ToString();
user.Name = reader["Name"].ToString();
user.Password = reader["Password"].ToString();
user.Email = reader["Email"].ToString();
user.Post = PostService.GetPostById(Convert.ToInt32(reader["PostId"].ToString()));
user.BeginDate = Convert.ToDateTime(reader["BeginDate"].ToString());
user.Superior = reader["Superior"].ToString();
user.Level = Convert.ToInt32(reader["Level"].ToString());
user.Vacation = Convert.ToDouble(reader["Vacation"].ToString());
user.State = Convert.ToInt32(reader["State"].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (reader != null)
{
reader.Dispose();
}
}
return user;
}

private static SqlConnection connection;//数据库连接
private static string str = ConfigurationManager.ConnectionStrings["conMaster"].ConnectionString;
/// <summary>
/// 数据库连接
/// </summary>
public static SqlConnection Connection
{
get
{
string strcon = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
DBHelper.connection = null;
//string strcon = "server=allen-pc;uid=sa;pwd=;database=OADB";
if (connection == null)
{
connection = new SqlConnection(strcon);
connection.Open();
}
if (connection.State == ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
return DBHelper.connection;
}
}

/// <summary>
/// 执行查询,返回Reader对象
/// </summary>
/// <param name="sqlQuery"></param>
/// <param name="values"></param>
/// <returns></returns>
public static SqlDataReader GetReader(string sqlQuery, params SqlParameter[] values)
{
SqlDataReader dr = null;
try
{
SqlCommand command = new SqlCommand(sqlQuery, Connection);
command.Parameters.AddRange(values);
dr = command.ExecuteReader();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return dr;
}

...全文