protected void btnSave_Click(object sender, EventArgs e)
{
if (txtRole.Text.Trim() == "")
{
JScript.AjaxAlert(this.Page, "Please input role name!");
return;
}
if (string.IsNullOrEmpty(Request["rid"])) //Add
{
try
{
if (SQLHelper.ReturnInteger("select count(*) from tbl_role where role_na = '" + Common.FormatParameter(this.txtRole.Text) + "' ") > 0)
{
JScript.AjaxAlert(this.Page, "Role name has exist");
return;
}
SQLHelper.ExecuteNonQuery("insert into tbl_role(role_na) values('" + Common.FormatParameter(this.txtRole.Text) + "')");
//记录日志
Log.writeLog(Request.Cookies["user"].Values["id"], Request.Cookies["user"].Values["name"], "Add Role", "Add Role:" + this.txtRole.Text.Trim() + " by " + Request.Cookies["user"].Values["name"]);
}
catch (Exception ex)
{
JScript.AjaxAlert(this.Page, "Sorry,there is an error! Reasons:" + ex.Message.ToString());
}
}
else //Edit
{
if (SQLHelper.ReturnInteger("select count(*) from tbl_role where role_na = '" + Common.FormatParameter(this.txtRole.Text) + "' and id <> '" + this.hidID.Value + "' ") > 0)
{
JScript.AjaxAlert(this.Page, "Role name has exist");
return;
}
try
{
SQLHelper.ExecuteNonQuery("update tbl_role set role_na = '" + Common.FormatParameter(this.txtRole.Text) + "' where id = '" + hidID.Value + "' ");
}
catch (Exception ex)
{
JScript.AjaxAlert(this.Page, "Sorry,there is an error! Reasons:" + ex.Message.ToString());
}
}
Response.Redirect("RoleManagement.aspx");
}
protected void f_real()
{
//LDAP验证
string strPath = "LDAP://147.128.18.10";
DirectoryEntry de;
de = new DirectoryEntry(strPath, txtUserName.Text, txtPWD.Text.Trim(), AuthenticationTypes.None);
DirectorySearcher deSearch = new DirectorySearcher();
deSearch.SearchRoot = de;
//验证LDAP用户名和密码
if (VerifyUser(deSearch))
{
DataTable dtuser;
string sql = "select * from t_users where c_login='******'and c_system='" + du_tools.gcs_sytem + "'";
try
{
dtuser = SQLHelper.GetDataTable(sql);
if (dtuser.Rows.Count > 0)
{
Session["user_login"] = txtUserName.Text;
DeleteOverdueFile();
Response.Redirect("default.aspx");
}
else
{
JScript.AjaxAlert(this.Page, "User Not Exits!");
return;
}
}
catch (Exception ex)
{
JScript.AjaxAlert(this.Page, "There is something wrong" + ex.Message.Replace("\\", "/").Replace("\'", " "));
return;
}
}
else
{
JScript.AjaxAlert(this.Page, "LDAP failed！");
}
}
/// <summary>
/// 登陆按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbtLogin_Click(object sender, ImageClickEventArgs e)
{
// DataTable dt_login = SQLHelper.GetDataTable("select id,usr_login,usr_pwd,role_id from tbl_usr where usr_login = '******' and usr_pwd = '" + Common.FormatParameter(this.txtPWD.Text.Trim()) + "'");//Common.WebEncrypt(this.txtPWD.Text.Trim()) + "'");
try
{
DataTable dt_login = SQLHelper.GetDataTable("select * from student where ID = '" + Common.FormatParameter(this.txtUserName.Text.Trim()) + "' and stuID = '" + Common.FormatParameter(this.txtPWD.Text.Trim()) + "'"); //Common.WebEncrypt(this.txtPWD.Text.Trim()) + "'");
HttpCookie StuInfo = new HttpCookie("StuInfo"); // Cookie
StuInfo["ID"] = dt_login.Rows[0]["ID"].ToString();
StuInfo["stuID"] = dt_login.Rows[0]["stuID"].ToString();
StuInfo["stuName"] = dt_login.Rows[0]["stuName"].ToString();
StuInfo["className"] = dt_login.Rows[0]["className"].ToString();
StuInfo["stuGrade"] = dt_login.Rows[0]["stuGrade"].ToString();
Response.Cookies.Add(StuInfo);
//获取Output和UploadFiles文件夹下一天前的临时文件
//DeleteFile.DeleteOverdueFile(Server.MapPath("~/Output"));
//DeleteFile.DeleteOverdueFile(Server.MapPath("~/UploadFiles"));
Response.Redirect("学生用/Notice.aspx");
}
catch (Exception ex)
{
JScript.AjaxAlert(this.Page, "User name or password wrong!");
}
//int index = this.txtUserName.Text.Trim().IndexOf('\\');
//if (index < 0)
//{
// this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('The username does not exist!')</script>");
// return;
//}
////获取"\"后面的真实的用户名
//string RealName = this.txtUserName.Text.Remove(0, index + 1);
////LDAP验证
//string strPath = "LDAP://147.128.18.10";
//DirectoryEntry de = new DirectoryEntry(strPath, this.txtUserName.Text.Trim(), this.txtPWD.Text.Trim(), AuthenticationTypes.None);
//DirectorySearcher deSearch = new DirectorySearcher();
//deSearch.SearchRoot = de;
////验证LDAP用户名和密码
//if (VerifyUser(deSearch))
//{
// DataTable dt_login = SQLHelper.GetDataTable("select id,usr_login,usr_pwd,role_id from tbl_usr where usr_login = '******'");//Common.WebEncrypt(this.txtPWD.Text.Trim()) + "'");
// if (dt_login.Rows.Count > 0)
// {
// HttpCookie user = new HttpCookie("user"); // Cookie
// user["id"] = dt_login.Rows[0]["id"].ToString();
// user["name"] = Server.UrlEncode(dt_login.Rows[0]["usr_login"].ToString()).Replace("+", " ");
// user["roleid"] = dt_login.Rows[0]["role_id"].ToString();
// Response.Cookies.Add(user);
// //获取Output文件夹下一天前的临时文件
// DeleteFile.DeleteOverdueFile(Server.MapPath("~/Output"));
// DeleteFile.DeleteOverdueFile(Server.MapPath("~/UploadFiles"));
// Response.Redirect("index.aspx");
// }
// else
// {
// JScript.AjaxAlert(this.Page, "The username does not exist!");
// return;
// }
//}
//else
//{
// this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('LDAP Authentication failure!')</script>");
// return;
//}
}