private void sbtnOk_Click(object sender, System.EventArgs e) { DateTime dtnow = DateTime.Now; lblTitle.Text = dtnow.ToShortDateString() + "截止到" + dtnow.Hour + "点" + dtnow.Minute + "分结帐情况"; err = null; DataTable dt = ca.GetChangeCheckQuery(this.cmbOper.Text.Trim(), out err); int consCount = 0; int consCount1 = 0; double consFee = 0; if (err != null) { lblTitle.Text = "计算时发生错误"; clog.WriteLine(err); return; } if (dt == null || dt.Rows.Count <= 0) { lblTitle.Text = "今日没有任何消费和充值记录!"; return; } for (int i = 0; i < dt.Rows.Count; i++) { switch (dt.Rows[i]["vcConsType"].ToString()) { case "PT001": consCount += int.Parse(dt.Rows[i]["ConsCount"].ToString()); this.txtAssCons.Text = dt.Rows[i]["ConsFee"].ToString(); break; case "PT002": consCount += int.Parse(dt.Rows[i]["ConsCount"].ToString()); consFee += double.Parse(dt.Rows[i]["ConsFee"].ToString()); this.txtRetail.Text = dt.Rows[i]["ConsFee"].ToString(); break; case "PT004": consCount1 += int.Parse(dt.Rows[i]["ConsCount"].ToString()); this.txtLargCount.Text = consCount1.ToString(); break; case "PT008": consCount += int.Parse(dt.Rows[i]["ConsCount"].ToString()); //consFee+=double.Parse(dt.Rows[i]["ConsFee"].ToString()); this.txtRetailBank.Text = dt.Rows[i]["ConsFee"].ToString(); break; case "Fill": this.txtFillCount.Text = dt.Rows[i]["ConsCount"].ToString(); this.txtFillFee.Text = dt.Rows[i]["ConsFee"].ToString(); consFee += double.Parse(dt.Rows[i]["ConsFee"].ToString()); break; case "FillBank": this.txtFillCountBank.Text = dt.Rows[i]["ConsCount"].ToString(); this.txtFillFeeBank.Text = dt.Rows[i]["ConsFee"].ToString(); //consFee+=double.Parse(dt.Rows[i]["ConsFee"].ToString()); break; case "CradRoll": this.txtRoll.Text = dt.Rows[i]["ConsCount"].ToString(); this.txtRollSum.Text = dt.Rows[i]["ConsFee"].ToString(); consFee += double.Parse(dt.Rows[i]["ConsFee"].ToString()); break; } } this.txtConsCount.Text = consCount.ToString(); this.txtCash.Text = Math.Round(consFee, 2).ToString(); }