protected void btnSubmit_Click(object sender, EventArgs e) { string pwd = Session["Pwd"].ToString(); int id = int.Parse(Session["id"].ToString()); DALadmin_user dal = new DALadmin_user(); admin_userEntity admin = dal.Getadmin_user(id); if (pwd == txtjPwd.Text.Trim()) { if (txtxPwd.Text.Trim() == txtrPwd.Text.Trim() && txtxPwd.Text.Trim() != "" && txtrPwd.Text.Trim() != "") { admin.UserPassword = txtxPwd.Text.Trim(); if (dal.Modadmin_user(admin) > 0) { this.Page.RegisterStartupScript("", "<script>alert('密码修改成功!')</script>"); Response.Redirect("NewsManage.aspx"); } else { this.Page.RegisterStartupScript("", "<script>alert('密码修改失败!');</script>"); } } else { this.Page.RegisterStartupScript("", "<script>alert('两次密码输入不一致!');</script>"); } } else { this.Page.RegisterStartupScript("", "<script>alert('原密码不正确!');</script>"); } }
protected void grdadmin_RowCommand(object sender, GridViewCommandEventArgs e) { int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号 string Id = grdadmin.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 switch (e.CommandName) //获取操作对象的命令 { case "edit": //调转到编辑页面 Response.Redirect("AdminEdit.aspx?id=" + Id); break; case "del": //删除用户 dal.Deladmin_user(int.Parse(Id)); LoadData(); //重新加载数据,验证是否成功删除 ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('数据删除成功!');location.href='AdminList.aspx';</script>"); break; case "reset": //修改密码 admin_userEntity admin = dal.Getadmin_user(int.Parse(Id)); admin.UserPassword = "******"; dal.Modadmin_user(admin); LoadData(); //重新加载数据,验证是否重置 ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('用户密码重置成功,新密码123456');location.href='AdminList.aspx';</script>"); break; } }
protected void grdadmin_RowCommand(object sender, GridViewCommandEventArgs e) { int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号 string Id = grdadmin.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 switch (e.CommandName) //获取操作对象的命令 { case "edit": //调转到编辑页面 //Response.Redirect("StudentAdd.aspx?id=" + Id); break; case "del": //删除用户 dal.Deladmin_user(int.Parse(Id)); LoadData(); //重新加载数据,验证是否成功删除 ///Response.Write("<script>alert('数据删除成功!')</script>"); break; case "reset": //修改密码 admin_userEntity admin = dal.Getadmin_user(int.Parse(Id)); admin.UserPassword = "******"; dal.Modadmin_user(admin); LoadData(); //重新加载数据,验证是否重置 //Response.Write("<script>alert('用户密码重置成功,新密码123456')</script>"); break; } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 string Id = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取操作行数据的主键Id dal.Deladmin_user(int.Parse(Id)); LoadData();//重新加载数据,验证是否成功删除 }
public void GetData(int id) { DALadmin_user dal = new DALadmin_user(); admin_userEntity users = dal.Getadmin_user(id); ViewState["user"] = users; UserId.Value = users.UserName; //将取回的数据在页面进行展示,可以修改的数据使用TextBox来展示,并提供修改。 //通过按钮触发,实现将数据编辑保存的功能 }
protected void Submit_Click(object sender, EventArgs e) { string name = login_username.Value; string pwd = login_password.Value; if (rbtnType.SelectedIndex == 0) { DALadmin_user dal = new DALadmin_user(); IList <admin_userEntity> admins = dal.Getadmin_usersbyCondition(" userName='******' and userPassword='******'"); if (admins.Count > 0) { string trueName = admins[0].TrueName.ToString(); int id = admins[0].Id; //修改登录次数 admin_userEntity admin = dal.Getadmin_user(id); admin.LoginTimes++; dal.Modadmin_user(admin); Session["adminID"] = name; Session["TrueName"] = trueName; Session["Pwd"] = pwd; Session["id"] = id; Response.Redirect("NewsManage.aspx"); } else { this.Page.RegisterStartupScript("", "<script>alert('登录失败!');</script>"); } } else if (rbtnType.SelectedIndex == 1) { DALstudent_info dal = new DALstudent_info(); IList <student_infoEntity> stus = dal.Getstudent_infosbyCondition(" studentId='" + name + "' and studentPassword='******'"); if (stus.Count > 0) { int id = stus[0].Id; string phone = stus[0].StudentPhoto; string trueName = stus[0].StudentName.ToString(); Session["studentID"] = name; Session["StudentName"] = trueName; Session["id"] = id; Session["Pwd"] = pwd; //Session["phone"] = phone; Response.Redirect("NewsList.aspx"); } else { this.Page.RegisterStartupScript("", "<script>alert('登录失败!');</script>"); } } }
protected void btnsave_Click(object sender, EventArgs e) { DALadmin_user dal = new DALadmin_user(); admin_userEntity admin = new admin_userEntity(); admin.UserName = username.Value; admin.UserPassword = L_pass.Value; admin.LoginTimes = 1; admin.LinkTelephone = phone.Value; dal.Addadmin_user(admin); ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加成功');location.href='AdminAdd.aspx';</script>"); }
protected void btnLogin_Click(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["CheckCode"]; string uname = uName.Value; string pwd = uPassword.Value; Session["uName"] = uname; if (style.SelectedItem.Text == "管理员") { DALadmin_user dal = new DALadmin_user();//定义一个admin_user表的对象 IList <admin_userEntity> users = dal.Getadmin_usersbyCondition("userName='******'and userPassword='******'"); if (users.Count > 0)//查找表中是否有相关的记录 { if (cookie.Value == vcode.Value) { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('登陆成功!');location.href='index.aspx';</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('验证码错误!');</script>"); } } else { this.Page.RegisterStartupScript("", "<script>alert('登陆失败!');</script>"); } } else if (style.SelectedItem.Text == "学生") { DALstudent_info dal = new DALstudent_info(); IList <student_infoEntity> users = dal.Getstudent_infosbyCondition("StudentId='" + uname + "'and studentPassword='******'"); if (users.Count > 0)//查找表中是否有相关的记录 { if (cookie.Value == vcode.Value) { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('登陆成功!');location.href='student.aspx';</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('验证码错误!');</script>"); } } else { this.Page.RegisterStartupScript("", "<script>alert('登陆失败!');</script>"); } } else { this.Page.RegisterStartupScript("", "<script>alert('请先选择用户类型!');</script>"); } }
protected void grdusers_RowCommand(object sender, GridViewCommandEventArgs e) { int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号 string Id = grdusers.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 switch (e.CommandName) //获取操作对象的命令 { case "edit": //调转到编辑页面 Response.Redirect("PasswordMod.aspx?id=" + Id); break; } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 string Id = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取操作行数据的主键Id admin_userEntity admin = dal.Getadmin_user(int.Parse(Id)); admin.UserName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim(); admin.TrueName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); admin.LinkTelephone = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(); dal.Modadmin_user(admin); GridView1.EditIndex = -1; LoadData();//重新加载数据,验证是否重置 }
/// <summary> /// 加载数据信息 /// </summary> public void LoadData() { string conditon = string.Empty; conditon = "(UserName is not null and UserName<>' ')"; if (!string.IsNullOrEmpty(select.Value)) { conditon += " and UserName='******'"; } DALadmin_user dal = new DALadmin_user(); IList <admin_userEntity> admins = dal.Getadmin_usersbyCondition(conditon);//按照条件来查询数据 grdadmin.DataSource = admins; grdadmin.DataBind(); }
/// <summary> /// 加载数据信息 /// </summary> public void LoadData() { string conditon = string.Empty; conditon = "(UserName is not null and UserName<>' ')"; if (!string.IsNullOrEmpty(user_name.Value)) { conditon += " and UserName like'%" + user_name.Value + "%'"; } DALadmin_user dal = new DALadmin_user(); IList <admin_userEntity> admins = dal.Getadmin_usersbyCondition(conditon);//按照条件来查询数据 GridView1.DataSource = admins; GridView1.DataBind(); }
/// <summary> ///行内命令被触发的时候执行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号 string Id = GridView1.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id DALadmin_user dal = new DALadmin_user(); //定义针对admin_user表的操作对象 if (e.CommandName == "reset") { admin_userEntity admin = dal.Getadmin_user(int.Parse(Id)); admin.UserPassword = "******"; dal.Modadmin_user(admin); LoadData();//重新加载数据,验证是否重置 this.Page.RegisterStartupScript("a", "<script>alert('用户密码重置成功');</script>"); } }
//public void LoadData() //{ // string bian = Session["uName"].ToString(); // string conditon = string.Empty; // if (!string.IsNullOrEmpty(bian)) // { // conditon += "UserName='******'"; // } // DALadmin_user dal = new DALadmin_user(); // IList<admin_userEntity> ad = dal.Getadmin_usersbyCondition(conditon); // if (ad.Count != 0) // { //判断是否为空 // for (int i = 0; i < ad.Count(); i++) // { //for循环将数据逐一获取到 // admin_userEntity defCodeInfoResDto = ad[i]; // } // int j = ad[1].Id; // admin_userEntity admin = dal.Getadmin_user(j); // ViewState["admin"] = admin;//在当前页缓存数据。 // UserId.Value = admin.UserName;//加载显示数据 // //Password1.Value = admin.UserPassword; // } //} protected void btnedit_Click(object sender, EventArgs e) { DALadmin_user dal = new DALadmin_user(); admin_userEntity admin = (admin_userEntity)ViewState["user"];//获取缓存数据 if (admin.UserPassword == Password1.Value) { admin.UserPassword = L_repass.Value; dal.Modadmin_user(admin);//提交到数据库 ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改成功!');</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改失败,请检查密码正确性!');</script>"); } }
protected void btnsubmit_Click(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["CheckCode"]; string username = user_name.Value; string password = pass_word.Value; SQLDAL.DALadmin_user dALadmin_User = new DALadmin_user(); IList <admin_userEntity> users = dALadmin_User.Getadmin_usersbyCondition("userName='******' and userPassword='******'"); if (users.Count > 0 && cookie.Value == CheckCode.Value) { Session["uName"] = users[0].Id; Session["name"] = username; ClientScript.RegisterStartupScript(GetType(), "", "<script>location.href='index.aspx';</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('用户名或密码或验证码错误');</script>"); } }
protected void btnin_Click(object sender, EventArgs e) { if (Filadmin.HasFile) { int startPosition = Filadmin.FileName.LastIndexOf("."); //获取后缀名的起始位置 string extName = Filadmin.FileName.Substring(startPosition).ToLower(); //获取后缀名 if (startPosition >= 0) { if (extName.Equals(".xlsx") || extName.Equals(".xls")) { string path = Server.MapPath("./File/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string saveFile = path + DateTime.Now.ToString("yyyyMMddHHmmss") + extName; Filadmin.SaveAs(saveFile);//上传文件到指定位置 OleDbConnection oledbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + saveFile + ";Persist Security Info=False;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"); //新建ole命令对象 oledbconn.Open(); ///因为需要在运行的过程中,增加数据列,并对数据进行修正。 ///所以,需要首先读入数据进入内存datatable中然后进行操作。 OleDbCommand commandSourceData = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbconn); OleDbDataAdapter oleda = new OleDbDataAdapter(); oleda.SelectCommand = commandSourceData; DataTable tb = new DataTable(); oleda.Fill(tb); oledbconn.Close(); //数据规整部分。 int successNumber = 0; int failureNumber = 0; //数据处理 StringBuilder resultsb = new StringBuilder(); DALadmin_user dal = new DALadmin_user(); foreach (DataRow dr in tb.Rows) { try { //取值 string yh = dr["yh"].ToString().Trim(); string mm = dr["mm"].ToString().Trim(); string xm = dr["xm"].ToString().Trim(); string cs = dr["cs"].ToString().Trim(); string dh = dr["dh"].ToString().Trim(); admin_userEntity admin = new admin_userEntity(); //赋值 admin.LinkTelephone = dh; admin.LoginTimes = int.Parse(cs); admin.TrueName = xm; admin.UserName = yh; admin.UserPassword = mm; dal.Addadmin_user(admin);//添加 successNumber++; } catch (Exception Error) { resultsb.Append(dr["xh"].ToString().Trim()); resultsb.Append("导入失败;原因:"); resultsb.Append(Error.Message); resultsb.Append("\r\n"); failureNumber++; } }//endforeach resultsb.Insert(0, successNumber + " 条信息成功导入!\r\n" + failureNumber + "条信息无法导入!\r\n"); lb1.Text = "<div class=\"valid_box\">" + resultsb.ToString() + "</div>"; } else { lb1.Text = "<font color='red'>选定的文件不是合法的Excel文件!</font>"; } } } else { lb1.Text = "<font color='red'>没有选定要导入的文件!</font>"; } }