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;
}
}
