/// <summary>
        /// 根据房间信息、使用时间修改水电费
        /// </summary>
        /// <param name="w"></param>
        /// <returns></returns>
        public static int UpdateWtiInfoByRoomNoAndDateTime(Wti w)
        {
            string sql = "update WTINFO set WaterUse='{0}',PowerUse='{1}' where ";

            sql += " RoomNo='{2}' and UseDate='{3}' and EndDate='{4}'";
            sql  = string.Format(sql, w.WaterUse, w.PowerUse, w.RoomNo, w.UseDate, w.EndDate);
            return(DBHelper.ExecuteNonQuery(sql));
        }
        /// <summary>
        /// 修改水电费信息(根据房间编号)
        /// </summary>
        /// <param name="w"></param>
        /// <returns></returns>
        public static int UpdateWtiInfo(Wti w)
        {
            string sql = " update WTINFO set UseDate='{1}',EndDate='{2}',";

            sql += "WaterUse ='{3}',PowerUse='{4}',Record='{5}',CustoNo='{6}'where RoomNo = '{0}'";
            sql  = string.Format(sql, w.RoomNo, w.UseDate, w.EndDate,
                                 w.WaterUse, w.PowerUse, w.Record, w.CustoNo);
            return(DBHelper.ExecuteNonQuery(sql));
        }
        /// <summary>
        /// 添加水电费信息
        /// </summary>
        /// <param name="w"></param>
        /// <returns></returns>
        public static int InsertWtiInfo(Wti w)
        {
            string sql = "insert WTINFO (RoomNo,UseDate,EndDate,";

            sql += "WaterUse,PowerUse,Record,CustoNo) values ";
            sql += "('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
            sql  = string.Format(sql, w.RoomNo, w.UseDate, w.EndDate,
                                 w.WaterUse, w.PowerUse, w.Record, w.CustoNo);
            return(DBHelper.ExecuteNonQuery(sql));
        }
        /// <summary>
        /// 根据房间编号查询水电费信息
        /// </summary>
        /// <param name="roomNo"></param>
        /// <returns></returns>
        public static Wti SelectWtiInfoByRoomNo(string roomNo)
        {
            Wti           w   = null;
            string        sql = "select * from WTINFO where RoomNo like '%" + roomNo + "%'";
            SqlDataReader dr  = DBHelper.ExecuteReader(sql);

            if (dr.Read())
            {
                w          = new Wti();
                w.CustoNo  = dr["CustoNo"].ToString();
                w.EndDate  = Convert.ToDateTime(dr["EndDate"]);
                w.PowerUse = (decimal)dr["PowerUse"];
                w.Record   = dr["Record"].ToString();
                w.RoomNo   = dr["RoomNo"].ToString();
                w.UseDate  = Convert.ToDateTime(dr["UseDate"]);
                w.WaterUse = (decimal)dr["WaterUse"];
            }
            dr.Close();
            DBHelper.Closecon();
            return(w);
        }
        /// <summary>
        /// 获取所有水电费信息
        /// </summary>
        /// <returns></returns>
        public static List <Wti> SelectWtiInfoAll()
        {
            List <Wti>    wti = new List <Wti>();
            string        sql = "select * from WTINFO";
            SqlDataReader dr  = DBHelper.ExecuteReader(sql);

            while (dr.Read())
            {
                Wti w = new Wti();
                w.CustoNo  = dr["CustoNo"].ToString();
                w.EndDate  = Convert.ToDateTime(dr["EndDate"]);
                w.PowerUse = (decimal)dr["PowerUse"];
                w.Record   = dr["Record"].ToString();
                w.RoomNo   = dr["RoomNo"].ToString();
                w.UseDate  = Convert.ToDateTime(dr["UseDate"]);
                w.WaterUse = (decimal)dr["WaterUse"];
                wti.Add(w);
            }
            dr.Close();
            DBHelper.Closecon();
            return(wti);
        }
        private void picUpdate_Click(object sender, EventArgs e)
        {
            //判断房间编号、开始使用时间和结束使用时间是否为空
            if (txtRoomNo.Text != "" && dtpUseDate.Text != "" && dtpEndDate.Text != "")
            {
                //获取房间编号和使用时间
                string no      = txtRoomNo.Text;
                string usedate = dtpUseDate.Value.ToString();
                string enddate = dtpEndDate.Value.ToString();
                //根据用户输入的房间编号、开始使用时间和结束使用时间获取水电费信息
                Wti w = WtiService.SelectWtiInfoByRoomNoAndTime(no, usedate, enddate);

                //判断用户输入的房间编号、开始使用时间和结束使用时间是否能找到对应数据
                if (w != null)
                {
                    txtPowerUse.Text = w.PowerUse.ToString();
                    txtWaterUse.Text = w.WaterUse.ToString();
                    FendTextBox();//遍历文本框(禁用)

                    //启用部分文本框
                    txtPowerUse.Enabled = true;
                    txtWaterUse.Enabled = true;
                    btnOk.Enabled       = true;
                    txtWaterUse.Focus();//水费文本框聚焦
                    btnOk.Text = "修改";
                }
                else
                {
                    MessageBox.Show("请核对水电费信息", "输入提示");
                }
            }
            else
            {
                MessageBox.Show("房间编号、开始使用时间和结束使用时间不能为空!", "输入提示");
                txtRoomNo.Focus();//房间编号文本框聚焦
            }
        }
 private void btnOk_Click(object sender, EventArgs e)
 {
     if (btnOk.Text == "修改")
     {
         //获取房间编号和使用时间
         string no      = txtRoomNo.Text;
         string usedate = dtpUseDate.Value.ToString();
         string enddate = dtpEndDate.Value.ToString();
         //根据用户输入的房间编号、开始使用时间和结束使用时间获取水电费信息
         Wti    w     = WtiService.SelectWtiInfoByRoomNoAndTime(no, usedate, enddate);
         string water = txtWaterUse.Text;
         string power = txtPowerUse.Text;
         if (water != w.WaterUse.ToString() || power != w.PowerUse.ToString())
         {
             Wti w2 = new Wti()
             {
                 RoomNo   = txtRoomNo.Text,
                 EndDate  = dtpEndDate.Value,
                 UseDate  = dtpUseDate.Value,
                 PowerUse = Convert.ToDecimal(txtPowerUse.Text),
                 WaterUse = Convert.ToDecimal(txtWaterUse.Text),
             };
             int n = WtiService.UpdateWtiInfoByRoomNoAndDateTime(w2);
             if (n > 0)
             {
                 MessageBox.Show("修改成功!", "修改提示");
                 LoadWtiInfo();
             }
             else
             {
                 MessageBox.Show("修改失败!", "修改提示");
             }
         }
         return;
     }
 }
        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         = "不  打  折";
            }
        }
