/// <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");
}
