private void btnBalance_Click(object sender, EventArgs e) { if (txtReceipts.Text != "") //判断实收金额是否为空 { Room r = RoomManager.SelectRoomByRoomNo(txtRoomNo.Text); //根据房间编号查询房间信息 string checktime = r.CheckTime.ToString(); //获取入住时间 if (SpendManager.UpdateMoneyState(txtRoomNo.Text, checktime) > 0) { int n = RoomManager.UpdateRoomByRoomNo(txtRoomNo.Text); if (n > 0) { WtiManager.InsertWtiInfo(w);//添加水电费信息 this.Close(); } else { return; } MessageBox.Show("结算成功!", "系统提示"); } else { MessageBox.Show("结算失败!", "系统提示"); } } else { MessageBox.Show("实收金额不能为空!", "系统提示"); } }
private void btnCheckIn_Click(object sender, EventArgs e) { if (CheckInupt()) { #region 获取添加消费信息所需的信息 Spend s = new Spend(); s.RoomNo = txtRoomNo.Text; s.CustoNo = txtCustoNo.Text; s.SpendName = "住房"; s.SpendAmount = Convert.ToInt32(txtCheckNum.Text); s.SpendPrice = Convert.ToDecimal(txtMoney.Text); s.SpendMoney = Convert.ToDecimal(Convert.ToDouble(txtMoney.Text)); s.SpendTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); s.MoneyState = "未结算"; #endregion 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 = ""; 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 btnAdd_Click(object sender, EventArgs e) { if (rs == 1)//判断房间编号是否可消费 { if (CheckInput()) { SellThing st = SellThingManager.SelectSellThingByNo(txtSellNo.Text); Room r = RoomManager.SelectRoomByRoomNo(txtRoomNo.Text); Spend s = new Spend() { RoomNo = txtRoomNo.Text, SpendName = txtSellName.Text, SpendAmount = (int)nudNum.Value, CustoNo = r.CustoNo, SpendPrice = Convert.ToDecimal(txtPrice.Text), SpendMoney = Convert.ToDecimal(txtPrice.Text) * nudNum.Value, SpendTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), MoneyState = "未结算", }; int m = SpendManager.InsertSpendInfo(s); if (m > 0) { MessageBox.Show("添加成功"); string Stock = (st.Stock - nudNum.Value).ToString(); int n = SellThingManager.UpdateSellThing(Stock, st.SellNo); LoadSpendInfo(r.RoomNo); LoadSellThingInfo(); #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 + "帮助" + dgvRoomSell.SelectedRows[0].Cells["CustoNo"].Value.ToString() + "进行了消费商品:" + txtSellName.Text + "操作!"; o.OperationAccount = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName; #endregion OperationManager.InsertOperationLog(o); } else { MessageBox.Show("添加失败"); } } } }
private void LoadSpendInfo(string room) { //List<DataGridViewColumnEntity> lstCulumns = new List<DataGridViewColumnEntity>(); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "RoomNo", HeadText = "房间编号", Width = 15, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "CustoNo", HeadText = "客户编号", Width = 15, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "SpendName", HeadText = "商品名称", Width = 25, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "SpendAmount", HeadText = "数量", Width = 10, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "SpendPrice", HeadText = "商品单价", Width = 15, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "SpendMoney", HeadText = "消费金额", Width = 15, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "SpendTime", HeadText = "消费时间", Width = 50, WidthType = SizeType.Percent }); //lstCulumns.Add(new DataGridViewColumnEntity() { DataField = "MoneyState", HeadText = "结算状态", Width = 15, WidthType = SizeType.Percent }); //this.dgvSellthing.Columns = lstCulumns; //this.dgvSellthing.IsShowCheckBox = false; List <Spend> lstSource = SpendManager.SelectSpendByCustoNo(room); this.dgvRoomSell.DataSource = lstSource; this.dgvRoomSell.AutoGenerateColumns = false; }
private void btnBalance_Click(object sender, EventArgs e) { if (txtReceipts.Text != "") //判断实收金额是否为空 { Room r = RoomManager.SelectRoomByRoomNo(txtRoomNo.Text); //根据房间编号查询房间信息 string checktime = r.CheckTime.ToString(); //获取入住时间 if (SpendManager.UpdateMoneyState(txtRoomNo.Text, checktime) > 0) { int n = RoomManager.UpdateRoomByRoomNo(txtRoomNo.Text); if (n > 0) { WtiManager.InsertWtiInfo(w);//添加水电费信息 this.Close(); } else { return; } MessageBox.Show("结算成功!", "系统提示"); #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 + "帮助" + txtCustoNo.Text + "进行了退房结算操作!"; o.OperationAccount = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName; #endregion OperationManager.InsertOperationLog(o); } else { MessageBox.Show("结算失败!", "系统提示"); } } else { MessageBox.Show("实收金额不能为空!", "系统提示"); } }
private void btnAdd_Click(object sender, EventArgs e) { if (rs == 1)//判断房间编号是否可消费 { if (CheckInput()) { SellThing st = SellThingManager.SelectSellThingByNo(txtSellNo.Text); Room r = RoomManager.SelectRoomByRoomNo(txtRoomNo.Text); Spend s = new Spend() { RoomNo = txtRoomNo.Text, SpendName = txtSellName.Text, SpendAmount = (int)nudNum.Value, CustoNo = r.CustoNo, SpendPrice = Convert.ToDecimal(txtPrice.Text), SpendMoney = Convert.ToDecimal(txtPrice.Text) * nudNum.Value, SpendTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), MoneyState = "未结算", }; int m = SpendManager.InsertSpendInfo(s); if (m > 0) { MessageBox.Show("添加成功"); string Stock = (st.Stock - nudNum.Value).ToString(); int n = SellThingManager.UpdateSellThing(Stock, st.SellNo); LoadSpendInfo(r.RoomNo); LoadSellThingInfo(); } else { MessageBox.Show("添加失败"); } } } }
private void FrmCustoSpend_Load(object sender, EventArgs e) { CmpSetDgv(); dgvSpendList.AutoGenerateColumns = false; dgvSpendList.DataSource = SpendManager.SelectSpendInfoAll(); }
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 FrmCheckOutForm_Load(object sender, EventArgs e) { txtCustoNo.Text = ucRoomList.rm_CustoNo; CustoNo.Text = ucRoomList.rm_CustoNo; txtRoomNo.Text = ucRoomList.rm_RoomNo; CmpSetDgv(); if (ucRoomList.co_CheckTime.ToString() == "0001-01-01 00:00:00") { dtpCheckTime.Value = DateTime.Now; } else { dtpCheckTime.Value = Convert.ToDateTime(ucRoomList.co_CheckTime); } lblDay.Text = Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString())); w = new Wti() { CustoNo = txtCustoNo.Text, EndDate = Convert.ToDateTime(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))), PowerUse = Convert.ToDecimal(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 3 * 1), WaterUse = Convert.ToDecimal(Convert.ToDouble(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 80 * 0.002), RoomNo = txtRoomNo.Text, Record = "admin", UseDate = Convert.ToDateTime(DateTime.Parse(dtpCheckTime.Text)), }; #region 加载客户信息 Custo cto = CustoManager.SelectCustoByCustoNo(CustoNo.Text.ToString()); try { CustoName.Text = cto.CustoName; txtCustoName.Text = cto.CustoName; txtTel.Text = cto.CustoTel; cboCustoSex.Text = cto.CustoSex; cboCustoType.SelectedIndex = cto.CustoType; cboPassportType.SelectedIndex = cto.PassportType; dtpBirth.Value = cto.CustoBirth; txtPassportNum.Text = cto.CustoID; } catch { } #endregion #region 加载消费信息 string RoomNo = txtRoomNo.Text; dgvSpendList.DataSource = SpendManager.SelectSpendInfoRoomNo(RoomNo); dgvSpendList.AutoGenerateColumns = false; lblGetReceipts.Text = SpendManager.SelectMoneyByRoomNoAndTime(RoomNo).ToString(); #endregion if (cboCustoType.Text == "钻石会员") { double m = Convert.ToDouble(Convert.ToDouble(lblGetReceipts.Text)); lblVIPPrice.Text = Convert.ToString(Convert.ToDouble(m * 0.60)); lblVIP.Text = "六折"; } else if (cboCustoType.Text == "白金会员") { double m = Convert.ToDouble(Convert.ToDouble(lblGetReceipts.Text)); lblVIPPrice.Text = Convert.ToString(Convert.ToDouble(m * 0.80)); lblVIP.Text = "八折"; } else if (cboCustoType.Text == "黄金会员") { double m = Convert.ToDouble(Convert.ToDouble(lblGetReceipts.Text)); lblVIPPrice.Text = Convert.ToString(Convert.ToDouble(m * 0.90)); lblVIP.Text = "九折"; } else if (cboCustoType.Text == "普通会员") { double m = Convert.ToDouble(Convert.ToDouble(lblGetReceipts.Text)); lblVIPPrice.Text = Convert.ToString(Convert.ToDouble(m * 0.95)); lblVIP.Text = "九五折"; } else if (cboCustoType.Text == "普通用户") { double m = Convert.ToDouble(Convert.ToDouble(lblGetReceipts.Text)); lblVIPPrice.Text = Convert.ToString(Convert.ToDouble(m)); lblVIP.Text = "不 打 折"; } }
public void LoadSpendInfo() { dgvRoomSell.AutoGenerateColumns = false; dgvRoomSell.DataSource = SpendManager.SelectSpendInfoAll(); }
private void LoadSpendInfo(string room) { dgvRoomSell.DataSource = SpendManager.SelectSpendByCustoNo(room); }
private void FrmCheckOutForm_Load(object sender, EventArgs e) { double sum = 0; txtCustoNo.Text = ucRoomList.rm_CustoNo; CustoNo.Text = ucRoomList.rm_CustoNo; txtRoomNo.Text = ucRoomList.rm_RoomNo; string rn = txtRoomNo.Text.ToString(); string rs = rn.Substring(0, 2); CmpSetDgv(); if (ucRoomList.co_CheckTime.ToString() == "0001-01-01 00:00:00") { dtpCheckTime.Value = DateTime.Now; } else { dtpCheckTime.Value = Convert.ToDateTime(ucRoomList.co_CheckTime); } if (rs == "BD") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 300)); } if (rs == "BS") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 425)); } if (rs == "HD") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 625)); } if (rs == "HS") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 660)); } if (rs == "QL") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 845)); } if (rs == "ZT") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 1080)); } lblDay.Text = Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString())); w = new Wti() { CustoNo = txtCustoNo.Text, EndDate = Convert.ToDateTime(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))), PowerUse = Convert.ToDecimal(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 3 * 1), WaterUse = Convert.ToDecimal(Convert.ToDouble(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 80 * 0.002), RoomNo = txtRoomNo.Text, Record = "admin", UseDate = Convert.ToDateTime(DateTime.Parse(dtpCheckTime.Text)), }; #region 加载客户信息 Custo cto = CustoManager.SelectCustoByCustoNo(CustoNo.Text.ToString()); try { CustoName.Text = cto.CustoName; txtCustoName.Text = cto.CustoName; txtTel.Text = cto.CustoTel; cboCustoSex.Text = cto.CustoSex; cboCustoType.SelectedIndex = cto.CustoType; cboPassportType.SelectedIndex = cto.PassportType; dtpBirth.Value = cto.CustoBirth; txtPassportNum.Text = cto.CustoID; } catch { } #endregion #region 加载消费信息 string RoomNo = txtRoomNo.Text; dgvSpendList.DataSource = SpendManager.SelectSpendInfoRoomNo(RoomNo); dgvSpendList.AutoGenerateColumns = false; double result = 0;
private void FrmCheckOutForm_Load(object sender, EventArgs e) { double sum = 0; txtCustoNo.Text = ucRoomList.rm_CustoNo; CustoNo.Text = ucRoomList.rm_CustoNo; txtRoomNo.Text = ucRoomList.rm_RoomNo; string rn = txtRoomNo.Text.ToString(); string rs = rn.Substring(0, 2); CmpSetDgv(); if (ucRoomList.co_CheckTime == null) { dtpCheckTime.Value = DateTime.Now; } else { dtpCheckTime.Value = Convert.ToDateTime(ucRoomList.co_CheckTime); } if (rs == "BD") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 300)); } if (rs == "BS") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 425)); } if (rs == "HD") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 625)); } if (rs == "HS") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 660)); } if (rs == "QL") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 845)); } if (rs == "ZT") { sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 1080)); } lblDay.Text = Convert.ToString(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString())); w = new Wti() { CustoNo = txtCustoNo.Text, EndDate = Convert.ToDateTime(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))), PowerUse = Convert.ToDecimal(Convert.ToInt32(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 3 * 1), WaterUse = Convert.ToDecimal(Convert.ToDouble(RoomManager.DayByRoomNo(txtRoomNo.Text).ToString()) * 80 * 0.002), RoomNo = txtRoomNo.Text, Record = "admin", UseDate = Convert.ToDateTime(DateTime.Parse(dtpCheckTime.Text)), }; #region 加载客户信息 Custo cto = CustoManager.SelectCustoByCustoNo(CustoNo.Text.ToString()); try { CustoName.Text = cto.CustoName; txtCustoName.Text = cto.CustoName; txtTel.Text = cto.CustoTel; cboCustoSex.Text = cto.CustoSex == 1 ? "男" : "女"; cboCustoType.SelectedIndex = cto.CustoType; cboPassportType.SelectedIndex = cto.PassportType; dtpBirth.Value = cto.CustoBirth; txtPassportNum.Text = cto.CustoID; } catch { } #endregion #region 加载消费信息 string RoomNo = txtRoomNo.Text; dgvSpendList.DataSource = SpendManager.SelectSpendInfoRoomNo(RoomNo); dgvSpendList.AutoGenerateColumns = false; double result = 0; if (dgvSpendList.Rows.Count == 0) { result = 0; } else { result = Convert.ToDouble(SpendManager.SelectMoneyByRoomNoAndTime(RoomNo, CustoNo.Text.ToString())); } #endregion if (cboCustoType.Text == "钻石会员") { double m = result + sum; lblGetReceipts.Text = m.ToString(); lblVIPPrice.Text = Convert.ToString(m * 0.60); lblVIP.Text = "六折"; } else if (cboCustoType.Text == "白金会员") { double m = result + sum; lblGetReceipts.Text = m.ToString(); lblVIPPrice.Text = Convert.ToString(m * 0.80); lblVIP.Text = "八折"; } else if (cboCustoType.Text == "黄金会员") { double m = result + sum; lblGetReceipts.Text = m.ToString(); lblVIPPrice.Text = Convert.ToString(m * 0.90); lblVIP.Text = "九折"; } else if (cboCustoType.Text == "普通会员") { double m = result + sum; lblGetReceipts.Text = m.ToString(); lblVIPPrice.Text = Convert.ToString(m * 0.95); lblVIP.Text = "九五折"; } else if (cboCustoType.Text == "普通用户") { //39525 double m = result + sum; lblGetReceipts.Text = m.ToString(); lblVIPPrice.Text = Convert.ToString(m); lblVIP.Text = "不 打 折"; } }