private void ReportFetchRecord()
{
Report.ControlByName("title").AsStaticBox.Text = ConfDao.getInstance().Get(3).ToString() + " 客户对账单";
Report.ControlByName("customer").AsStaticBox.Text = "客户：" + this.textBox_search.Text;
Report.ControlByName("time").AsStaticBox.Text = string.Format("对账时间: {0}至{1}", this.dateTimePicker_start.Value.ToShortDateString(), this.dateTimePicker_end.Value.ToShortDateString());
// 处理 明细
foreach (DataGridViewRow row in this.dataGridView1.Rows)
{
Report.DetailGrid.Recordset.Append();
Report.FieldByDBName("date").AsString = row.Cells["time"].Value.ToString();
Report.FieldByDBName("type").AsString = row.Cells["type"].Value.ToString() + "\n" + row.Cells["serial"].Value.ToString();
Report.FieldByDBName("product").AsString = row.Cells["detail"].Value.ToString();
Report.FieldByDBName("needReceipt").AsString = row.Cells["needReceipt"].Value.ToString();
Report.FieldByDBName("thisReceipt").AsString = row.Cells["thisReceipt"].Value.ToString();
Report.FieldByDBName("accTotal").AsString = row.Cells["accNeedReceipt"].Value.ToString();
Report.DetailGrid.Recordset.Post();
}
}