private void Frm_DayChargeRep_Load(object sender, EventArgs e)
{
string sql = "Select * From Temp_DayCharge ";
DataTable dt = SQLUtl.Query(sql).Tables["dataSet"];
DayChargeRep dayChargeRep = new DayChargeRep();
dayChargeRep.SetDataSource(dt);
string sql1 = "select ROUND(ISNULL(TotalMoney,0),2) as DayCharge from countfee where InvoicePrintDate = '" + date + "' and InvoicePrintMan='" + Constant.LoginUser.UserName + "' and NegativeInvoiceFlag=1";
DataTable dt1 = SQLUtl.Query(sql1).Tables["dataSet"];
int count = dt1.Rows.Count;
for (int i = 0; i < count; i++)
{
TotalMoney = TotalMoney + double.Parse(dt1.Rows[i]["DayCharge"].ToString());
}
crystalReportViewer1.ReportSource = dayChargeRep;
TextObject txtMonth = (TextObject)dayChargeRep.ReportDefinition.ReportObjects["txtMonth"];
txtMonth.Text = date;
TextObject txtPeople = (TextObject)dayChargeRep.ReportDefinition.ReportObjects["txtPeople"];
txtPeople.Text = Constant.LoginUser.UserName;
//TextObject txtDemo = (TextObject)dayChargeRep.ReportDefinition.ReportObjects["txtDemo"];
//txtDemo.Text = "其中负数发票：" + count + " 张，负数发票总金额：" + TotalMoney + " 元";
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DayChargeRep rpt = new DayChargeRep();
rpt.Site = this.Site;
return rpt;
}