/// <summary>
/// 修改用户基本信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnUpd_Click(object sender, EventArgs e)
{
try
{
use = (U_User)Session["U_USER"];
int i = use.UID;
U_User user = new U_User();
user.UID = i;
user.UserName = this.TTbName.Text.Trim();
user.Sex = this.TbSex.Text.ToString();
user.Phone = this.TTbPhone.Text.Trim();
user.IDCard = this.TTbIDCard.Text.Trim();
user.Address = this.TTbAddress.Text.Trim();
U_EducationInfo et = new U_EducationInfo();
et.EID = int.Parse(this.TbEducation.SelectedValue.ToString());
user.EID = et;
user.Academy = this.TTbAcademy.Text.Trim();
user.Details = this.TTbDetails.Text.Trim();
user.Remark = this.TbRemark.Text.Trim();
if (string.IsNullOrEmpty(TTbName.Text) || string.IsNullOrEmpty(TTbPhone.Text) || string.IsNullOrEmpty(TTbIDCard.Text) || string.IsNullOrEmpty(TTbAddress.Text) || string.IsNullOrEmpty(TTbAcademy.Text) || string.IsNullOrEmpty(TTbDetails.Text) || string.IsNullOrEmpty(TTbEmail.Text) || string.IsNullOrEmpty(TbRemark.Text))
{
JsMessage.jsAlert("登录信息不能为空");
return;
}
Regex email = new Regex("^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+\\.[a-zA-Z0-9_-]+$");
if (!email.IsMatch(this.TTbEmail.Text))
{
JsMessage.jsAlert("邮箱格式不正确！");
return;
}
Regex mobileReg = new Regex("[0-9]{11,11}");
if (!mobileReg.IsMatch(this.TTbPhone.Text))
{
JsMessage.jsAlert("电话号码格式输入错误！");
return;
}
//Regex idcard = new Regex("d{14}[[0-9],0-9xX]");
//if (!idcard.IsMatch(this.TTbIDCard.Text))
//{
// JsMessage.jsAlert("身份证格式输入有误！");
// return;
//}
if (new UserBll().UpdUserInfor(user) > 0)
{
Common.JsMessage.jsAlert("修改成功！");
M_JournalInfo ji = new Model.M_JournalInfo();
ji.Content = use.UserName + "修改个人信息！";
ji.ReleaseTime = DateTime.Now.ToLocalTime();
ji.LoginName = use.LoginName;
new UserBll().AddJournalInfo(ji);
this.bind();
}
}
catch (Exception ex)
{
Common.JsMessage.jsAlert(ex.Message);
}
}
/// <summary>
/// 通过部门查询用户数据
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List <U_User> U_selAllUserInfoByDID(int did)
{
List <U_User> user = new List <U_User>();
try
{
string sql = "select * from [dbo].[U_UserInfor] as a left join [dbo].[U_UserType] as b on a.UTID=b.UTID left join[dbo].[U_Post] as c on a.PID=c.PID left join[dbo].[U_Department] as d on a.DID=D.DID left join[dbo].[U_EducationInfo] as e on a.EID=e.EID WHERE a.DID='" + did + "'";
//SqlParameter[] sql = new SqlParameter[] {
// new SqlParameter ("@UID",did)
//};
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
U_User us = new U_User();
us.UID = int.Parse(reader["UID"].ToString());
us.LoginName = reader["LoginName"].ToString();
us.LoginPassword = reader["LoginPassword"].ToString();
us.UserName = reader["UserName"].ToString();
U_Post p = new U_Post();
p.PID = int.Parse(reader["PID"].ToString());
p.PName = reader["PName"].ToString();
us.PID = p;
U_UserType UT = new U_UserType();
UT.UTID = int.Parse(reader["UTID"].ToString());
UT.TypeName = reader["TName"].ToString();
us.UTID = UT;
U_Department dp = new U_Department();
dp.DID = int.Parse(reader["DID"].ToString());
dp.DName = reader["DName"].ToString();
us.DID = dp;
U_EducationInfo et = new U_EducationInfo();
et.EID = int.Parse(reader["EID"].ToString());
et.Education = reader["Education"].ToString();
us.EID = et;
us.Phone = reader["Phone"].ToString();
us.IDCard = reader["IDCard"].ToString();
us.Details = reader["Details"].ToString();
us.Address = reader["Address"].ToString();
us.Email = reader["Email"].ToString();
us.Sex = reader["Sex"].ToString();
us.Remark = reader["Remark"].ToString();
us.State = reader["State"].ToString();
us.Academy = reader["Academy"].ToString();
user.Add(us);
}
}
catch (Exception)
{
throw;
}
return(user);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="us"></param>
public U_User GetInfoByNameAndPswAndType(string name, string psw, int utid)
{
U_User us = new U_User();
try
{
string sql = "select * from [dbo].[U_UserInfor]as a left join [dbo].[U_UserType] as b on a.UTID=b.UTID left join[dbo].[U_Post] as c on a.PID=c.PID left join[dbo].[U_Department] as d on a.DID=D.DID left join[dbo].[U_EducationInfo] as e on a.EID=e.EID where a.LoginName='" + name + "'and a.LoginPassword='******'and a.UTID='" + utid + "'";
//SqlParameter[] sql = new SqlParameter[] {
// new SqlParameter("@LoginName",name),
// new SqlParameter("@LoginPassword",psw),
// new SqlParameter("@UTID",utid)
//};
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
us.UID = int.Parse(reader["UID"].ToString());
us.LoginName = reader["LoginName"].ToString();
us.LoginPassword = reader["LoginPassword"].ToString();
us.UserName = reader["UserName"].ToString();
U_Post p = new U_Post();
p.PID = int.Parse(reader["PID"].ToString());
p.PName = reader["PName"].ToString();
us.PID = p;
U_UserType UT = new U_UserType();
UT.UTID = int.Parse(reader["UTID"].ToString());
UT.TypeName = reader["TName"].ToString();
us.UTID = UT;
U_Department dp = new U_Department();
dp.DID = int.Parse(reader["DID"].ToString());
dp.DName = reader["DName"].ToString();
us.DID = dp;
U_EducationInfo et = new U_EducationInfo();
et.EID = int.Parse(reader["EID"].ToString());
et.Education = reader["Education"].ToString();
us.EID = et;
us.Phone = reader["Phone"].ToString();
us.IDCard = reader["IDCard"].ToString();
us.Details = reader["Details"].ToString();
us.Address = reader["Address"].ToString();
us.Email = reader["Email"].ToString();
us.Sex = reader["Sex"].ToString();
us.Remark = reader["Remark"].ToString();
us.State = reader["State"].ToString();
us.Academy = reader["Academy"].ToString();
}
}
catch (Exception ex)
{
Common.JsMessage.jsAlert(ex.Message);
}
return(us);
}
/// <summary>
/// 通过用户名模糊查询用户信息
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <U_User> U_SelAllUserInfoByNames(string name)
{
List <U_User> user = new List <U_User>();
try
{
SqlParameter[] sql = new SqlParameter[] {
new SqlParameter("@UserName", name)
};
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "U_SelAllUserInfoByNames", sql);
while (reader.Read())
{
U_User us = new U_User();
us.UID = int.Parse(reader["UID"].ToString());
us.LoginName = reader["LoginName"].ToString();
us.LoginPassword = reader["LoginPassword"].ToString();
us.UserName = reader["UserName"].ToString();
U_Post p = new U_Post();
p.PID = int.Parse(reader["PID"].ToString());
p.PName = reader["PName"].ToString();
us.PID = p;
U_UserType UT = new U_UserType();
UT.UTID = int.Parse(reader["UTID"].ToString());
UT.TypeName = reader["TName"].ToString();
us.UTID = UT;
U_Department dp = new U_Department();
dp.DID = int.Parse(reader["DID"].ToString());
dp.DName = reader["DName"].ToString();
us.DID = dp;
U_EducationInfo et = new U_EducationInfo();
et.EID = int.Parse(reader["EID"].ToString());
et.Education = reader["Education"].ToString();
us.EID = et;
us.Phone = reader["Phone"].ToString();
us.IDCard = reader["IDCard"].ToString();
us.Details = reader["Details"].ToString();
us.Address = reader["Address"].ToString();
us.Email = reader["Email"].ToString();
us.Sex = reader["Sex"].ToString();
us.Remark = reader["Remark"].ToString();
us.State = reader["State"].ToString();
us.Academy = reader["Academy"].ToString();
user.Add(us);
}
}
catch (Exception)
{
throw;
}
return(user);
}
/// <summary>
/// 确认添加按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnAdd_Click(object sender, EventArgs e)
{
U_User user = new U_User();
user.UserName = this.TbUserName.Value.Trim();
user.LoginName = this.TbLoginName.Value.Trim();
user.LoginPassword = "******";
U_UserType ut = new U_UserType();
ut.UTID = int.Parse(this.DdlType.SelectedValue.ToString());
user.UTID = ut;
U_Department d = new U_Department();
d.DID = int.Parse(this.DdlDeparment.SelectedValue.ToString());
user.DID = d;
U_Post p = new U_Post();
p.PID = int.Parse(this.DdlPost.SelectedValue.ToString());
user.PID = p;
U_EducationInfo ed = new U_EducationInfo();
ed.EID = int.Parse(this.DdlEducation.SelectedValue.ToString());
user.EID = ed;
user.IDCard = this.TbIdCard.Value.Trim();
user.Phone = this.TbPhone.Value.Trim();
user.Address = this.TbAddress.Value.Trim();
user.Email = this.TbEmail.Value.Trim();
user.Academy = this.TbAcademy.Value.Trim();
user.Sex = this.DdlSex.Text.Trim();
user.Details = this.TbDetail.Text.Trim();
user.Remark = this.TbRemark.Value.Trim();
user.State = "0";
if (string.IsNullOrEmpty(TbUserName.Value) || string.IsNullOrEmpty(TbLoginName.Value) || string.IsNullOrEmpty(TbIdCard.Value) || string.IsNullOrEmpty(TbPhone.Value) || string.IsNullOrEmpty(TbAddress.Value) || string.IsNullOrEmpty(TbEmail.Value) || string.IsNullOrEmpty(TbDetail.Text) || string.IsNullOrEmpty(TbRemark.Value) || string.IsNullOrEmpty(this.TbAcademy.Value))
{
JsMessage.jsAlert("用户信息不能为空");
return;
}
Regex email = new Regex("^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+\\.[a-zA-Z0-9_-]+$");
if (!email.IsMatch(this.TbEmail.Value))
{
JsMessage.jsAlert("邮箱格式不正确！");
return;
}
Regex mobileReg = new Regex("[0-9]{11,11}");
if (!mobileReg.IsMatch(this.TbPhone.Value))
{
JsMessage.jsAlert("电话号码格式输入错误！");
return;
}
Regex idcard = new Regex("d{14}[[0-9],0-9xX]");
if (!idcard.IsMatch(this.TbIdCard.Value))
{
JsMessage.jsAlert("身份证格式输入有误！");
return;
}
if (new HrBll().AddUsers(user) > 0)
{
JsMessage.jsAlert("添加成功");
use = (U_User)Session["U_USER"];
M_JournalInfo ji = new Model.M_JournalInfo();
ji.Content = use.UserName + "添加用户！";
ji.ReleaseTime = DateTime.Now.ToLocalTime();
ji.LoginName = use.LoginName;
new UserBll().AddJournalInfo(ji);
}
}
