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, "温馨提示"); }
/// <summary> /// 用户下机,向消费记录表中插入一条信息 /// </summary> /// <param name="money">消费记录实体</param> public void InsertConsumeInfo(Entity.Money money) { string sql = "insert into ConsumeForm values('" + money.cardno + "','" + money.logintime + "','" + money.offtime + "','" + money.consumetime + "','" + money.consume + "','" + money.remaindermoney + "')"; sqlhelper.ExecuteNonQuery(sql); }
/// <summary> /// 用户下机,向消费记录表中插入一条信息 /// </summary> /// <param name="money">消费记录实体</param> public void InsertConsumeInfo(Entity.Money money) { ic.InsertConsumeInfo(money); }