/// <summary> /// 更新员工工资 /// </summary> public bool UpdateSalary(WalleProject.Model.t_staff model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_staff set "); strSql.Append("sta_salary=@sta_salary"); strSql.Append(" where sta_id=@sta_id"); MySqlParameter[] parameters = { new MySqlParameter("@sta_salary", MySqlDbType.Decimal, 10), new MySqlParameter("@sta_id", MySqlDbType.Int32, 10) }; parameters[0].Value = model.sta_salary; parameters[1].Value = model.sta_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staff GetModel(long sta_id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT * from t_staff inner join t_staffcategory on t_staff.sta_tra_id=t_staffcategory.stac_ID inner join t_picture on t_picture.pic_ID = t_staff.sta__pic_id "); strSql.Append(" where sta_id=@sta_id"); MySqlParameter[] parameters = { new MySqlParameter("@sta_id", MySqlDbType.Int32) }; parameters[0].Value = sta_id; WalleProject.Model.t_staff model = new WalleProject.Model.t_staff(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void Unnamed_ServerClick(object sender, EventArgs e) { HttpCookie staffc = Request.Cookies["staff"]; string userName = staffc.Values["staffID"]; string Password = Maticsoft.Common.PageValidate.InputText(password.Value.Trim(), 30); bool isNumber = Maticsoft.Common.PageValidate.IsNumber(userName); //验证登录信息,如果验证通过则返回当前用户对象的安全上下文信息 // AccountsPrincipal newUser = AccountsPrincipal.ValidateLogin(userName, Password); BLL.t_staff staff = new BLL.t_staff(); if (isNumber) { if (staff.Exists(int.Parse(userName))) { if (staff.IsLogin(int.Parse(userName), Password)) { WalleProject.Model.t_staff _Staff = new WalleProject.Model.t_staff(); _Staff = staff.GetModel(int.Parse(userName)); Session["UserInfo"] = _Staff; Response.Redirect("../StaffSystem/Default.aspx?menuid=1"); } else { Response.Write("<script>alert('您输入的密码不正确!')</script>"); } } else { Response.Write("<script>alert('您输入的用户名不存在!')</script>"); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_staff model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_staff set "); strSql.Append("sta_userName=@sta_userName,"); strSql.Append("sta_entryDate=@sta_entryDate,"); strSql.Append("sta_passWord=@sta_passWord,"); strSql.Append("sta_maritalStatus=@sta_maritalStatus,"); strSql.Append("sta_IDNumber=@sta_IDNumber,"); strSql.Append("sta_homeAddress=@sta_homeAddress,"); strSql.Append("sta_phone=@sta_phone,"); strSql.Append("sta_name=@sta_name,"); strSql.Append("sta__pic_id=@sta__pic_id,"); strSql.Append("sta_tra_id=@sta_tra_id,"); strSql.Append("sta_lastLogindate=@sta_lastLogindate,"); strSql.Append("sta_salary=@sta_salary"); strSql.Append(" where sta_id=@sta_id"); MySqlParameter[] parameters = { new MySqlParameter("@sta_userName", MySqlDbType.VarChar, 20), new MySqlParameter("@sta_entryDate", MySqlDbType.DateTime), new MySqlParameter("@sta_passWord", MySqlDbType.VarChar, 20), new MySqlParameter("@sta_maritalStatus", MySqlDbType.VarChar, 2), new MySqlParameter("@sta_IDNumber", MySqlDbType.VarChar, 20), new MySqlParameter("@sta_homeAddress", MySqlDbType.VarChar, 50), new MySqlParameter("@sta_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@sta_name", MySqlDbType.VarChar, 10), new MySqlParameter("@sta__pic_id", MySqlDbType.Int32, 10), new MySqlParameter("@sta_tra_id", MySqlDbType.Int32, 10), new MySqlParameter("@sta_lastLogindate", MySqlDbType.DateTime), new MySqlParameter("@sta_salary", MySqlDbType.Decimal, 10), new MySqlParameter("@sta_id", MySqlDbType.Int32, 10) }; parameters[0].Value = model.sta_userName; parameters[1].Value = model.sta_entryDate; parameters[2].Value = model.sta_passWord; parameters[3].Value = model.sta_maritalStatus; parameters[4].Value = model.sta_IDNumber; parameters[5].Value = model.sta_homeAddress; parameters[6].Value = model.sta_phone; parameters[7].Value = model.sta_name; parameters[8].Value = model.sta__pic_id; parameters[9].Value = model.sta_tra_id; parameters[10].Value = model.sta_lastLogindate; parameters[11].Value = model.sta_salary; parameters[12].Value = model.sta_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(long sta_id) { WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); WalleProject.Model.t_staff model = bll.GetModel(sta_id); this.txtsta_userName.Text = model.sta_userName; this.txtsta_maritalStatus.Text = model.sta_maritalStatus; this.txtsta_IDNumber.Text = model.sta_IDNumber; this.txtsta_homeAddress.Text = model.sta_homeAddress; this.txtsta_phone.Text = model.sta_phone; this.txtsta_name.Text = model.sta_name; this.staffid.InnerText = model.sta_id.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txt_passWord1.Text.Trim().Length == 0) { strErr += "原密码不能为空!\\n"; } if (this.txt_passWord3.Text.Trim().Length == 0) { strErr += "新密码不能为空!\\n"; } if (this.txt_passWord2.Text.Trim().Length == 0) { strErr += "密码不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string passWord1 = MD5Enctypt.MD5.Md5Encrypt(this.txt_passWord1.Text.Trim()); string passWord2 = MD5Enctypt.MD5.Md5Encrypt(this.txt_passWord2.Text.Trim()); string passWord3 = MD5Enctypt.MD5.Md5Encrypt(this.txt_passWord3.Text.Trim()); WalleProject.Model.t_staff model = (Model.t_staff)Session["UserInfo"]; if (passWord1 == model.sta_passWord) { if (passWord2 == passWord3) { model.sta_passWord = passWord2; WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "Default.aspx"); } else { strErr += "新密码不匹配!\\n"; MessageBox.Show(this, strErr); return; } } else { strErr += "原密码不正确!\\n"; MessageBox.Show(this, strErr); return; } }
private void ShowInfo(long sta_id) { WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); WalleProject.Model.t_staff model = bll.GetModel(sta_id); this.imgPhoto.Src = new BLL.t_picture().GetModel(int.Parse(model.sta__pic_id.ToString())).pic_valid; this.lblsta_id.Text = model.sta_id.ToString(); this.lblsta_userName.Text = model.sta_userName; this.lblsta_entryDate.Text = model.sta_entryDate.ToString(); this.lblsta_maritalStatus.Text = model.sta_maritalStatus; this.lblsta_IDNumber.Text = model.sta_IDNumber; this.lblsta_homeAddress.Text = model.sta_homeAddress; this.lblsta_phone.Text = model.sta_phone; this.lblsta_name.Text = model.sta_name; this.lblsta_lastLogindate.Text = model.sta_lastLogindate.ToString(); this.lblsta_salary.Text = model.sta_salary.ToString(); }
private void ShowInfoEdit(long sta_id) { WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); WalleProject.Model.t_staff model = bll.GetModel(sta_id); this.lblsta_id.Text = model.sta_id.ToString(); this.txtEdit_sta_userName.Text = model.sta_userName; this.txtEdit_sta_entryDate.Text = model.sta_entryDate.ToString(); this.txtEdit_sta_passWord.Text = MD5Enctypt.MD5.Md5Decrypt(model.sta_passWord); this.txtEdit_sta_maritalStatus.Text = model.sta_maritalStatus; this.txtEdit_sta_IDNumber.Text = model.sta_IDNumber; this.txtEdit_sta_homeAddress.Text = model.sta_homeAddress; this.txtEdit_sta_phone.Text = model.sta_phone; this.txtEdit_sta_name.Text = model.sta_name; this.txtEdit_sta_tra_id.Text = model.sta_tra_id.ToString(); this.txtEdit_sta_lastLogindate.Text = model.sta_lastLogindate.ToString(); this.txtEdit_sta_salary.Text = model.sta_salary.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staff DataRowToModel(DataRow row) { WalleProject.Model.t_staff model = new WalleProject.Model.t_staff(); if (row != null) { if (row["sta_id"] != null && row["sta_id"].ToString() != "") { model.sta_id = long.Parse(row["sta_id"].ToString()); } if (row["sta_userName"] != null) { model.sta_userName = row["sta_userName"].ToString(); } if (row["sta_entryDate"] != null && row["sta_entryDate"].ToString() != "") { model.sta_entryDate = DateTime.Parse(row["sta_entryDate"].ToString()); } if (row["sta_passWord"] != null) { model.sta_passWord = row["sta_passWord"].ToString(); } if (row["sta_maritalStatus"] != null) { model.sta_maritalStatus = row["sta_maritalStatus"].ToString(); } if (row["sta_IDNumber"] != null) { model.sta_IDNumber = row["sta_IDNumber"].ToString(); } if (row["sta_homeAddress"] != null) { model.sta_homeAddress = row["sta_homeAddress"].ToString(); } if (row["sta_phone"] != null) { model.sta_phone = row["sta_phone"].ToString(); } if (row["sta_name"] != null) { model.sta_name = row["sta_name"].ToString(); } if (row["sta__pic_id"] != null && row["sta__pic_id"].ToString() != "") { model.sta__pic_id = int.Parse(row["sta__pic_id"].ToString()); } if (row["sta_tra_id"] != null && row["sta_tra_id"].ToString() != "") { model.sta_tra_id = int.Parse(row["sta_tra_id"].ToString()); } if (row["sta_lastLogindate"] != null && row["sta_lastLogindate"].ToString() != "") { model.sta_lastLogindate = DateTime.Parse(row["sta_lastLogindate"].ToString()); } if (row["sta_salary"] != null && row["sta_salary"].ToString() != "") { model.sta_salary = decimal.Parse(row["sta_salary"].ToString()); } if (row["pic_valid"] != null && row["pic_valid"].ToString() != "") { model.staffPicture.pic_valid = row["pic_valid"].ToString(); } if (row["stac_name"] != null && row["stac_name"].ToString() != "") { model.staffcategory.stac_name = row["stac_name"].ToString(); } } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtsta_userName.Text.Trim().Length == 0) { strErr += "用户名不能为空!\\n"; } if (this.txtsta_passWord.Text.Trim().Length == 0) { strErr += "密码不能为空!\\n"; } if (this.txtsta_maritalStatus.Text.Trim().Length == 0) { strErr += "婚姻状况不能为空!\\n"; } if (this.txtsta_IDNumber.Text.Trim().Length == 0) { strErr += "身份证号码不能为空!\\n"; } if (this.txtsta_homeAddress.Text.Trim().Length == 0) { strErr += "家庭住址不能为空!\\n"; } if (this.txtsta_phone.Text.Trim().Length == 0) { strErr += "电话号码不能为空!\\n"; } if (this.txtsta_name.Text.Trim().Length == 0) { strErr += "真实姓名不能为空!\\n"; } if (!PageValidate.IsNumber(txtsta__pic_id.Text)) { strErr += "头像ID格式错误!\\n"; } if (!PageValidate.IsNumber(txtsta_tra_id.Text)) { strErr += "用户类型格式错误!\\n"; } if (!PageValidate.IsDecimal(txtsta_salary.Text)) { strErr += "工资格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string sta_userName = this.txtsta_userName.Text; DateTime sta_entryDate = DateTime.Now; string sta_passWord = MD5Enctypt.MD5.Md5Encrypt(this.txtsta_passWord.Text.Trim()); string sta_maritalStatus = this.txtsta_maritalStatus.Text; string sta_IDNumber = this.txtsta_IDNumber.Text; string sta_homeAddress = this.txtsta_homeAddress.Text; string sta_phone = this.txtsta_phone.Text; string sta_name = this.txtsta_name.Text; int sta__pic_id = int.Parse(this.txtsta__pic_id.Text); int sta_tra_id = int.Parse(this.txtsta_tra_id.Text); decimal sta_salary = decimal.Parse(this.txtsta_salary.Text); WalleProject.Model.t_staff model = new WalleProject.Model.t_staff(); model.sta_userName = sta_userName; model.sta_entryDate = sta_entryDate; model.sta_passWord = sta_passWord; model.sta_maritalStatus = sta_maritalStatus; model.sta_IDNumber = sta_IDNumber; model.sta_homeAddress = sta_homeAddress; model.sta_phone = sta_phone; model.sta_name = sta_name; model.sta__pic_id = sta__pic_id; model.sta_tra_id = sta_tra_id; model.sta_salary = sta_salary; WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "StaffManage.aspx?menuid=4"); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtEdit_sta_userName.Text.Trim().Length == 0) { strErr += "sta_userName不能为空!\\n"; } if (!PageValidate.IsDateTime(txtEdit_sta_entryDate.Text)) { strErr += "sta_entryDate格式错误!\\n"; } if (this.txtEdit_sta_passWord.Text.Trim().Length == 0) { strErr += "sta_passWord不能为空!\\n"; } if (this.txtEdit_sta_maritalStatus.Text.Trim().Length == 0) { strErr += "sta_maritalStatus不能为空!\\n"; } if (this.txtEdit_sta_IDNumber.Text.Trim().Length == 0) { strErr += "sta_IDNumber不能为空!\\n"; } if (this.txtEdit_sta_homeAddress.Text.Trim().Length == 0) { strErr += "sta_homeAddress不能为空!\\n"; } if (this.txtEdit_sta_phone.Text.Trim().Length == 0) { strErr += "sta_phone不能为空!\\n"; } if (this.txtEdit_sta_name.Text.Trim().Length == 0) { strErr += "sta_name不能为空!\\n"; } if (!PageValidate.IsNumber(txtEdit_sta__pic_id.Text)) { strErr += "sta__pic_id格式错误!\\n"; } if (!PageValidate.IsNumber(txtEdit_sta_tra_id.Text)) { strErr += "sta_tra_id格式错误!\\n"; } if (!PageValidate.IsDateTime(txtEdit_sta_lastLogindate.Text)) { strErr += "sta_lastLogindate格式错误!\\n"; } if (!PageValidate.IsDecimal(txtEdit_sta_salary.Text)) { strErr += "sta_salary格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } long sta_id = long.Parse(this.lblsta_id.Text); string sta_userName = this.txtEdit_sta_userName.Text; DateTime sta_entryDate = DateTime.Parse(this.txtEdit_sta_entryDate.Text); string sta_passWord = this.txtEdit_sta_passWord.Text; string sta_maritalStatus = this.txtEdit_sta_maritalStatus.Text; string sta_IDNumber = this.txtEdit_sta_IDNumber.Text; string sta_homeAddress = this.txtEdit_sta_homeAddress.Text; string sta_phone = this.txtEdit_sta_phone.Text; string sta_name = this.txtEdit_sta_name.Text; int sta__pic_id = int.Parse(this.txtEdit_sta__pic_id.Text); int sta_tra_id = int.Parse(this.txtEdit_sta_tra_id.Text); DateTime sta_lastLogindate = DateTime.Parse(this.txtEdit_sta_lastLogindate.Text); decimal sta_salary = decimal.Parse(this.txtEdit_sta_salary.Text); WalleProject.Model.t_staff model = new WalleProject.Model.t_staff(); model.sta_id = sta_id; model.sta_userName = sta_userName; model.sta_entryDate = sta_entryDate; model.sta_passWord = sta_passWord; model.sta_maritalStatus = sta_maritalStatus; model.sta_IDNumber = sta_IDNumber; model.sta_homeAddress = sta_homeAddress; model.sta_phone = sta_phone; model.sta_name = sta_name; model.sta__pic_id = sta__pic_id; model.sta_tra_id = sta_tra_id; model.sta_lastLogindate = sta_lastLogindate; model.sta_salary = sta_salary; WalleProject.BLL.t_staff bll = new WalleProject.BLL.t_staff(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "StaffManage.aspx"); }