Ejemplo n.º 1
0
        protected void btnApply_Click(object sender, EventArgs e)
        {
            string corpid = lCorpID.Text.Trim();
            if (corpid.Equals("")) {
                GetAlertMsg("您查询的企业不存在,请输入正确的企业代码。");
                return;
            }
            using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
            {
                PersonDAL personDAL = new PersonDAL(conn);

                string cpid = personDAL.ApplyCorp(personid, corpid);
                if (cpid.Equals(""))
                {
                    //add log
                    //CorpPersonDAL cpDAL = new CorpPersonDAL(conn);
                    //cpDAL.ProcAndLog(cpid, "", (int)CorpPersonProcType.Apply, (int)CorpPersonStatus.Applying);
                    //日志已在上函数包含

                    GetSuccessMsg("您的申请已提交请等待企业审核审批。","list.aspx");
                }
                else
                {
                    GetAlertMsg("你已经处于在申请/入职或申请状态,请勿重复申请。");
                }

            }
        }
Ejemplo n.º 2
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
            {
                PersonDAL personDAL = new PersonDAL(conn);

                string name = this.txtName_.Text;
                string birth = this.txtBirth.Text;
                string hujidi = this.txtHujidi.Text;
                string people = this.ddlPeople.SelectedValue;
                string sex = this.ddlSex.SelectedValue;
                string idnumber = this.txtIDNumber.Text;
                string mobile = this.txtMobile.Text;
                string hujitype = this.ddlHujiType.SelectedValue;
                string family_addr = this.txtFamilyAddr.Text;
                string family_postcode = this.txtFamilyPostCode.Text;
                string work_addr = this.txtWorkAddr.Text;
                string work_postcode = this.txtWorkPostCode.Text;

                DataRow person = personDAL.GetAPerson(personid);

                person["realName"] = name;
                person["Birthday"] = DateTime.Parse(birth);
                person["Hujidi"] = hujidi;
                person["People"] = people;
                person["gendar"] = sex;
                person["Idnumber"] = idnumber;
                person["mobile"] = mobile;
                person["hujitype"] = hujitype;
                person["family_addr"] = family_addr;
                person["family_postcode"] = family_postcode;
                person["work_addr"] = work_addr;
                person["work_postcode"] = work_postcode;

                personDAL.Update(person);

                string from = ViewState["from"].ToString();
                if (from.Equals("reg"))
                {
                    //GetAlertMsg("用户基本信息已更新,注册完成,请使用契合网签系统.");
                    //Response.Redirect("../index.aspx");

                    GetSuccessMsg("用户基本信息已更新,注册完成,请使用契合网签系统.","../index.aspx",false);
                }
                else
                {
                    GetAlertMsg("用户基本信息已更新");
                }
            }
        }
Ejemplo n.º 3
0
        private void BindData()
        {
            string pid = this._personid;
            ViewState["personid"] = pid;

            PersonDAL personDAL = new PersonDAL(_conn);
            SysResDAL sysResDAL = new SysResDAL(_conn);

            DataRow pa = personDAL.GetAPerson(pid);
            if (null == pa) return;

            this.lRealName.Text = Functions.CleanDBString(pa["realname"]);
            this.lBirthday.Text = Functions.GetShortDateStringFromNullableDateTime(Functions.CleanDBDateTime(pa["birthday"]));
            this.lIDNumber.Text = Functions.CleanDBString(pa["idnumber"]);
            this.lHujidi.Text = Functions.CleanDBString(pa["hujidi"]);
            this.lSex.Text = SexHashTable.GetName(Functions.CleanDBInt(pa["gendar"]));
            this.lPeople.Text = sysResDAL.GetResName("res_people", Functions.CleanDBString(pa["people"]));
            this.lRealName.Text = Functions.CleanDBString(pa["realname"]);
        }
Ejemplo n.º 4
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
            {
                string password = this.txtPassword.Text;
                string newpassword = this.txtNewPassword.Text;
                string newpassword2 = this.txtNewPassword2.Text;

                string password_md5 = CommonBLL.GetMD5Password(password);

                //if (!newpassword.Equals(newpassword2)) {
                //    GetSuccessMsg("两次输入新密码不一致.");
                //    return;
                //}

                PersonDAL personDAL = new PersonDAL(conn);
                DataRow person = personDAL.GetAPerson(personid);

                CommonDAL dal = new CommonDAL(conn);

                if (password_md5.Equals(Functions.CleanDBString(person["password"])))
                {
                    string newpassword_md5 = CommonBLL.GetMD5Password(newpassword);
                    string sql = "update person set password='******',passworduserchanged=1 where id='" + personid+"'";
                    dal.ExecSQL(sql);
                    Session["person.passworduserchanged"] = 1;
                    GetSuccessMsg("密码已更新", "../index.aspx");
                    return;
                }
                else
                {
                    GetSuccessMsg("原密码不正确");
                    return;
                }
            }
        }
