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