protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号
string Id = GridView1.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id
DALstudent_info dal = new DALstudent_info(); //定义针对admin_user表的操作对象
switch (e.CommandName) //获取操作对象的命令
{
case "edit": //调转到编辑页面
Response.Redirect("StudentEdit.aspx?id=" + Id);
break;
case "del": //删除用户
dal.Delstudent_info(int.Parse(Id));
LoadData(); //重新加载数据，验证是否成功删除
this.Page.RegisterStartupScript("", "<script>alert('该学生信息已删除！');</script>");
break;
case "reset": //修改密码
student_infoEntity admin = dal.Getstudent_info(int.Parse(Id));
admin.StudentPassword = "******";
dal.Modstudent_info(admin);
LoadData(); //重新加载数据，验证是否重置
this.Page.RegisterStartupScript("", "<script>alert('该学生的密码重置成功！');</script>");
break;
}
}
protected void grdusers_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowindex = int.Parse(e.CommandArgument.ToString()); //获取操作行的行号
string Id = grdusers.DataKeys[rowindex].Value.ToString(); //获取操作行数据的主键Id
DALstudent_info dal = new DALstudent_info(); //定义针对admin_user表的操作对象
switch (e.CommandName) //获取操作对象的命令
{
case "edit": //调转到编辑页面
Response.Redirect("?id=" + Id);
break;
case "del": //删除用户
dal.Delstudent_info(int.Parse(Id));
LoadData(); //重新加载数据，验证是否成功删除
Response.Write("<script>alert('数据删除成功！')</script>");
break;
case "reset": //修改密码
student_infoEntity u = dal.Getstudent_info(int.Parse(Id));
u.StudentPassword = "******";
dal.Modstudent_info(u);
LoadData(); //重新加载数据，验证是否重置
Response.Write("<script>alert('用户密码重置成功，新密码123456')</script>");
break;
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
DALstudent_info dal = new DALstudent_info(); //操作对象
student_infoEntity stu = (student_infoEntity)ViewState["stu"]; //获取缓存数据
stu.StudentName = txtStuName.Text;
if (fulStuPhoto.HasFile)
{
stu.StudentPhoto = imgUpLoad(fulStuPhoto);
}
if (rdlSexMale.Checked)
{
stu.StudentSex = "男";
}
if (rdlSexFemale.Checked)
{
stu.StudentSex = "女";
}
stu.StudentNation = txtStuNation.Text;
stu.StudentTelehpone = txtStuTelehpone.Text;
stu.StudentQQ = txtStuQQ.Text;
stu.StudentClass = txtStuClass.Text;
stu.StudentDormitory = txtStuDormitory.Text;
stu.StudentAddress = txtStuAddress.Text;
if (dal.Modstudent_info(stu) > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('信息修改成功！')</script>");
Response.Redirect("StudentInfo.aspx");
}
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
DALstudent_info dal = new DALstudent_info();
switch (e.CommandName) //获取操作对象的命令
{
case "edit": //调转到编辑页面
Response.Redirect("AdminEdit.aspx?id=" + Id);
break;
case "del": //删除用户
dal.Delstudent_info(int.Parse(Id));
LoadData(); //重新加载数据，验证是否成功删除
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('数据删除成功！');location.href='StudentFind.aspx';</script>");
break;
case "reset": //修改密码
student_infoEntity user = dal.Getstudent_info(int.Parse(Id));
user.StudentPassword = "******";
dal.Modstudent_info(user);
LoadData(); //重新加载数据，验证是否重置
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('用户密码重置成功，新密码123456');location.href='StudentFind.aspx';</script>");
break;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string pwd = Session["Pwd"].ToString();
int id = int.Parse(Session["id"].ToString());
DALstudent_info dal = new DALstudent_info();
student_infoEntity stu = dal.Getstudent_info(id);
if (pwd == txtjPwd.Text.Trim())
{
if (txtxPwd.Text.Trim() == txtrPwd.Text.Trim() && txtxPwd.Text.Trim() != "" && txtrPwd.Text.Trim() != "")
{
stu.StudentPassword = txtxPwd.Text.Trim();
if (dal.Modstudent_info(stu) > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('密码修改成功！')</script>");
Response.Redirect("NewsList.aspx");
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('密码修改失败！');</script>");
}
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('两次密码输入不一致！');</script>");
}
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('原密码不正确！');</script>");
}
}
/// <summary>
/// 获取数据并展示
/// </summary>
/// <param name="id"></param>
public void GetData(int id)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity stu = dal.Getstudent_info(id);
ViewState["stu"] = stu; //在当前页缓存数据。
lblStuID.Text = stu.StudentId;
txtStuName.Text = stu.StudentName; //加载显示数据
Image1.ImageUrl = "img/studentphone/" + stu.StudentPhoto;
txtStuNation.Text = stu.StudentNation;
if (stu.StudentSex == "男")
{
rdlSexMale.Checked = true;
}
if (stu.StudentSex == "女")
{
rdlSexFemale.Checked = true;
}
txtStuTelehpone.Text = stu.StudentTelehpone;
txtStuQQ.Text = stu.StudentQQ;
txtStuClass.Text = stu.StudentClass;
txtStuDormitory.Text = stu.StudentDormitory;
txtStuAddress.Text = stu.StudentAddress;
//将取回的数据在页面进行展示，可以修改的数据使用TextBox来展示，并提供修改。
//通过按钮触发，实现将数据编辑保存的功能
}
/// <summary>
/// 当行数据绑定的时候，进行必要的翻译处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//翻译课程
DALcourse dalc = new DALcourse();
courseEntity c = dalc.Getcourse(int.Parse(e.Row.Cells[1].Text));
if (c != null) //判断是否有值
{
e.Row.Cells[1].Text = c.CourseName; //有值才能使用
}
//else
//{
// Response.Write("<script>alert('kongde');</script>");
//}
//翻译学生
DALstudent_info dals = new DALstudent_info();
IList <student_infoEntity> ss = dals.Getstudent_infosbyCondition("studentId='" + e.Row.Cells[0].Text + "'");
if (ss.Count > 0)
{
e.Row.Cells[0].Text = ss[0].StudentId;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity stu = dal.Getstudent_info(int.Parse(Session["id"].ToString()));
lblName.Text = Session["studentName"].ToString();
Image1.ImageUrl = "./img/studentphone/" + stu.StudentPhoto;
}
public void GetData(int id)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity student = dal.Getstudent_info(id);
ViewState["student"] = student;
StudentId.Value = student.StudentId;
}
public void GetData(int id)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity student = dal.Getstudent_info(id);
ViewState["student"] = student;
select.Value = student.StudentId;
//将取回的数据在页面进行展示，可以修改的数据使用TextBox来展示，并提供修改。
//通过按钮触发，实现将数据编辑保存的功能
}
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 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>");
}
}
}
public void LoadData()
{
string conditon = string.Empty;
conditon = "(StudentId is not null and StudentId<>' ')";
if (!string.IsNullOrEmpty(Session["uName"].ToString()))
{
conditon += " and Id='" + Session["uName"].ToString() + "'";
}
DALstudent_info dal = new DALstudent_info();
IList <student_infoEntity> admins = dal.Getstudent_infosbyCondition(conditon);//按照条件来查询数据
grdusers.DataSource = admins;
grdusers.DataBind();
}
/// <summary>
/// 保存修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnedit_Click(object sender, EventArgs e)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity student = (student_infoEntity)ViewState["student"];//获取缓存
if (student.StudentPassword == Password1.Value)
{
student.StudentPassword = L_pass.Value; //修改数据
dal.Modstudent_info(student); //提交到数据库
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改成功！');</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改失败，请检查密码正确性！');</script>");
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity student = new student_infoEntity();
student.StudentAddress = jg.Value;
student.StudentClass = Class.Value;
student.StudentDormitory = ss.Value;
student.StudentId = StudentId.Value;
student.StudentName = truename.Value;
student.StudentNation = nation.Value;
student.StudentPassword = L_pass.Value;
student.StudentQQ = QQ.Value;
student.StudentSex = Sex.Value;
student.StudentTelehpone = TEL.Value;
dal.Addstudent_info(student);
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加成功');</script>");
}
protected void btnsubmit1_Click(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["CheckCode"];
string username = user_name.Value;
string password = pass_word.Value;
SQLDAL.DALstudent_info dALstudent_Info = new DALstudent_info();
IList <student_infoEntity> students = dALstudent_Info.Getstudent_infosbyCondition("studentId='" + username + "' and StudentPassword='******'");
if (students.Count > 0 && cookie.Value == CheckCode.Value)
{
Session["uName"] = students[0].Id;
Session["name"] = username;
ClientScript.RegisterStartupScript(GetType(), "", "<script>location.href='index_stu.aspx';</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('用户名或密码或验证码错误');</script>");
}
}
/// <summary>
/// 当行数据绑定的时候，进行必要的翻译处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//翻译课程编号->名称
DALcourse dalc = new DALcourse();
courseEntity c = dalc.Getcourse(int.Parse(e.Row.Cells[1].Text));
if (c != null)
{
e.Row.Cells[1].Text = c.CourseName;
}
//翻译学生编号->姓名
DALstudent_info dals = new DALstudent_info();
IList <student_infoEntity> ss = dals.Getstudent_infosbyCondition("Id='" + e.Row.Cells[0].Text + "'");
if (ss.Count > 0)
{
e.Row.Cells[0].Text = ss[0].StudentName;
}
}
}
/// <summary>
/// 加载数据信息
/// </summary>
public void LoadData()
{
string conditon = string.Empty;
conditon = "(StudentId is not null and StudentId<>' ' )";
if (!string.IsNullOrEmpty(student.Value))
{
if (bsearch.Text == "学号")
{
conditon += " and cast(StudentId as char) like'%" + student.Value + "%'";
}
else if (bsearch.Text == "姓名")
{
conditon += " and StudentName like'%" + student.Value + "%'";
}
}
DALstudent_info dal = new DALstudent_info();
IList <student_infoEntity> students = dal.Getstudent_infosbyCondition(conditon); //按照条件来查询数据
ViewState["data"] = students; //在当前页缓存加载的数据，减少后续访问时读写外存的次数。
GridView1.DataSource = students;
GridView1.DataBind();
}
/// <summary>
/// 导入Excel文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImport_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
int startPosition = FileUpload1.FileName.LastIndexOf("."); //获取后缀名的起始位置
string extName = FileUpload1.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;
FileUpload1.SaveAs(saveFile);//上传文件到指定位置
string str = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + saveFile + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
OleDbConnection oledbconn = new OleDbConnection(str);
//新建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();
DALstudent_info dal = new DALstudent_info();
foreach (DataRow dr in tb.Rows)
{
try
{
//取值
string sNo = dr["sNo"].ToString().Trim();
string pwd = dr["pwd"].ToString().Trim();
string name = dr["name"].ToString().Trim();
string photo = dr["photo"].ToString().Trim();
string sex = dr["sex"].ToString().Trim();
string nation = dr["nation"].ToString().Trim();
string tel = dr["tel"].ToString().Trim();
string sQQ = dr["sQQ"].ToString().Trim();
string sClass = dr["sClass"].ToString().Trim();
string dormitory = dr["dormitory"].ToString().Trim();
string address = dr["address"].ToString().Trim();
student_infoEntity student = new student_infoEntity();
//赋值
student.StudentId = sNo;
student.StudentPassword = pwd;
student.StudentName = name;
student.StudentPhoto = photo;
student.StudentSex = sex;
student.StudentNation = nation;
student.StudentTelehpone = tel;
student.StudentQQ = sQQ;
student.StudentClass = sClass;
student.StudentDormitory = dormitory;
student.StudentAddress = address;
dal.Addstudent_info(student);//添加
successNumber++;
}
catch (Exception Error)
{
resultsb.Append(dr["sNo"].ToString().Trim());
resultsb.Append("导入失败；原因：");
resultsb.Append(Error.Message);
resultsb.Append("\r\n");
failureNumber++;
}
}//endforeach
//this.Page.RegisterStartupScript("", "<script>alert('" + successNumber + " 条信息成功导入！\r\n" + failureNumber + " 条信息无法导入！\r\n');</script>");
Response.Redirect("StudentFind.aspx");
//ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + successNumber + " 条信息成功导入！\r\n" + failureNumber + " 条信息无法导入！\r\n');</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('选定的文件不是合法的Excel文件！');</script>");
}
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('没有选定的要导入的文件！');</script>");
}
}
