/// <summary>
/// 更新事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GvUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
U_User us = new U_User();
us.UID = Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("ID") as HiddenField).Value);
U_UserType ut = new U_UserType();
ut.UTID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlType") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlType") as DropDownList).SelectedValue);
us.UTID = ut;
U_Post post = new U_Post();
post.PID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlPost") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlPost") as DropDownList).SelectedValue);
us.PID = post;
U_Department dp = new U_Department();
dp.DID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlDepartment") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlDepartment") as DropDownList).SelectedValue);
us.DID = dp;
if (new HrBll().H_UpdUserInfoByPidAndDid(us) > 0)
{
JsMessage.jsAlert("修改成功");
this.GvUserInfo.EditIndex = -1;
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);
//数据绑定
this.bind();
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
}
public List <M_Permission> getCheckState(int UTID)
{
List <M_Permission> d = new List <M_Permission>();
try
{
string sql = "select MID,UTID from M_Permission where UTID=" + UTID + "";
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
M_Permission mp = new M_Permission();
//mp.PID = (int)reader["PID"];
U_UserType ut = new U_UserType();
ut.UTID = (int)reader["UTID"];
mp.UTID = ut;
M_MeauInfo mm = new M_MeauInfo();
mm.MID = (int)reader["MID"];
mp.MID = mm;
d.Add(mp);
}
}
catch (Exception)
{
throw;
}
return(d);
}
/// <summary>
/// 登录按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnLogin_Click(object sender, EventArgs e)
{
U_User user = new U_User();
user.LoginName = this.TtbName.Value.ToString();
user.LoginPassword = this.TtbPswd.Value.ToString();
if (string.IsNullOrEmpty(TtbName.Value) || string.IsNullOrEmpty(TtbPswd.Value))
{
JsMessage.jsAlert("登录信息不能为空");
return;
}
int type = int.Parse(ddlUserType.SelectedValue.ToString());
U_UserType ut = new U_UserType();
ut.UTID = type;
user.UTID = ut;
user = new UserBll().GetInfoByNameAndPswAndType(user.LoginName, user.LoginPassword, type);
if (user.UID > 0)
{
M_JournalInfo ji = new Model.M_JournalInfo();
ji.Content = user.UserName + "登录进入系统！";
ji.ReleaseTime = DateTime.Now.ToLocalTime();
ji.LoginName = user.LoginName;
new UserBll().AddJournalInfo(ji);
Session["U_USER"] = user;
Response.Redirect("M_Index.aspx");
}
else
{
Common.JsMessage.jsAlert("登录失败！请检查信息输入是否正确！");
return;
}
}
/// <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);
}
}
