/// <summary>
/// 为用户名称和部门赋值
/// </summary>
public void bind()
{
use = (U_User)Session["U_USER"];
this.LbUserName.Text = use.UserName; //为用户名赋值
this.LbDid.Text = use.DID.DName.ToString(); //为部门赋值
}
/// <summary>
/// 编辑请假信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmission_Click(object sender, EventArgs e)
{
use = (U_User)Session["U_USER"];
int i = use.UID;
int dp = use.DID.DID;
U_Leave le = new U_Leave();
U_User u = new U_User();
u.UID = i;
le.UID = u;
U_Department d = new U_Department();
d.DID = dp;
le.DID = d;
le.LReason = this.TbReason.Text.Trim();
le.BeginTime = this.TbAoginTime.Text.Trim();
le.EndTime = this.TbEndTime.Text.Trim();
le.Remark = this.TbRemark.Text.Trim();
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(TbAoginTime.Text) || string.IsNullOrEmpty(this.TbEndTime.Text) || string.IsNullOrEmpty(this.TbRemark.Text))
{
JsMessage.jsAlert("请假信息不能为空，请填写完整！");
return;
}
if (new UserBll().AddUserLeave(le) > 0)
{
JsMessage.jsAlert("添加成功！");
}
this.TbReason.Text = "";
this.TbAoginTime.Text = "";
this.TbEndTime.Text = "";
this.TbRemark.Text = "";
}
public ActionResult Insert([Bind(Exclude = "UserPhoto")] U_User user, HttpPostedFileBase UserPhoto, string ConfirmPassword)
{
if (ModelState.IsValid)
{
if (db.U_User.Where(o => o.UserAccount == user.UserAccount).FirstOrDefault() != null)
{
return(Content("<script language='javascript' type='text/javascript'>alert('使用者帳號已存在，請重新輸入!');history.go(-1);</script>"));
}
else if (user.UserPassword != ConfirmPassword)
{
return(Content("<script language='javascript' type='text/javascript'>alert('確認密碼不正確，請重新輸入!');history.go(-1);</script>"));
}
else
{
user.PermissionID = Convert.ToInt32(db.U_Permission.Where(p => p.PermissionID == 2).Select(p => p.PermissionID).First());
user.CreateTime = DateTime.Now;
//repository.Create(user);
if (UserPhoto != null)
{
byte[] imageByte = null;
BinaryReader reader = new BinaryReader(UserPhoto.InputStream);
imageByte = reader.ReadBytes((int)UserPhoto.ContentLength);
user.UserPhoto = imageByte;
repository.Create(user);
Response.Cookies["UserID"].Value = user.UserID.ToString();
Response.Cookies["login"].Value = HttpUtility.UrlEncode(user.UserName);
Response.Cookies["account"].Value = HttpUtility.UrlEncode(user.UserAccount);
Response.Cookies["permission"].Value = user.PermissionID.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
string presetfilename = Request.PhysicalApplicationPath + "images/nouser.png";
FileStream pfs = new FileStream(presetfilename, FileMode.Open, FileAccess.Read);
int plength = (int)pfs.Length;
byte[] presetimage = new byte[plength];
pfs.Read(presetimage, 0, plength);
user.UserPhoto = presetimage;
repository.Create(user);
Response.Cookies["UserID"].Value = user.UserID.ToString();
Response.Cookies["login"].Value = HttpUtility.UrlEncode(user.UserName);
Response.Cookies["account"].Value = HttpUtility.UrlEncode(user.UserAccount);
Response.Cookies["permission"].Value = user.PermissionID.ToString();
return(RedirectToAction("Index", "Home"));
}
}
}
else
{
return(View());
}
}
/// <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);
}
}
/// <summary>
/// 注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public ResultModel <object> Register(U_User user)
{
ResultModel <object> msg = new ResultModel <object>();
var list = CacheOperation <List <dynamic> > .GetCache(user.E_Mail);
if (list == null)
{
msg.Code = 2001;
msg.Message = "验证码已过期";
return(msg);
}
if (list != user.AuthCode)
{
msg.Code = 2001;
msg.Message = "验证码错误";
return(msg);
}
user.UserCode = new CreateEmpCode().GetRandomEmpCode(2, 4);
var result = new U_UserDAL().Register(user);
if (result > 0)
{
msg.Message = "注册成功";
return(msg);
}
else
{
msg.Code = 2001;
msg.Message = "注册失败";
return(msg);
}
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="us"></param>
/// <returns></returns>
public int AddUsers(U_User us)
{
try
{
SqlParameter[] mySql = new SqlParameter[]
{
new SqlParameter("@LoginName", us.LoginName),
new SqlParameter("@LoginPassword", us.LoginPassword),
new SqlParameter("@UserName", us.UserName),
new SqlParameter("@UTID", us.UTID.UTID),
new SqlParameter("@DID", us.DID.DID),
new SqlParameter("@PID", us.PID.PID),
new SqlParameter("@EID", us.EID.EID),
new SqlParameter("@IDCard", us.IDCard),
new SqlParameter("@Phone", us.Phone),
new SqlParameter("@Address", us.Address),
new SqlParameter("@Email", us.Email),
new SqlParameter("@Academy", us.Academy),
new SqlParameter("@Sex", us.Sex),
new SqlParameter("@Details", us.Details),
new SqlParameter("@Remark", us.Remark),
new SqlParameter("@State", us.State)
};
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "addUsers", mySql));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 查询所有请假信息
/// </summary>
/// <returns></returns>
public List <U_Leave> H_selLeave()
{
List <U_Leave> le = new List <U_Leave>();
try
{
string sql = "select * from [dbo].[U_Leave] as a left join [dbo].[U_UserInfor] as b on a.UID=b.UID left join [dbo].[U_Department] as c on a.DID=c.DID order by a.BeginTime desc";
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
U_Leave l = new U_Leave();
l.LID = int.Parse(reader["LID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
l.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
l.DID = d;
l.LReason = reader["LReason"].ToString();
l.BeginTime = reader["BeginTime"].ToString();
l.EndTime = reader["EndTime"].ToString();
l.Month = reader["Month"].ToString();
l.Remark = reader["Remark"].ToString();
l.State = reader["State"].ToString();
le.Add(l);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(le);
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public ResultModel <object> ResetUserPassword(U_User user)
{
ResultModel <object> msg = new ResultModel <object>();
var list = CacheOperation <List <dynamic> > .GetCache(user.E_Mail);
if (list == null)
{
msg.Code = 2001;
msg.Message = "验证码已过期";
return(msg);
}
if (list != user.AuthCode)
{
msg.Code = 2001;
msg.Message = "验证码错误";
return(msg);
}
user.PassWord = EncryptOperation.MD5HashHex(user.PassWord);
var result = new U_UserDAL().ResetUserPassword(user);
if (result > 0)
{
msg.Message = "修改成功";
return(msg);
}
else
{
msg.Code = 2001;
msg.Message = "修改失败";
return(msg);
}
}
/// <summary>
/// 查询所有辞职信息
/// </summary>
/// <returns></returns>
public List <U_Resignation> H_selResignation()
{
List <U_Resignation> re = new List <U_Resignation>();
try
{
string sql = "select a.RID,a.UID,a.DID,a.Reason,a.Time,a.Remark,b.UserName,b.DID,case when b.State=0 then '正常' else '停用'end as st ,c.* from [dbo].[U_ResignationInfo] as a left join [dbo].[U_UserInfor] as b on a.UID=b.UID left join [dbo].[U_Department] as c on a.DID=c.DID order by Time desc";
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
U_Resignation r = new U_Resignation();
r.RID = int.Parse(reader["RID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
user.State = reader["st"].ToString();
//user.DID = int.Parse(reader["DID"].ToString());
r.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
r.DID = d;
r.Reason = reader["Reason"].ToString();
r.Time = DateTime.Parse(reader["Time"].ToString());
r.Remark = reader["Remark"].ToString();
r.State = reader["Remark"].ToString();
re.Add(r);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(re);
}
public List<U_User> GetUsersInRole(string id)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List<U_User>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_User_Repository_GetUsersInRole, parms)) {
while (rdr.Read()) {
var entity = new U_User();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.PasswordFormat = SqlTypeConverter.DBNullEnmPasswordFormatHandler(rdr["PasswordFormat"]);
entity.PasswordSalt = SqlTypeConverter.DBNullStringHandler(rdr["PasswordSalt"]);
entity.CreatedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedDate"]);
entity.LimitedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitedDate"]);
entity.LastLoginDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLoginDate"]);
entity.LastPasswordChangedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]);
entity.FailedPasswordAttemptCount = SqlTypeConverter.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]);
entity.FailedPasswordDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["FailedPasswordDate"]);
entity.IsLockedOut = SqlTypeConverter.DBNullBooleanHandler(rdr["IsLockedOut"]);
entity.LastLockoutDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLockoutDate"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.EmployeeId = SqlTypeConverter.DBNullStringHandler(rdr["EmployeeId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return entities;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmission_Click(object sender, EventArgs e)
{
M_TaskInfo ti = new M_TaskInfo();
ti.TaskName = this.TbTaskName.Text.Trim();
int dd = int.Parse(this.DdlDID.SelectedValue.ToString());
U_Department dt = new U_Department();
dt.DID = dd;
dt.DName = this.DdlDID.Text.ToString();
ti.DID = dt;
ti.ReleaseTime = DateTime.Now.ToLocalTime();
ti.Content = this.TbContent.Text.ToString();
ti.Remark = this.TbRemark.Text.Trim();
if (string.IsNullOrEmpty(this.TbTaskName.Text) || string.IsNullOrEmpty(this.TbContent.Text))
{
JsMessage.jsAlert("任务信息不能为空!");
return;
}
if (new ManageBll().AddTaskInfo(ti) > 0)
{
JsMessage.jsAlert("添加成功");
use = (U_User)Session["U_USER"];
Model.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.TbTaskName.Text = "";
this.TbContent.Text = "";
this.TbRemark.Text = "";
bind();
}
}
/// <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;
}
}
public ResultModel <object> ModifyUserName(U_User user)
{
bool flag = false;
ResultModel <object> msg = new ResultModel <object>();
flag = GetUserByName(user.UserName);
if (flag)
{
msg.Code = 2001;
msg.Message = "用户名已占用";
return(msg);
}
var result = new U_UserDAL().ModifyUserName(user);
if (result > 0)
{
msg.Message = "修改成功";
return(msg);
}
else
{
msg.Code = 2001;
msg.Message = "修改失败";
return(msg);
}
}
/// <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);
}
}
//U_Department de = new U_Department();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
use = (U_User)Session["U_USER"];
int did = use.DID.DID;
bindRepLeave(did);
}
}
/// <summary>
/// 确认提交信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmission_Click(object sender, EventArgs e)
{
U_Resignation re = new U_Resignation();
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text))
{
JsMessage.jsAlert("辞职信息不能为空！");
return;
}
use = (U_User)Session["U_USER"];
int i = use.UID;
int dp = use.DID.DID;
U_User u = new U_User();
u.UID = i;
re.UID = u;
U_Department d = new U_Department();
d.DID = dp;
re.DID = d;
re.Reason = this.TbReason.Text.ToString();
re.Time = Convert.ToDateTime(this.TbTime.Text.ToString());
re.Remark = this.TbRemark.Text.Trim();
re.State = "null";
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text))
{
JsMessage.jsAlert("辞职信息不能为空！");
return;
}
DataTable r = new HrBll().H_SelResignations(i);
//U_User us = new U_User();
//us.UID=
//int uid = r.UID.UID;
if (r.Rows.Count == 1)
{
JsMessage.jsAlert("你已经发送过辞职信息了,不能反复发送！");
return;
}
if (new UserBll().U_AddResigntion(re) > 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);
return;
}
//清空所有信息
this.TbReason.Text = "";
this.TbRemark.Text = "";
this.TbTime.Text = "";
}
/// <summary>
/// 位部门类型赋值
/// </summary>
public void bind()
{
use = (U_User)Session["U_USER"];
this.LbUserName.Text = use.UserName;
this.LbDid.Text = use.DID.DName.ToString();
//this.DdlDepartment.DataSource = new UserBll().U_SelDepartment();
//this.DdlDepartment.DataTextField = "DName";
//this.DdlDepartment.DataValueField = "DID";
//this.DdlDepartment.DataBind();
}
/// <summary>
/// 查询事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSearch_Click(object sender, EventArgs e)
{
use = (U_User)Session["U_USER"];
int uid = use.UID;
string month = this.ipTime.Value.ToString();
//string mmmm =Convert.ToDateTime( month).ToString("yyyy-MM");
this.repBind.DataSource = new ManageBll().getSalaryInfo(uid, month);
this.repBind.DataBind();
}
public EnmChangeResults ChangePassword(U_User user, String oPwd, String nPwd)
{
if (!CheckPassword(oPwd, user.PasswordFormat, user.PasswordSalt, user.Password))
{
return(EnmChangeResults.WrongPassword);
}
user.PasswordSalt = _repository.GenerateSalt();
user.Password = _repository.EncodePassword(nPwd, user.PasswordFormat, user.PasswordSalt);
_repository.ChangePassword(user.Id, user.Password, user.PasswordFormat, user.PasswordSalt);
return(EnmChangeResults.Successful);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
use = (U_User)Session["U_USER"];
///klksdjiasjfijaifjaijiofjaj
int UID = use.UID;
repBindAttendDate(UID);
repbindLeaveDate(UID);
}
}
/// <summary>
/// 修改用户名
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int ModifyUserName(U_User user)
{
string sql = @"UPDATE dbo.[User]
SET UserName = @UserName
WHERE UserCode = @UserCode
AND IsDel = 0";
using (var conn = AdoConfig.GetDBConnection())
{
return(conn.Execute(sql, 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="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);
}
public ActionResult Edit([Bind(Exclude = "UserPhoto")] U_User user, HttpPostedFileBase UserPhoto, string ConfirmPassword)
{
string s = HttpUtility.HtmlDecode(Request.Cookies["account"].Value);
var v = db.U_User.Where(x => x.UserAccount == s).FirstOrDefault();
if (user.UserAccount != v.UserAccount)
{
return(Content("<script language='javascript' type='text/javascript'>alert('帳戶錯誤，請勿更改網址!');history.go(-1);</script>"));
}
else if (ModelState.IsValid)
{
if (user.UserPassword != ConfirmPassword)
{
return(Content("<script language='javascript' type='text/javascript'>alert('確認密碼不正確，請重新輸入!');history.go(-1);</script>"));
}
else
{
U_User u = repository.GetById(v.UserID);
u.UserName = user.UserName;
u.UserPassword = user.UserPassword;
u.Gender = user.Gender;
u.Email = user.Email;
u.Phone = user.Phone;
u.Address = user.Address;
u.Birth = user.Birth;
if (UserPhoto != null)
{
byte[] imageByte = null;
BinaryReader reader = new BinaryReader(UserPhoto.InputStream);
imageByte = reader.ReadBytes((int)UserPhoto.ContentLength);
u.UserPhoto = imageByte;
repository.Update(u);
Response.Cookies["login"].Value = HttpUtility.UrlEncode(u.UserName);
return(RedirectToAction("Account"));
}
else
{
u.UserPhoto = v.UserPhoto;
repository.Update(u);
Response.Cookies["login"].Value = HttpUtility.UrlEncode(u.UserName);
return(RedirectToAction("Account"));
}
}
}
return(View(user));
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int ResetUserPassword(U_User user)
{
string sql = @"UPDATE dbo.[User]
SET PassWord = @PassWord ,
ModDate = GETDATE()
WHERE E_Mail = @E_Mail
AND IsDel = 0";
using (var conn = AdoConfig.GetDBConnection())
{
return(conn.Execute(sql, user));
}
}
public HttpResponseMessage CheckUserName([FromBody] U_User user)
{
int num = UserInfoGetCount(user.UserName);//查询是否存在该用户
if (num <= 0)
{
return(tool.MsgFormat(ResponseCode.操作失败, "不可注册/用户已注册", "1 " + user.UserName));
}
else
{
return(tool.MsgFormat(ResponseCode.成功, "可注册", "0 " + user.UserName));
}
}
/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
use = (U_User)Session["U_USER"];
if ((U_User)Session["U_USER"] == null)
{
Response.Redirect("../M_UserLogin.aspx");
}
bind();
UPD();
Education();
}
}
public void Add(U_User user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
user.PasswordFormat = _passwordFormat;
user.PasswordSalt = _repository.GenerateSalt();
user.Password = _repository.EncodePassword(user.Password, user.PasswordFormat, user.PasswordSalt);
_repository.Insert(new List <U_User> {
user
});
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
use = (U_User)Session["U_USER"];
if ((U_User)Session["U_USER"] == null)
{
Response.Redirect("M_UserLogin.aspx");
}
///查询 需提供tid
int u = int.Parse(Request.QueryString["TID"]);
BindInfo(u);
}
}
