/// <summary>
/// 添加
///</summary>
public static int AddSudents(Sudents SudentsModel)
{
string sql = string.Format("insert into Sudents (SutCode,SutName,ClassId,Native,Born,[National],Political,Sex,Grade,Contact,Note,Pwd )values(@SutCode,@SutName,@ClassId,@Native,@Born,@National,@Political,@Sex,@Grade,@Contact,@Note,@Pwd)");
SqlParameter[] para =
{
new SqlParameter("@SutCode", SqlDbType.NVarChar),
new SqlParameter("@SutName", SqlDbType.NVarChar),
new SqlParameter("@ClassId", SqlDbType.Int),
new SqlParameter("@Native", SqlDbType.NVarChar),
new SqlParameter("@Born", SqlDbType.DateTime),
new SqlParameter("@National", SqlDbType.NVarChar),
new SqlParameter("@Political", SqlDbType.NVarChar),
new SqlParameter("@Sex", SqlDbType.NVarChar),
new SqlParameter("@Grade", SqlDbType.Int),
new SqlParameter("@Contact", SqlDbType.NVarChar),
new SqlParameter("@Note", SqlDbType.NText),
new SqlParameter("@Pwd", SqlDbType.NVarChar)
};
para[0].Value = SudentsModel.SutCode;
para[1].Value = SudentsModel.SutName;
para[2].Value = SudentsModel.ClassId;
para[3].Value = SudentsModel.Native;
para[4].Value = SudentsModel.Born;
para[5].Value = SudentsModel.National;
para[6].Value = SudentsModel.Political;
para[7].Value = SudentsModel.Sex;
para[8].Value = SudentsModel.Grade;
para[9].Value = SudentsModel.Contact;
para[10].Value = SudentsModel.Note;
para[11].Value = SudentsModel.Pwd;
return(DBHelper.ExecuteCommand(sql, para));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindsTypes();
if (Request.QueryString["uid"] != null)
{
Sudents model = SudentsBLL.GetIdBySudents(Convert.ToInt32(Request.QueryString["uid"]));
ddlGrade.SelectedValue = model.Grade.ToString();
ddlMajorId.SelectedValue = ClassBLL.GetIdByClass(model.ClassId).MajorId.ToString();
ddlClassId.DataSource = ClassBLL.AllData(" and MajorId =" + ddlMajorId.SelectedValue, "ClassId", "asc");
ddlClassId.DataTextField = "ClassName";
ddlClassId.DataValueField = "ClassId";
ddlClassId.DataBind();
ddlClassId.SelectedValue = model.ClassId.ToString();
ddlNational.SelectedValue = model.National.Trim();
ddlPolitical.SelectedValue = model.Political.Trim();
txtBorn.Value = model.Born.ToString("yyyy-MM-dd") != "1900-01-01" ? model.Born.ToString("yyyy-MM-dd") : "";
txtContact.Value = model.Contact.Trim();
txtNative.Value = model.Native.Trim();
txtNote.Value = model.Note.Trim();
txtPwd.Value = model.Pwd.Trim();
txtSutCode.Value = model.SutCode.Trim();
txtSutName.Value = model.SutName.Trim();
ddlSex.SelectedValue = model.Sex.Trim();
btnAdd.Text = "修改";
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Sudents sud = SudentsBLL.GetIdBySudents(sudents.SutId);
sud.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
sud.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
sud.Contact = txtContact.Value.Trim();
sud.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
sud.National = ddlNational.SelectedValue.Trim();
sud.Native = txtNative.Value.Trim();
sud.Note = txtNote.Value.Trim();
sud.Political = ddlPolitical.SelectedValue.Trim();
sud.Pwd = lblPwd.Text.Trim();
sud.Sex = ddlSex.SelectedValue.Trim();
sud.SutCode = lblSutCode.Text.Trim();
sud.SutName = txtSutName.Value.Trim();
if (SudentsBLL.UpdateSudents(sud) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.replace('PersonalSudents.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
return;
}
}
/// <summary>
/// 验证用户是否能登录成功
/// </summary>
/// <param name="UserName"></param>
/// <param name="Pwd"></param>
/// <param name="users"></param>
/// <returns></returns>
public static bool GetUsersLogin(string SutCode, string Pwd, out Sudents sudents)
{
sudents = SudentsDAL.GetIdBySutCode(SutCode);
if (sudents != null && sudents.Pwd == Pwd)
{
return(true);
}
return(false);
}
//添加验证是否存在
public static bool IsTrue(string SutCode)
{
Sudents sud = SudentsDAL.GetIdBySutCode(SutCode);
if (sud != null && sud.SutId != 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 根据主键查询实体
///</summary>
public static Sudents GetIdBySudents(int Id)
{
string sql = string.Format("SELECT * FROM Sudents where SutId={0} ", Id);
Sudents SudentsModel = new Sudents();
using (DataTable table = DBHelper.GetDataSet(sql))
{
SudentsModel = GetMode(table);
}
return(SudentsModel);
}
/// <summary>
/// 根据学号查询实体
///</summary>
public static Sudents GetIdBySutCode(string SutCode)
{
string sql = string.Format("SELECT * FROM Sudents where SutCode collate Chinese_PRC_CS_AS_WS = '{0}'", SutCode);
Sudents SudentsModel = new Sudents();
using (DataTable table = DBHelper.GetDataSet(sql))
{
SudentsModel = GetMode(table);
}
return(SudentsModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Sudents"] != null)
{
sudents = (Sudents)Session["Sudents"];
}
else
{
Response.Write("<script>parent.window.location.href='Login.aspx'</script>");
}
}
protected void imgbLogin_Click(object sender, ImageClickEventArgs e)
{
//判断是学生、教师、还是老师登录
if (ddlType.SelectedValue == "学生") //学生登录
{
Sudents sudents = new Sudents(); //验证该学生登录信息是否与数据库中一致
if (SudentsBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out sudents))
{ //学生登录信息正确，将该学生添加到session并跳转到学生主页
Session["Sudents"] = sudents;
Response.Redirect("SudentsMain.aspx", false);
}
else
{ //学生登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
else if (ddlType.SelectedValue == "教师") //教师登录
{
Teacher teacher = new Teacher(); //验证该教师登录信息是否与数据库中一致
if (TeacherBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out teacher))
{ //教师登录信息正确，将该教师添加到session中并跳转到教师主页
Session["Teacher"] = teacher;
Response.Redirect("TeacherMain.aspx", false);
}
else
{ //教师登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
else if (ddlType.SelectedValue == "管理员") //管理员登录
{
Admin admin = new Admin(); //验证该管理员信息是否与数据库中一致
if (AdminBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out admin))
{ //管理员登录信息正确，将该管理员添加到session中并跳转到管理员主页
Session["Admin"] = admin;
Response.Redirect("AdminMain.aspx", false);
}
else
{ //管理员登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
}
/// <summary>
/// 私有方法
///</summary>
private static Sudents GetMode(DataTable table)
{
Sudents SudentsModel = new Sudents();
foreach (DataRow row in table.Rows)
{
SudentsModel.SutId = Convert.ToInt32(row["SutId"]);
SudentsModel.SutCode = Convert.ToString(row["SutCode"]);
SudentsModel.SutName = Convert.ToString(row["SutName"]);
SudentsModel.ClassId = Convert.ToInt32(row["ClassId"]);
SudentsModel.Native = Convert.ToString(row["Native"]);
SudentsModel.Born = Convert.ToDateTime(row["Born"]);
SudentsModel.National = Convert.ToString(row["National"]);
SudentsModel.Political = Convert.ToString(row["Political"]);
SudentsModel.Sex = Convert.ToString(row["Sex"]);
SudentsModel.Grade = Convert.ToInt32(row["Grade"]);
SudentsModel.Contact = Convert.ToString(row["Contact"]);
SudentsModel.Note = Convert.ToString(row["Note"]);
SudentsModel.Pwd = Convert.ToString(row["Pwd"]);
}
return(SudentsModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Sudents"] != null)
{
sudents = (Sudents)Session["Sudents"];
}
else
{
Response.Write("<script>parent.window.location.href='Login.aspx'</script>");
}
if (!IsPostBack)
{
BindsTypes();
Sudents sud = SudentsBLL.GetIdBySudents(sudents.SutId);
ddlGrade.SelectedValue = sud.Grade.ToString();
ddlMajorId.SelectedValue = ClassBLL.GetIdByClass(sud.ClassId).MajorId.ToString();
ddlClassId.DataSource = ClassBLL.AllData(" and MajorId =" + ddlMajorId.SelectedValue, "ClassId", "asc");
ddlClassId.DataTextField = "ClassName";
ddlClassId.DataValueField = "ClassId";
ddlClassId.DataBind();
ddlClassId.SelectedValue = sud.ClassId.ToString();
ddlNational.SelectedValue = sud.National.Trim();
ddlPolitical.SelectedValue = sud.Political.Trim();
txtBorn.Value = sud.Born.ToString("yyyy-MM-dd") != "1900-01-01" ? sud.Born.ToString("yyyy-MM-dd") : "";
txtContact.Value = sud.Contact.Trim();
txtNative.Value = sud.Native.Trim();
txtNote.Value = sud.Note.Trim();
lblSutCode.Text = sud.SutCode.Trim();
txtSutName.Value = sud.SutName.Trim();
ddlSex.SelectedValue = sud.Sex.Trim();
lblPwd.Text = sud.Pwd.Trim();
}
}
/// <summary>
/// 根据ID修改
///</summary>
public static int UpdateSudents(Sudents SudentsModel)
{
string sql = string.Format("UPDATE Sudents set SutCode=@SutCode,SutName=@SutName,ClassId=@ClassId,Native=@Native,Born=@Born,[National]=@National,Political=@Political,Sex=@Sex,Grade=@Grade,Contact=@Contact,Note=@Note,Pwd=@Pwd where SutId=@SutId");
SqlParameter[] para =
{
new SqlParameter("@SutCode", SqlDbType.NVarChar),
new SqlParameter("@SutName", SqlDbType.NVarChar),
new SqlParameter("@ClassId", SqlDbType.Int),
new SqlParameter("@Native", SqlDbType.NVarChar),
new SqlParameter("@Born", SqlDbType.DateTime),
new SqlParameter("@National", SqlDbType.NVarChar),
new SqlParameter("@Political", SqlDbType.NVarChar),
new SqlParameter("@Sex", SqlDbType.NVarChar),
new SqlParameter("@Grade", SqlDbType.Int),
new SqlParameter("@Contact", SqlDbType.NVarChar),
new SqlParameter("@Note", SqlDbType.NText),
new SqlParameter("@Pwd", SqlDbType.NVarChar),
new SqlParameter("@SutId", SqlDbType.Int)
};
para[0].Value = SudentsModel.SutCode;
para[1].Value = SudentsModel.SutName;
para[2].Value = SudentsModel.ClassId;
para[3].Value = SudentsModel.Native;
para[4].Value = SudentsModel.Born;
para[5].Value = SudentsModel.National;
para[6].Value = SudentsModel.Political;
para[7].Value = SudentsModel.Sex;
para[8].Value = SudentsModel.Grade;
para[9].Value = SudentsModel.Contact;
para[10].Value = SudentsModel.Note;
para[11].Value = SudentsModel.Pwd;
para[12].Value = SudentsModel.SutId;
return(DBHelper.ExecuteCommand(sql, para));
}
//添加、修改
protected void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "添加")
{
Sudents model = new Sudents();
model.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
model.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
model.Contact = txtContact.Value.Trim();
model.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
model.National = ddlNational.SelectedValue.Trim();
model.Native = txtNative.Value.Trim();
model.Note = txtNote.Value.Trim();
model.Political = ddlPolitical.SelectedValue.Trim();
model.Pwd = txtPwd.Value.Trim();
model.Sex = ddlSex.SelectedValue.Trim();
model.SutCode = txtSutCode.Value.Trim();
model.SutName = txtSutName.Value.Trim();
if (SudentsBLL.IsTrue(model.SutCode))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学号已经存在，不能重复！');</script>");
return;
}
else
{
if (SudentsBLL.AddSudents(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.replace('SudentsManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败！');</script>");
return;
}
}
}
else
{
Sudents model = SudentsBLL.GetIdBySudents(Convert.ToInt32(Request.QueryString["uid"]));
model.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
model.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
model.Contact = txtContact.Value.Trim();
model.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
model.National = ddlNational.SelectedValue.Trim();
model.Native = txtNative.Value.Trim();
model.Note = txtNote.Value.Trim();
model.Political = ddlPolitical.SelectedValue.Trim();
model.Pwd = txtPwd.Value.Trim();
model.Sex = ddlSex.SelectedValue.Trim();
model.SutCode = txtSutCode.Value.Trim();
model.SutName = txtSutName.Value.Trim();
if (SudentsBLL.IsTrue(model.SutCode, model.SutId))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学号已经存在，不能重复！');</script>");
return;
}
else
{
if (SudentsBLL.UpdateSudents(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.replace('SudentsManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
return;
}
}
}
}
/// <summary>
/// 修改
///</summary>
public static int UpdateSudents(Sudents SudentsModel)
{
return(SudentsDAL.UpdateSudents(SudentsModel));
}
/// <summary>
/// 添加
///</summary>
public static int AddSudents(Sudents SudentsModel)
{
return(SudentsDAL.AddSudents(SudentsModel));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Session["Admin"] != null)
{
Admin admin = (Admin)Session["Admin"];
if (admin.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
admin.Pwd = txtNewPwd.Value.Trim();
if (AdminBLL.UpdateUsers(admin) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
if (Session["Teacher"] != null)
{
Teacher teacher = (Teacher)Session["Teacher"];
if (teacher.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
teacher.Pwd = txtNewPwd.Value.Trim();
if (TeacherBLL.UpdateTeacher(teacher) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
if (Session["Sudents"] != null)
{
Sudents sudents = (Sudents)Session["Sudents"];
if (sudents.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
sudents.Pwd = txtNewPwd.Value.Trim();
if (SudentsBLL.UpdateSudents(sudents) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
}
