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; //} }