/// <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));
        }
Example #2
0
    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;
        }
    }
Example #4
0
 /// <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);
 }
Example #5
0
        //添加验证是否存在
        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);
        }
Example #8
0
 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>");
     }
 }
Example #9
0
 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));
        }
Example #13
0
    //添加、修改
    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;
                }
            }
        }
    }
Example #14
0
 /// <summary>
 /// 修改
 ///</summary>
 public static int UpdateSudents(Sudents SudentsModel)
 {
     return(SudentsDAL.UpdateSudents(SudentsModel));
 }
Example #15
0
 /// <summary>
 /// 添加
 ///</summary>
 public static int AddSudents(Sudents SudentsModel)
 {
     return(SudentsDAL.AddSudents(SudentsModel));
 }
Example #16
0
 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;
             }
         }
     }
 }