Пример #9
0
 public bool InsertWtiInfo([FromBody] Wti w)
 {
     return(new WtiService().InsertWtiInfo(w));
 }
        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      = "不  打  折";
            }
        }
Пример #11
0
 public bool UpdateWtiInfoByRoomNoAndDateTime([FromBody] Wti w)
 {
     return(new WtiService().UpdateWtiInfoByRoomNoAndDateTime(w));
 }
Пример #12
0
 public bool UpdateWtiInfo([FromBody] Wti w)
 {
     return(new WtiService().UpdateWtiInfo(w));
 }
Пример #13
0
 /// <summary>
 /// 根据房间信息、使用时间修改水电费
 /// </summary>
 /// <param name="w"></param>
 /// <returns></returns>
 public static int UpdateWtiInfoByRoomNoAndDateTime(Wti w)
 {
     return(WtiService.UpdateWtiInfoByRoomNoAndDateTime(w));
 }
Пример #14
0
 /// <summary>
 /// 修改水电费信息(根据房间编号)
 /// </summary>
 /// <param name="w"></param>
 /// <returns></returns>
 public static int UpdateWtiInfo(Wti w)
 {
     return(WtiService.UpdateWtiInfo(w));
 }
Пример #15
0
 /// <summary>
 /// 添加水电费信息
 /// </summary>
 /// <param name="w"></param>
 /// <returns></returns>
 public static int InsertWtiInfo(Wti w)
 {
     return(WtiService.InsertWtiInfo(w));
 }
