/// <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 = "不 打 折"; } }
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 = "不 打 折"; } }
public bool UpdateWtiInfoByRoomNoAndDateTime([FromBody] Wti w) { return(new WtiService().UpdateWtiInfoByRoomNoAndDateTime(w)); }
public bool UpdateWtiInfo([FromBody] Wti w) { return(new WtiService().UpdateWtiInfo(w)); }
/// <summary> /// 根据房间信息、使用时间修改水电费 /// </summary> /// <param name="w"></param> /// <returns></returns> public static int UpdateWtiInfoByRoomNoAndDateTime(Wti w) { return(WtiService.UpdateWtiInfoByRoomNoAndDateTime(w)); }
/// <summary> /// 修改水电费信息(根据房间编号) /// </summary> /// <param name="w"></param> /// <returns></returns> public static int UpdateWtiInfo(Wti w) { return(WtiService.UpdateWtiInfo(w)); }
/// <summary> /// 添加水电费信息 /// </summary> /// <param name="w"></param> /// <returns></returns> public static int InsertWtiInfo(Wti w) { return(WtiService.InsertWtiInfo(w)); }
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) { 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 = "不 打 折"; } }