private void button1_Click(object sender, EventArgs e) //退出系统按钮 { //获取上机时间 DateTime dts = Convert.ToDateTime(lblLoginTime.Text); string logintime = dts.GetDateTimeFormats('g')[0].ToString(); //获取下机时间 DateTime dtr = DateTime.Now; string rq = dtr.ToShortDateString().ToString(); DateTime dts2 = Convert.ToDateTime(rq + " " + n1.Value + ":" + n2.Value); string offtime = dts2.GetDateTimeFormats('g')[0].ToString(); //得出时间间隔 TimeSpan dt = Convert.ToDateTime(offtime) - Convert.ToDateTime(logintime); int jg = Convert.ToInt32(Convert.ToString(dt.TotalMinutes)); //获得单位时间金额设置值 int i, j; int k = 1; for (int num = 0; num < 100; num++) { i = 5 * num; j = 5 * (num + 1); if (i < jg && j >= jg) { k = 1 + num; } } //计算剩余金额 int sy = Convert.ToInt32(lblLoginMoney.Text.Trim()) - k; //更新数据库余额 string id = lblLoginId.Text.Trim(); Facade.Consumers cs = new Facade.Consumers(); cs.UpdateMoney(id, sy); //在消费记录表中插入一条新的消费信息 Entity.Money consumeinfo = new Entity.Money(); consumeinfo.cardno = lblLoginId.Text.Trim(); consumeinfo.logintime = Convert.ToDateTime(lblLoginTime.Text.Trim()); consumeinfo.offtime = Convert.ToDateTime(offtime); consumeinfo.consumetime = jg; consumeinfo.consume = k; consumeinfo.remaindermoney = sy; cs.InsertConsumeInfo(consumeinfo); //退出系统 MessageBox.Show("上机时间为:" + jg + "," + "消费金额为:" + k + "," + "剩余金额为:" + sy, "温馨提示"); }
private void btnBackMoney_Click(object sender, EventArgs e) //点击退款按钮 { //根据id清空其余额 string cardno = txtCardNo.Text.Trim(); Facade.Consumers consumer = new Facade.Consumers(); consumer.UpdateMoney(cardno, 0); //将一行退卡信息插入到数据库 Entity.BackMoney backmoney = new Entity.BackMoney(); backmoney.cardno = cardno; backmoney.money = txtMoney.Text.Trim(); backmoney.operater = Entity.GoAnyWhere.id; backmoney.time = DateTime.Now; int result = consumer.AddBackInfo(backmoney); if (result > 0) { MessageBox.Show("退卡成功!", "温馨提示"); } else { MessageBox.Show("退卡失败,请联系管理员!", "温馨提示"); } }