private void btnCheckIn_Click(object sender, EventArgs e)
{
if (CheckInupt())
{
if (new CustoService().SelectCardInfoByCustoNo(txtCustoNo.Text) != null)
{
using (TransactionScope scope = new TransactionScope())
{
Room r = new Room()
{
CheckTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
CustoNo = txtCustoNo.Text,
RoomStateId = 1,
RoomNo = txtRoomNo.Text,
datachg_usr = LoginInfo.WorkerNo,
datachg_date = DateTime.Now,
};
bool n = new RoomService().UpdateRoomInfo(r);
if (n == true)
{
MessageBox.Show("登记入住成功！", "登记提示");
txtCustoNo.Text = "";
FrmRoomManager.Reload();
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName + "于" + DateTime.Now + "帮助" + r.CustoNo + "进行了入住操作！";
o.OperationAccount = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
#endregion
new OperationlogService().InsertOperationLog(o);
scope.Complete();
this.Close();
}
else
{
MessageBox.Show("登记入住失败！", "登记提示");
}
}
}
else
{
MessageBox.Show("客户编号不存在！", "来自小T的提示");
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (cboState.SelectedIndex != 1)
{
if (RoomManager.UpdateRoomStateByRoomNo(txtRoomNo.Text, cboState.SelectedIndex) > 0)
{
MessageBox.Show("房间" + txtRoomNo.Text + "成功修改为" + cboState.Text, "修改提示");
FrmRoomManager.Reload();
this.Close();
}
else
{
MessageBox.Show("修改失败", "来自小T的提示");
}
}
else
{
MessageBox.Show("不能设置已住状态", "来自小T的提示");
}
}
private void btnCheckIn_Click(object sender, EventArgs e)
{
if (CheckInupt())
{
if (CustoManager.SelectCustoByCustoNo(txtCustoNo.Text) != null)
{
Room r = new Room();
r.CheckTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
r.CustoNo = txtCustoNo.Text;
r.PersonNum = txtPersonNum.Text;
r.RoomStateId = 1;
r.RoomNo = txtRoomNo.Text;
int n = RoomManager.UpdateRoomInfo(r);
if (n > 0)
{
MessageBox.Show("登记入住成功！", "登记提示");
//SpendManager.InsertSpendInfo(s);
txtCustoNo.Text = "";
FrmRoomManager.Reload();
this.Close();
#region 获取添加操作日志所需的信息
Operation o = new Operation();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName + "于" + DateTime.Now + "帮助" + r.CustoNo + "进行了入住操作！";
o.OperationAccount = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName;
#endregion
OperationManager.InsertOperationLog(o);
}
else
{
MessageBox.Show("登记入住失败！", "登记提示");
}
}
else
{
MessageBox.Show("客户编号不存在！", "来自小T的提示");
}
}
}
private void btnChangeRoom_Click(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
double sum = 0;
string lbu = LoginInfo.WorkerName;
string rno = ucRoomList.RoomNo.ToString();
string nrno = cboRoomList.Text;
Room checkInRoom = new Room()
{
RoomNo = nrno,
CustoNo = ucRoomList.CustoNo,
RoomStateId = 1,
CheckTime = DateTime.Now,
datains_usr = LoginInfo.WorkerNo,
datains_date = DateTime.Now
};
if (rno.Contains("BD"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 300);
}
if (rno.Contains("BS"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 425);
}
if (rno.Contains("HD"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 625);
}
if (rno.Contains("HS"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 660);
}
if (rno.Contains("QL"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 845);
}
if (rno.Contains("ZT"))
{
sum = Convert.ToDouble(Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) * 1080);
//sum = Convert.ToDouble(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 1080);
}
Spend s = new Spend()
{
RoomNo = cboRoomList.Text,
SpendName = "居住" + rno + "共" + Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()) + "天",
SpendAmount = Convert.ToInt32(new RoomService().DayByRoomNo(rno).ToString()),
CustoNo = ucRoomList.CustoNo,
SpendPrice = Convert.ToDecimal(sum),
SpendMoney = Convert.ToDecimal(sum),
SpendTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
MoneyState = "未结算",
};
bool result1 = new RoomService().UpdateRoomInfo(checkInRoom);
bool result2 = new RoomService().UpdateRoomByRoomNo(rno);
var result3 = new SpendService().SelectSpendByCustoNo(rno);
if (result3.Count != 0)
{
bool result4 = new SpendService().UpdateSpendInfoByRoomNo(result3, nrno, ucRoomList.CustoNo);
}
if (result1 == true && result2 == true)
{
MessageBox.Show("转房成功");
bool m = new SpendService().InsertSpendInfo(s);
FrmRoomManager.Reload();
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = ucRoomList.CustoNo + "于" + DateTime.Now + "进行了换房，请记得到后台修改消费价格！";
o.OperationAccount = LoginInfo.WorkerNo;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
#endregion
new OperationlogService().InsertOperationLog(o);
scope.Complete();
this.Close();
}
else
{
MessageBox.Show("转房失败");
}
}
}
private void btnChangeRoom_Click(object sender, EventArgs e)
{
double sum = 0;
string lbu = LoginInfo.WorkerName;
string cno = ucRoomList.CustoNo;
string rno = ucRoomList.RoomNo;
string rte = ucRoomList.RoomState;
string rct = ucRoomList.co_CheckTime;
string rpm = ucRoomList.co_PersonNum;
string nrno = cboRoomList.Text;
string sql1 = string.Format("update ROOM set RoomStateId='3',CustoNo=null,CheckTime=null,PersonNum=null where RoomNo='{0}'", rno);
string sql2 = string.Format("update ROOM set RoomStateId='1',CustoNo='{0}',CheckTime='{1}',CheckOutTime=null,PersonNum='{2}' where RoomNo='{3}'", cno, rct, rpm, nrno);
if (rno.Contains("BD"))
{
sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 300));
}
if (rno.Contains("BS"))
{
sum = Convert.ToDouble(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 425);
}
if (rno.Contains("HD"))
{
sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 625));
}
if (rno.Contains("HS"))
{
sum = Convert.ToDouble(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 660);
}
if (rno.Contains("QL"))
{
sum = Convert.ToDouble(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 845);
}
if (rno.Contains("ZT"))
{
sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 1080));
//sum = Convert.ToDouble(Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) * 1080);
}
Spend s = new Spend()
{
RoomNo = cboRoomList.Text,
SpendName = "居住" + rno + Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()) + "天",
SpendAmount = Convert.ToInt32(RoomManager.DayByRoomNo(rno).ToString()),
CustoNo = cno,
SpendPrice = Convert.ToDecimal(sum),
SpendMoney = Convert.ToDecimal(sum),
SpendTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
MoneyState = "未结算",
};
if (DBHelper.ExecuteNonQuery(sql1) > 0 && DBHelper.ExecuteNonQuery(sql2) > 0)
{
MessageBox.Show("转房成功");
int m = SpendManager.InsertSpendInfo(s);
FrmRoomManager.Reload();
#region 获取添加操作日志所需的信息
Operation o = new Operation();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = cno + "于" + DateTime.Now + "进行了换房，请记得到后台修改消费价格！";
o.OperationAccount = lbu;
#endregion
OperationManager.InsertOperationLog(o);
this.Close();
}
else
{
MessageBox.Show("转房失败");
}
}
private void btnBalance_Click(object sender, EventArgs e)
{
if (txtReceipts.Text != "") //判断实收金额是否为空
{
Room r = new RoomService().SelectRoomByRoomNo(txtRoomNo.Text); //根据房间编号查询房间信息
string checktime = r.CheckTime.ToString(); //获取入住时间
if (dgvSpendList.Rows.Count == 0)
{
bool n = new RoomService().UpdateRoomByRoomNo(txtRoomNo.Text);
if (n == true)
{
new WtiService().InsertWtiInfo(w);//添加水电费信息
this.Close();
}
else
{
return;
}
MessageBox.Show("结算成功！", "系统提示");
FrmRoomManager.Reload();
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName + "于" + DateTime.Now + "帮助" + txtCustoNo.Text + "进行了退房结算操作！";
o.OperationAccount = LoginInfo.WorkerNo;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
#endregion
new OperationlogService().InsertOperationLog(o);
}
else
{
if (new SpendService().UpdateMoneyState(txtRoomNo.Text, checktime) == true)
{
bool n = new RoomService().UpdateRoomByRoomNo(txtRoomNo.Text);
if (n == true)
{
new WtiService().InsertWtiInfo(w);//添加水电费信息
this.Close();
}
else
{
return;
}
MessageBox.Show("结算成功！", "系统提示");
FrmRoomManager.Reload();
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName + "于" + DateTime.Now + "帮助" + txtCustoNo.Text + "进行了退房结算操作！";
o.OperationAccount = LoginInfo.WorkerNo;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
#endregion
new OperationlogService().InsertOperationLog(o);
}
else
{
MessageBox.Show("结算失败！", "系统提示");
}
}
}
else
{
MessageBox.Show("实收金额不能为空！", "系统提示");
}
}