Ejemplo n.º 5
0
        public static object CheckLogin(SqlConnection conn, string username, string password)
        {
            PersonDAL personDAL = new PersonDAL(conn);
            string password_md5 = CommonBLL.GetMD5Password(password);
            DataRow p =null;

            //username
            if (null == p)
            {
                p = personDAL.GetAPersonByUsername(username);
            }

            //usercode
            if (null == p)
            {
                p = personDAL.GetAPersonByUserCode(username);
            }

            //idnumber
            if (null == p)
            {
                p = personDAL.GetAPersonByIDNumber(username);
            }

            if (null == p) return "-1";
            if (Functions.CleanDBString(p["password"]).Equals(password_md5))
            {

                //return Functions.CleanDBGuid(p["id"]);
                return p;
            }
            else
            {
                return "-2";
            }
        }
Ejemplo n.º 6
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(Globals.ConnectionString))
            {
                PersonDAL personDAL = new PersonDAL(conn);

                //验证码
                string checkcode = Request.Cookies["CheckCode"].Value;
                string valicode = txtValiCode.Text;
                if (String.Compare(checkcode, valicode, true) != 0)
                {
                    GetErrMsg("验证码错误,请输入正确的验证码。");
                    return;
                }

                //身份证已存在否?
                string idnumber = txtIDNumber.Text;
                if (personDAL.IsIDNumberExist( idnumber))
                {
                    GetErrMsg("该身份证号已注册过,不可重复注册.\\n请使用已有的用户名登录.");
                    return;

                }

                //用户名已存在否?
                string username = txtUsername.Text;
                if (personDAL.IsUsernameExist( username))
                {
                    GetErrMsg("该用户名已注册过,请换名再试");
                    return;
                }

                //邮箱已存在否?
                string email = txtEMail.Text;
                if (personDAL.IsEmailExist(email))
                {
                    GetErrMsg("该邮箱已被注册过,请换邮箱再试");
                    return;
                }
                //获取用户code
                string usercode = PersonBLL.GetPersonNumber();

                //记录用户信息
                DataRow p = personDAL.GetABlankPerson();

                p["Username"] = username;
                p["usercode"] = usercode;
                p["Password"] = CommonBLL.GetMD5Password(this.txtPassword.Text);
                p["Idnumber"] = idnumber;
                p["mobile"] = txtMyMobile.Text;
                p["Email"] = txtEMail.Text;
                p["passworduserchanged"] = 1;

                string pid = personDAL.Create(p);

                if (pid!=null)
                {

                    //set session ,simu as login
                    Session["person.id"] = pid;
                    Session["person.username"] = username;
                    Session["person.passworduserchanged"] =1;

                    string mailtitle = "契合网用户注册信息";
                    string mailcontent = "您的用户名是:" + username + " , 请牢记. ";

                    EmailBLL emailBLL = new EmailBLL();
                    emailBLL.SendMail(email, mailtitle, mailcontent);

                    GetSuccessMsg("注册信息已发送至您的安全邮箱.\\n下一步,请填写个人信息", "baseinfo.aspx?from=reg");// goto baseinfo

                }
                else
                {
                    GetSuccessMsg("系统错误发生!");
                }
            }//conn
        }
Ejemplo n.º 7
0
        //分配11位的号码
        public static string GetPersonNumber()
        {
            string res = "";
            using(SqlConnection conn = new SqlConnection(Globals.ConnectionString)){
                while (true)
                {
                    res = RandomHelper.GenerateRandomNumber(11);

                    PersonDAL pd = new PersonDAL(conn);
                    DataRow p = pd.GetAPersonByUserCode(res);
                    if (null == p) break;
                }
            }
            return res;
        }
Ejemplo n.º 8
0
        private void BindData(SqlConnection conn)
        {
            PersonDAL personDAL = new PersonDAL(conn);

            DataRow person = personDAL.GetAPerson(personid);

            this.lUserCode.Text = Functions.CleanDBString(person["usercode"]);

            this.txtIDNumber.Text = Functions.CleanDBString(person["Idnumber"]);
            this.txtIDNumber0.Text = this.txtIDNumber.Text;

            this.txtName_.Text = Functions.CleanDBString(person["realname"]);

            DateTime? birthday = Functions.CleanDBDateTime(person["Birthday"]);
            if (null == birthday)
            {
                 this.txtBirth.Text = Functions.GetShortDateStringFromNullableDateTime(
                     Functions.GetBirthDayFromIDNumber(Functions.CleanDBString(person["Idnumber"])));
            }else{
                this.txtBirth.Text = Functions.GetShortDateStringFromNullableDateTime(birthday);
            }
            this.txtHujidi.Text = Functions.CleanDBString(person["Hujidi"]);
            this.ddlSex.SelectedValue = Functions.ParseStr(Functions.CleanDBInt(person["gendar"]));
            this.ddlPeople.SelectedValue = Functions.CleanDBString(person["People"]);

            this.txtMobile.Text = Functions.CleanDBString(person["mobile"]);
            this.ddlHujiType.SelectedValue = Functions.CleanDBString(person["hujitype"]);

            this.txtFamilyAddr.Text = Functions.CleanDBString(person["family_addr"]);
            this.txtFamilyPostCode.Text = Functions.CleanDBString(person["family_postcode"]);
            this.txtWorkAddr.Text = Functions.CleanDBString(person["work_addr"]);
            this.txtWorkPostCode.Text = Functions.CleanDBString(person["work_postcode"]);
        }