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("实收金额不能为空!", "系统提示");
     }
 }
Exemple #2
0
        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的提示");
                }
            }
        }
Exemple #3
0
        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      = "不  打  折";
            }
        }
Exemple #10
0
 public void LoadSpendInfo()
 {
     dgvRoomSell.AutoGenerateColumns = false;
     dgvRoomSell.DataSource          = SpendManager.SelectSpendInfoAll();
 }
Exemple #11
0
 private void LoadSpendInfo(string room)
 {
     dgvRoomSell.DataSource = SpendManager.SelectSpendByCustoNo(room);
 }
Exemple #12
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.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         = "不  打  折";
            }
        }