110,571
社区成员
发帖
与我相关
我的任务
分享
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
//查询输入的用户及密码是否符合身份验证
string sSql = "select Role,Class,Name from Users where LoginId='" + username.Text + "' and PassWord='" + password.Text + "'";
SQL s = new SQL();
DataSet ds = s.DSSearch(sSql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
if (dr["Role"].ToString() != DropDownList1.Text)
{
Page.RegisterStartupScript("alert", "<script>alert('权限选择错误!');</script>");
return;
}
//这部分是导致程序异常的代码
[color=#FFFF00] string sSql1 = "select lendtime, returntime from BookLend where lenduser=='" + username.Text + "'";
SQL s1 = new SQL ();
DataSet ds1 =s1.DSSearch (sSql1 );
DataRow dr2 = ds1.Tables[0].Rows[0];
TimeSpan ts=Convert.ToDateTime(dr2["returntime"].ToString()).Subtract(Convert.ToDateTime(dr2["lendtime"].ToString()));
int num = ts.Days;
if (num > 20)
{
Page.RegisterStartupScript("alert", "<script>alert('您有超期未归还的图书!');</script>");
return;
}
Session["Users"] = username.Text;
Session["Role"] = dr["Role"].ToString();
Session["Name"] = dr["Name"].ToString();
Response.Redirect("Main.aspx");
}
else
{
Page.RegisterStartupScript("alert", "<script>alert('密码错误!');</script>");
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
//清空数据
username.Text = "";
password.Text = "";
}
}
public static void test()
{
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(int));
dt.Columns.Add("title", typeof(string));
Console.WriteLine(dt.Rows[0]);
}
DataSet ds1 =s1.DSSearch (sSql1 );
DataRow dr2 = ds1.Tables[0].Rows[0];
[color=#FFFF00] <strong>string sSql1 = "select lendtime, returntime from BookLend where lenduser=='" + username.Text + "'";