Пример #16
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;
Пример #17
0
        private void FrmCheckOutForm_Load(object sender, EventArgs e)
        {
            foreach (Control label in this.Controls)
            {
                if (label.GetType().ToString() == "Sunny.UI.UITabControlMenu")
                {
                    label.Font = UI_FontUtil.SetChildControlsFont();
                }
            }
            #region 加载客户类型信息
            List <CustoType> lstSourceGrid = new BaseService().SelectCustoTypeAll();
            this.cboCustoType.DataSource    = lstSourceGrid;
            this.cboCustoType.DisplayMember = "TypeName";
            this.cboCustoType.ValueMember   = "UserType";
            this.cboCustoType.SelectedIndex = 0;
            this.cboCustoType.ReadOnly      = true;
            #endregion

            #region 加载证件类型信息
            List <PassPortType> passPorts = new BaseService().SelectPassPortTypeAll();
            this.cboPassportType.DataSource    = passPorts;
            this.cboPassportType.DisplayMember = "PassportName";
            this.cboPassportType.ValueMember   = "PassportId";
            this.cboPassportType.SelectedIndex = 0;
            #endregion

            #region 加载性别信息
            List <SexType> listSexType = new BaseService().SelectSexTypeAll();
            this.cboCustoSex.DataSource    = listSexType;
            this.cboCustoSex.DisplayMember = "sexName";
            this.cboCustoSex.ValueMember   = "sexId";
            this.cboCustoSex.SelectedIndex = 0;
            #endregion

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

            if (ucRoomList.co_CheckTime == null)
            {
                dtpCheckTime.Text = DateTime.Now.ToString("yyyy年MM月dd日");
            }
            else
            {
                dtpCheckTime.Text = Convert.ToDateTime(ucRoomList.co_CheckTime).ToString("yyyy年MM月dd日");
            }
            if (rs == "BD")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 300));
            }
            if (rs == "BS")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 425));
            }
            if (rs == "HD")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 625));
            }
            if (rs == "HS")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 660));
            }
            if (rs == "QL")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 845));
            }
            if (rs == "ZT")
            {
                sum = Convert.ToDouble(Convert.ToString(Convert.ToInt32(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 1080));
            }
            lblDay.Text = Convert.ToString(Convert.ToInt32(new RoomService().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(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 3 * 1),
                WaterUse = Convert.ToDecimal(Convert.ToDouble(new RoomService().DayByRoomNo(txtRoomNo.Text).ToString()) * 80 * 0.002),
                RoomNo   = txtRoomNo.Text,
                Record   = "admin",
                UseDate  = Convert.ToDateTime(DateTime.Parse(dtpCheckTime.Text)),
            };

            #region 加载客户信息
            Custo cto = new CustoService().SelectCardInfoByCustoNo(CustoNo.Text.ToString());
            try
            {
                CustoName.Text                = cto.CustoName;
                txtCustoName.Text             = cto.CustoName;
                txtTel.Text                   = cto.CustoTel;
                cboCustoSex.SelectedIndex     = 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          = new SpendService().SelectSpendInfoRoomNo(RoomNo);
            dgvSpendList.AutoGenerateColumns = false;
            double result = 0;
            if (dgvSpendList.Rows.Count == 0)
            {
                result = 0;
            }
            else
            {
                result = Convert.ToDouble(new SpendService().SelectMoneyByRoomNoAndTime(RoomNo, CustoNo.Text.ToString()));
            }

            #endregion

            #region 加载水电费信息
            var listWti = new WtiService().SelectWtiInfoAll();
            dgvWti.DataSource          = listWti;
            dgvWti.AutoGenerateColumns = false;
            #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         = "不  打  折";
            }
        }