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