private void btnOK_Click(object sender, EventArgs e) { try { if (!cmn.Confirm("确定交班?")) { return; } SysUserInfoModel mUser=new SysUserInfoModel (); mUser.UserId=int.Parse(cboUser.SelectedValue.ToString()); mUser.UserPassWord=txtPsw.Text; if (bUser.CheckUserInfo(mUser)) { mHandOver.CurrentUserInfo.UserId = UserInfo.UserId; mHandOver.NextUserInfo.UserId = int.Parse(cboUser.SelectedValue.ToString()); mHandOver.HandInMoney = double.Parse(cmn.CheckIsDouble(txtHandIn, "上交金额").ToString("0.00")); mHandOver.ToNextMoney = double.Parse(lblToNext.Text); mHandOver.CommonInfo.CreateUserId = UserInfo.UserId; if (bHandOver.InsertHandOver(mHandOver) > 0) { UserInfo = bUser.GetUserInfo(mUser); this.DialogResult = DialogResult.OK; this.Close(); } } else { throw new Exception("密码验证错误!"); } } catch (Exception err) { cmn.Show(err.Message); } }
private void btnLogin_Click(object sender, EventArgs e) { try { if (!CheckFormInfo()) { lblMsg.Text = "登陆信息不完整"; } else { SysUserInfo bUser = new SysUserInfo(); mUserInfo=bUser.GetUserInfo(mUserInfo); if (mUserInfo != null) { BaseForm.UserInfo = mUserInfo; this.DialogResult = DialogResult.OK; this.Close(); } else { throw new Exception("密码验证失败"); } } } catch (Exception err) { lblMsg.Text = err.Message; } }
/// <summary> /// 验证用户密码 /// </summary> /// <param name="mUserInfo"></param> /// <returns></returns> public bool CheckUserInfo(SysUserInfoModel mUserInfo) { mUserInfo.UserPassWord = MyMD5.MD5Encrypt(mUserInfo.UserPassWord, "INDEXSFT"); mUserInfo = GetUserInfo(mUserInfo); if (mUserInfo != null) { return true; } return false; }
private bool CheckFormInfo() { if (string.IsNullOrEmpty(txtUserNo.Text.Trim()) || string.IsNullOrEmpty(txtPsw.Text)) { return false; } else { mUserInfo = new SysUserInfoModel(); mUserInfo.UserNo = txtUserNo.Text.Trim().ToUpper(); mUserInfo.UserPassWord = txtPsw.Text.MD5Encrypt("INDEXSFT"); } return true; }
private void btnOK_Click(object sender, EventArgs e) { try { if (UserInfo.UserId > 0) { if (string.IsNullOrEmpty(txtOldPsw.Text) || string.IsNullOrEmpty(txtNewPsw.Text) || string.IsNullOrEmpty(txtCfmPsw.Text)) { throw new Exception("信息不完整"); } if (txtNewPsw.Text != txtCfmPsw.Text) { throw new Exception("密码不一致"); } SysUserInfoModel mUser = new SysUserInfoModel(); mUser.UserId = UserInfo.UserId; mUser.UserNo = UserInfo.UserNo; mUser.UserPassWord = txtOldPsw.Text; if (bUser.CheckUserInfo(mUser)) { if (!cmn.Confirm("确定修改密码?你的新密码为" + txtNewPsw.Text)) { return; } mUser.NewPsw = MyMD5.MD5Encrypt(txtNewPsw.Text, "INDEXSFT"); if (bUser.UpdateUserInfo(mUser, new ObjectControls(MCtrl.SetPsw)) > 0) { cmn.Show("密码修改成功."); } else { cmn.Show("发生未知错误,密码修改失败."); } this.Close(); } else { throw new Exception("密码不正确"); } } } catch (Exception err) { lblMsg.Text = err.Message; } }
/// <summary> /// 获取用户验证信息 /// </summary> /// <param name="mUserInfo"></param> /// <returns></returns> public SysUserInfoModel GetUserInfo(SysUserInfoModel mUserInfo) { var query = from c in Dc.SYS_USER_INFO where (c.USER_NO == mUserInfo.UserNo && c.PASSWORD == mUserInfo.UserPassWord) || (c.USER_ID == mUserInfo.UserId && c.PASSWORD == mUserInfo.UserPassWord) join d in Dc.SYS_ROLE_INFO on c.ROLE_ID equals d.ROLE_ID select new { user = c, roleName = d.ROLE_NAME }; Log.WriteLog(Dc, query, AbBaseBll.IsWriteSql); SysUserInfoModel mUserInfoNew = new SysUserInfoModel(); if (query.Count() > 0) { mUserInfoNew.UserId = query.First().user.USER_ID; mUserInfoNew.UserName = query.First().user.USER_NAME; mUserInfoNew.UserNo = query.First().user.USER_NO; mUserInfoNew.Status = query.First().user.STATUS; mUserInfoNew.SkinId = query.First().user.SKIN_ID == null ? 0 : int.Parse(query.First().user.SKIN_ID.ToString()); mUserInfoNew.RoleInfo = new SysRoleModel(); mUserInfoNew.RoleInfo.RoleId = query.First().user.ROLE_ID; mUserInfoNew.RoleInfo.RoleName = query.First().roleName; return mUserInfoNew; } return null; }
private void btnUnLock_Click(object sender, EventArgs e) { try { SysUserInfoModel mUser = new SysUserInfoModel(); mUser.UserId = UserInfo.UserId; mUser.UserPassWord = txtPsw.Text; if (bUser.CheckUserInfo(mUser)) { this.DialogResult = DialogResult.OK; this.Close(); } else { throw new Exception("密码错误!"); } } catch (Exception err) { lblMsg.Text = err.Message; } }
/// <summary> /// 换房逻辑,换房只能从一个已入住房间换到状态为可用的房间. /// </summary> /// <param name="mCustomerStay">入住信息</param> /// <param name="mNewRoomInfo">新房信息</param> /// <param name="dNewRoomRate">新房费用</param> /// <param name="mUserInfo">系统用户信息</param> /// <param name="listSysParameter">系统参数</param> public void ChangeRoom(CustomerStayModel mCustomerStay, BasRoomModel mNewRoomInfo,double dNewRoomRate, SysUserInfoModel mUserInfo, List<SysParameterModel> listSysParameter) { try { #region 将之前房间费用(光房间费用)加入到消费清单中. ConsumeDetailModel mConsume = new ConsumeDetailModel(); BasGoodsModel mGoods = new BasGoodsModel(); mGoods.Type = 'R'; List<BasGoodsModel> listGoods = bGoods.GetGoodsInfo(mGoods, new ObjectControls(MCtrl.ByGoodsType)); if (Cmn.CheckEOF(listGoods)) { mConsume.GoodsId = listGoods[0].GoodsId; } else { throw new Exception("未定义类型的R的商品,该类型为房间费."); } mConsume.StayId = mCustomerStay.StayId; mConsume.UnitPrice = mCustomerStay.RoomRate; RoomStayType eRst = mCustomerStay.RoomStayType == 'D' ? RoomStayType.Day : RoomStayType.Hour; DateTime dtNow = Cmn.DateBaseDate; mConsume.Number = GetCustomerStayDays(mCustomerStay.CommonInfo.StartDate, dtNow,dtNow, eRst, listSysParameter); mConsume.Total = GetTotalRates(mCustomerStay, null, listSysParameter, dtNow, 0.0); mConsume.CommonInfo = new CommonModel(); mConsume.CommonInfo.CreateDate = mCustomerStay.CommonInfo.StartDate; mConsume.CommonInfo.CreateUserId = mUserInfo.UserId; mConsume.CommonInfo.UpdateUserId = mUserInfo.UserId; bConsume.InsertConsumeDetail(mConsume); #endregion #region 是否团队房间 if (mCustomerStay.MainRoomId == mCustomerStay.RoomId) { if (Cmn.Confirm(string.Format("{0}为主房间,变更后{1}将成为主房间,是否继续?", mCustomerStay.RoomInfo.RoomNo, mNewRoomInfo.RoomNo))) { #region 将团队房间的MainRoomId变为新ID List<BasRoomModel> listTeamRoom = GetTeamRoomListByRoomId(mCustomerStay.RoomInfo, 'I'); if (Cmn.CheckEOF(listTeamRoom)) { ObjectControls oCtrl = new ObjectControls(); oCtrl.Add(MCtrl.SetMainRoomId); foreach (BasRoomModel mRoom in listTeamRoom) { CustomerStayModel mCs = new CustomerStayModel(); mCs.RoomId = mRoom.RoomId; mCs.Status = 'I'; ObjectControls oc = new ObjectControls(); oc.Add(MCtrl.ByStayStatus); oc.Add(MCtrl.ByRoomId); mCs = bCustomerStay.GetCustomerStayInfo(mCs, oc); if (mCs != null) { mCs.MainRoomId = mNewRoomInfo.RoomId; bCustomerStay.UpdateCustomerStay(mCs, oCtrl); } } } #endregion } } #endregion #region 将原来房间置为清理,将新房间设置为入住 ObjectControls oCtrlMain = new ObjectControls(); oCtrlMain.Add(MCtrl.SetRoomId); oCtrlMain.Add(MCtrl.SetStartDate); oCtrlMain.Add(MCtrl.SetHours); oCtrlMain.Add(MCtrl.SetRoomRate); mCustomerStay.RoomId = mNewRoomInfo.RoomId; mCustomerStay.CommonInfo.StartDate = Cmn.DateBaseDate; double dDays = GetCustomerStayDays(mCustomerStay.CommonInfo.StartDate, mCustomerStay.CommonInfo.EndDate,mCustomerStay.CommonInfo.StartDate, eRst, listSysParameter); mCustomerStay.Hours = eRst == RoomStayType.Day ? Convert.ToInt32(dDays * 24) : Convert.ToInt32(dDays); mCustomerStay.RoomRate = dNewRoomRate; bCustomerStay.UpdateCustomerStay(mCustomerStay, oCtrlMain); mNewRoomInfo.Status = mCustomerStay.RoomInfo.Status; UpdateRoomStatusByRoomId(mNewRoomInfo, mUserInfo); mCustomerStay.RoomInfo.Status = 'C'; UpdateRoomStatusByRoomId(mCustomerStay.RoomInfo, mUserInfo); #endregion } catch (Exception err) { throw err; } }
public void UpdateSingleRoomToTeamRoom(CustomerStayModel mCustomerStay,int nMainRoomId,int nTeamMainCustomerId,SysUserInfoModel mUserInfo) { try { mCustomerStay.MainRoomId = nMainRoomId; bCustomerStay.UpdateCustomerStay(mCustomerStay, new ObjectControls(MCtrl.SetMainRoomId)); CustomerStayHisModel mHis = new CustomerStayHisModel(); mHis.StayId = mCustomerStay.StayId; if (mCustomerStay.CustomerList[0].CustomerId > 0) { if (mCustomerStay.CustomerList.Where(c => c.CustomerId == nTeamMainCustomerId).Count() == 0) { mHis.HisId = mCustomerStay.CustomerList[0].CustomerStayHisInfo.HisId; mHis.StayType = 'S'; mHis.CommonInfo = new CommonModel(); mHis.CommonInfo.UpdateUserId = mUserInfo.UserId; bCustomerStay.UpdateStayHis(mHis, new ObjectControls(MCtrl.SetHisType)); mHis.StayType = 'M'; mHis.HisStatus = 'E'; mHis.CustomerId = nTeamMainCustomerId; mHis.CommonInfo = new CommonModel(); mHis.CommonInfo.CreateUserId = mUserInfo.UserId; mHis.CommonInfo.UpdateUserId = mUserInfo.UserId; bCustomerStay.InsertCustomerStayHis(mHis); } } else { mHis.StayType = 'M'; mHis.HisStatus = 'E'; mHis.CustomerId = nTeamMainCustomerId; mHis.CommonInfo = new CommonModel(); mHis.CommonInfo.CreateUserId = mUserInfo.UserId; mHis.CommonInfo.UpdateUserId = mUserInfo.UserId; bCustomerStay.InsertCustomerStayHis(mHis); } } catch (Exception err) { throw err; } }
/// <summary> /// 修改房态 ById /// </summary> /// <param name="mRoom"></param> public void UpdateRoomStatusByRoomId(BasRoomModel mRoom,SysUserInfoModel mUserInfo) { mRoom.CommonInfo.UpdateUserId = mUserInfo.UserId; bRoom.UpdateRoomInfo(mRoom, new ObjectControls(MCtrl.SetRoomStatus)); }
/// <summary> /// 获取系统用户列表 /// </summary> /// <returns></returns> public List<SysUserInfoModel> GetUserInfoList() { var query = from c in Dc.SYS_USER_INFO join d in Dc.SYS_ROLE_INFO on c.ROLE_ID equals d.ROLE_ID select new { user = c, roleName = d.ROLE_NAME,roleId=d.ROLE_ID }; Log.WriteLog(Dc, query, AbBaseBll.IsWriteSql); List<SysUserInfoModel> listUserInfo = new List<SysUserInfoModel>(); foreach (var value in query) { SysUserInfoModel mUserInfoNew = new SysUserInfoModel(); mUserInfoNew.UserId = value.user.USER_ID; mUserInfoNew.UserName = value.user.USER_NAME; mUserInfoNew.UserNo = value.user.USER_NO; mUserInfoNew.UserPassWord = MyMD5.MD5Decrypt(value.user.PASSWORD, "INDEXSFT"); mUserInfoNew.SkinId = value.user.SKIN_ID == null ? 0 : int.Parse(value.user.SKIN_ID.ToString()); mUserInfoNew.RoleInfo = new SysRoleModel(); mUserInfoNew.RoleInfo.RoleId = value.roleId; mUserInfoNew.RoleInfo.RoleName = value.roleName; listUserInfo.Add(mUserInfoNew); } return listUserInfo; }
public void DeleteUserInfo(SysUserInfoModel mUser) { Dc.SYS_USER_INFO.DeleteAllOnSubmit(Dc.SYS_USER_INFO.Where(c => c.USER_ID == mUser.UserId)); Dc.SubmitChanges(); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="mUser"></param> /// <param name="oCtrl"></param> /// <returns></returns> public int UpdateUserInfo(SysUserInfoModel mUser, ObjectControls oCtrl) { SYS_USER_INFO sui = new SYS_USER_INFO(); var query = Dc.SYS_USER_INFO.Where(c => c.USER_ID == mUser.UserId); if (query.Count() > 0) { sui = query.First(); if (oCtrl.Exsit(MCtrl.SetPsw)) { sui.PASSWORD = mUser.NewPsw; } if (oCtrl.Exsit(MCtrl.SetUserName)) { sui.USER_NAME = mUser.UserName; } if (oCtrl.Exsit(MCtrl.SetUserNo)) { sui.USER_NO = mUser.UserNo; } if (oCtrl.Exsit(MCtrl.SetRoleId)) { sui.ROLE_ID = mUser.RoleInfo.RoleId; } if (oCtrl.Exsit(MCtrl.SetSkinId)) { sui.SKIN_ID = mUser.SkinId; } sui.UPDATE_DATE = Cmn.DateBaseDate; sui.UPDATE_USERID = mUser.UserId; Dc.SubmitChanges(); return sui.USER_ID; } return -1; }
public int InsertUserInfo(SysUserInfoModel mUser) { SYS_USER_INFO sui = new SYS_USER_INFO { USER_NO = mUser.UserNo, STATUS = 'E', CREATE_DATE = Cmn.DateBaseDate, CREATE_USERID = mUser.CommonInfo.CreateUserId, UPDATE_DATE = Cmn.DateBaseDate, ROLE_ID = mUser.RoleInfo.RoleId, PASSWORD = mUser.UserPassWord, USER_NAME = mUser.UserName, SKIN_ID=mUser.SkinId, UPDATE_USERID = mUser.CommonInfo.CreateUserId }; Dc.SYS_USER_INFO.InsertOnSubmit(sui); Dc.SubmitChanges(); return sui.USER_ID; }
private void btnUserSave_Click(object sender, EventArgs e) { try { CheckTextValue(new Object[] { txtUserName, txtUserNo,txtPsw }); if (UserInfo.UserNo == txtUserNo.Text) { cmn.Show("不能修改自己的信息.\r如需修改,请用其他管理员账号登陆\r如无其他管理员账号,请新增管理员之后,再进行修改."); return; } if (!cmn.Confirm("保存用户信息?")) { return; } if (cboRole.SelectedIndex == 0 && !cmn.Confirm("您选择的是管理员角色,该角色能够修改系统设置\r权利较大,请慎重添加\r是否继续?")) { return; } int nUserId = 0; if (txtUserName.Tag != null && txtUserName.Tag.ToString() != "") { nUserId = Convert.ToInt32(txtUserName.Tag); } var query = listUser.Where(c => c.UserId == nUserId); if (query.Count() > 0) { oCtrl.Reset(); oCtrl.Add(MCtrl.SetUserNo); oCtrl.Add(MCtrl.SetUserName); oCtrl.Add(MCtrl.SetRoleId); oCtrl.Add(MCtrl.SetPsw); SysUserInfoModel mUser = new SysUserInfoModel(); mUser.UserNo = txtUserNo.Text; mUser.UserName = txtUserName.Text; mUser.NewPsw = MyMD5.MD5Encrypt(txtPsw.Text, "INDEXSFT"); mUser.RoleInfo.RoleId = int.Parse(cboRole.SelectedValue.ToString()); mUser.UserId = query.First().UserId; bUser.UpdateUserInfo(mUser, oCtrl); } else { query = listUser.Where(c => c.UserNo == txtUserNo.Text); if (query.Count() > 0) { cmn.Show("该用户编号已经存在,无法新增!"); return; } SysUserInfoModel mUser = new SysUserInfoModel(); mUser.UserNo = txtUserNo.Text; mUser.UserName = txtUserName.Text; mUser.UserPassWord = MyMD5.MD5Encrypt(txtPsw.Text, "INDEXSFT"); mUser.RoleInfo.RoleId = int.Parse(cboRole.SelectedValue.ToString()); mUser.CommonInfo.CreateUserId = UserInfo.UserId; mUser.CommonInfo.UpdateUserId = UserInfo.UserId; bUser.InsertUserInfo(mUser); } BindUserList(); tslblStatus.Text = "保存完毕"; txtUserNo.Text = ""; txtUserName.Text = ""; txtUserName.Tag = ""; txtPsw.Text = ""; } catch (Exception err) { tslblStatus.Text = err.Message; } }