//检查登录用户名是否重名 private bool CheckLoginUserName(string strName) { Tz888.BLL.Sys.EmployeeInfoTab empbll = new Tz888.BLL.Sys.EmployeeInfoTab(); DataTable dt = empbll.CheckUserLoginName(strName).Tables[0]; bool flg = false; if (dt != null && dt.Rows.Count > 0) { flg = true; } else { flg = false; } return(flg); }
protected string getEmployeeID() { BasePage bp = new BasePage(); string LoginName = bp.LoginName; Tz888.BLL.Sys.EmployeeInfoTab EmployeeBll = new Tz888.BLL.Sys.EmployeeInfoTab(); DataSet ds = EmployeeBll.GetList(" LoginName='" + LoginName + "'"); string EmployeeID = "0"; if (ds.Tables[0].Rows.Count > 0) { EmployeeID = ds.Tables[0].Rows[0]["EmployeeID"].ToString(); } // Response.Cookies["loginedUser"].Value; //从cookie中获取登录成功后的用户名 return(EmployeeID); }
private void UpdateEmpTab() { //Employeeinfotab表 Tz888.BLL.Sys.EmployeeInfoTab empBll = new Tz888.BLL.Sys.EmployeeInfoTab(); Tz888.Model.Sys.EmployeeInfoTab empModel = new Tz888.Model.Sys.EmployeeInfoTab(); empModel.LoginName = txtLoginName.Text; empModel.EmployeeName = txtEmployeeName.Text.Trim(); string strSex = rblSex.SelectedValue.Trim(); empModel.Sex = Convert.ToBoolean(strSex); empModel.NickName = txtNickName.Text.Trim(); empModel.Birthday = Convert.ToDateTime(tbDate.Value.Trim()); empModel.CertificateID = ddlCertificateID.SelectedValue.ToString().Trim(); empModel.CertificateNumber = txtCertificateNumber.Text.Trim(); //*区域,这是修改内部会员资料,所以不更新它 //*empModel.CountryCode = "CN"; //*empModel.ProvinceID = "1098"; //*empModel.CityID = "1099"; //*empModel.CountyID = "1100"; empModel.Address = txtAddress.Text.Trim(); empModel.PostCode = txtPostCode.Text.Trim(); empModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); empModel.Mobile = txtMobile.Text.Trim(); empModel.FAX = txtFax.Text.Trim(); empModel.Email = txtEmail.Text.Trim(); empModel.DeptID = ddlDept.SelectedValue.Trim(); empModel.WorkType = ddlWorkType.SelectedValue.Trim(); empModel.DegreeID = ddlDegree.SelectedValue.Trim(); if (empBll.UpdateEmpTab(empModel) > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", "alert('资料修改成功!'); location.href='SysUser.aspx'", true); } else { Tz888.Common.MessageBox.Show(this, "资料修改失败!"); } }
//更新数据 private void UpdateUserDoc() { //Employeeinfotab表 Tz888.BLL.Sys.EmployeeInfoTab empBll = new Tz888.BLL.Sys.EmployeeInfoTab(); Tz888.Model.Sys.EmployeeInfoTab empModel = new Tz888.Model.Sys.EmployeeInfoTab(); empModel.LoginName = txtLoginName.Text; empModel.EmployeeName = txtEmployeeName.Text.Trim(); string strSex = rblSex.SelectedValue.Trim(); empModel.Sex = Convert.ToBoolean(strSex); empModel.NickName = txtNickName.Text.Trim(); empModel.Birthday = Convert.ToDateTime(tbDate.Value.Trim()); empModel.CertificateID = ddlCertificateID.SelectedValue.ToString().Trim(); empModel.CertificateNumber = txtCertificateNumber.Text.Trim(); //*区域,这是修改内部会员资料,所以不更新它 //*empModel.CountryCode = "CN"; //*empModel.ProvinceID = "1098"; //*empModel.CityID = "1099"; //*empModel.CountyID = "1100"; empModel.Address = txtAddress.Text.Trim(); empModel.PostCode = txtPostCode.Text.Trim(); empModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); empModel.Mobile = txtMobile.Text.Trim(); empModel.FAX = txtFax.Text.Trim(); empModel.Email = txtEmail.Text.Trim(); empModel.DeptID = ddlDept.SelectedValue.Trim(); empModel.WorkType = ddlWorkType.SelectedValue.Trim(); empModel.DegreeID = ddlDegree.SelectedValue.Trim(); //logininfotab表 Tz888.BLL.Login.LoginInfoBLL loginBll = new Tz888.BLL.Login.LoginInfoBLL(); Tz888.Model.LoginInfo loginModel = new Tz888.Model.LoginInfo(); //######更新密码,暂不用 //SHA1 sha1 = SHA1.Create(); //byte[] bytePassword = sha1.ComputeHash(Encoding.Unicode.GetBytes(txtPassword.Text.Trim())); //loginModel.Password = bytePassword; //###### loginModel.LoginName = txtLoginName.Text; //loginModel.PasswordQuestion = txtPasswordQuestion.Text.Trim(); //loginModel.PasswordAnswer = txtPasswordAnswer.Text.Trim(); loginModel.RoleName = "2"; loginModel.IsCheckUp = false; loginModel.NickName = txtNickName.Text.Trim(); loginModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); loginModel.Email = txtEmail.Text.Trim(); //*loginModel.RequirInfo = ""; //*loginModel.RealName = ""; //*loginModel.ManageTypeID = "1001"; //*loginModel.MemberGradeID = "1001";//和以前的项目一样 //*loginModel.Enable = true; //有效 string sTem = "";//不修改角色(有专门的修改页面) if (empBll.Update(loginModel, empModel, sTem) > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", "alert('资料修改成功!'); location.href='SysUser.aspx'", true); } else { Tz888.Common.MessageBox.Show(this, "资料修改失败!"); } }
private void InsertData() { //检查登录名是否重名 if (CheckLoginUserName(txtLoginName.Text.Trim())) { Tz888.Common.MessageBox.Show(this, "该用户名已经存在,请使用其它用户名!"); txtLoginName.Focus(); //txtLoginName.Text = ""; return; } //Employeeinfotab表 Tz888.BLL.Sys.EmployeeInfoTab empBll = new Tz888.BLL.Sys.EmployeeInfoTab(); Tz888.Model.Sys.EmployeeInfoTab empModel = new Tz888.Model.Sys.EmployeeInfoTab(); //密码 SHA1 sha1 = SHA1.Create(); byte[] bytePassword = sha1.ComputeHash(Encoding.Unicode.GetBytes(txtPassword.Text.Trim())); empModel.LoginName = txtLoginName.Text.Trim(); empModel.Password = bytePassword; empModel.EmployeeName = txtEmployeeName.Text.Trim(); string strSex = rblSex.SelectedValue.Trim(); empModel.Sex = Convert.ToBoolean(strSex); empModel.NickName = txtNickName.Text.Trim(); if (!string.IsNullOrEmpty(tbDate.Value.Trim())) { empModel.Birthday = Convert.ToDateTime(tbDate.Value.Trim()); } else { //empModel.Birthday = DateTime.Now.ToShortTimeString(); empModel.Birthday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); //Response.Write("<script>alert('" + empModel.Birthday + "')</script>"); } empModel.CertificateID = ddlCertificateID.SelectedValue.ToString().Trim(); empModel.CertificateNumber = txtCertificateNumber.Text.Trim(); empModel.CountryCode = "CN"; empModel.ProvinceID = "1098"; empModel.CityID = "1099"; empModel.CountyID = "1100"; empModel.Address = txtAddress.Text.Trim(); empModel.PostCode = txtPostCode.Text.Trim(); empModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); empModel.Mobile = txtMobile.Text.Trim(); empModel.FAX = txtFax.Text.Trim(); empModel.Email = txtEmail.Text.Trim(); empModel.DeptID = ddlDept.SelectedValue.Trim(); empModel.WorkType = ddlWorkType.SelectedValue.Trim(); empModel.DegreeID = ddlDegree.SelectedValue.Trim(); empModel.Enable = true; //有效 string sTem = ddlRole.SelectedValue.Trim(); //if (empBll.Insert(empModel,sTem) > 0) if (empBll.Insert_V1(empModel, sTem) > 0) //2010-8-9改为存储过程 { Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", "alert('注册成功!'); location.href='SysUser.aspx'", true); } else { Tz888.Common.MessageBox.Show(this, "注册失败!"); } }
//注册 private void SaveUserDoc() { //检查登录名是否重名 if (CheckLoginUserName(txtLoginName.Text.Trim())) { Tz888.Common.MessageBox.Show(this, "该用户名已经存在,请使用其它用户名!"); txtLoginName.Focus(); //txtLoginName.Text = ""; return; } //Employeeinfotab表 Tz888.BLL.Sys.EmployeeInfoTab empBll = new Tz888.BLL.Sys.EmployeeInfoTab(); Tz888.Model.Sys.EmployeeInfoTab empModel = new Tz888.Model.Sys.EmployeeInfoTab(); empModel.LoginName = txtLoginName.Text.Trim(); empModel.EmployeeName = txtEmployeeName.Text.Trim(); string strSex = rblSex.SelectedValue.Trim(); empModel.Sex = Convert.ToBoolean(strSex); empModel.NickName = txtNickName.Text.Trim(); if (string.IsNullOrEmpty(tbDate.Value.Trim())) { empModel.Birthday = Convert.ToDateTime(tbDate.Value.Trim()); } else { empModel.Birthday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); } empModel.CertificateID = ddlCertificateID.SelectedValue.ToString().Trim(); empModel.CertificateNumber = txtCertificateNumber.Text.Trim(); empModel.CountryCode = "CN"; empModel.ProvinceID = "1098"; empModel.CityID = "1099"; empModel.CountyID = "1100"; empModel.Address = txtAddress.Text.Trim(); empModel.PostCode = txtPostCode.Text.Trim(); empModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); empModel.Mobile = txtMobile.Text.Trim(); empModel.FAX = txtFax.Text.Trim(); empModel.Email = txtEmail.Text.Trim(); empModel.DeptID = ddlDept.SelectedValue.Trim(); empModel.WorkType = ddlWorkType.SelectedValue.Trim(); empModel.DegreeID = ddlDegree.SelectedValue.Trim(); empModel.Enable = true; //有效 //logininfotab表 Tz888.BLL.Login.LoginInfoBLL loginBll = new Tz888.BLL.Login.LoginInfoBLL(); Tz888.Model.LoginInfo loginModel = new Tz888.Model.LoginInfo(); SHA1 sha1 = SHA1.Create(); byte[] bytePassword = sha1.ComputeHash(Encoding.Unicode.GetBytes(txtPassword.Text.Trim())); loginModel.LoginName = txtLoginName.Text.Trim(); loginModel.Password = bytePassword; //loginModel.PasswordQuestion = txtPasswordQuestion.Text.Trim(); //loginModel.PasswordAnswer = txtPasswordAnswer.Text.Trim(); loginModel.RoleName = "2"; loginModel.IsCheckUp = false; loginModel.NickName = txtNickName.Text.Trim(); loginModel.Tel = txtCountryCode.Text.Trim() + "-" + txtAreaCode.Text.Trim() + "-" + txtTelPhone.Text.Trim(); loginModel.Email = txtEmail.Text.Trim(); loginModel.RequirInfo = ""; loginModel.RealName = ""; loginModel.ManageTypeID = "1001"; loginModel.MemberGradeID = "1001"; //和以前的项目一样 loginModel.Enable = true; //有效 string sTem = ddlRole.SelectedValue.Trim(); if (empBll.Add(loginModel, empModel, sTem) > 0) { //Tz888.Common.MessageBox.Show(this, "注册成功!"); Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", "alert('注册成功!'); location.href='SysUser.aspx'", true); } else { Tz888.Common.MessageBox.Show(this, "注册失败!"); } }