private void Frm_PowerFeeStatRep1_Load(object sender, EventArgs e)
        {
            string sql = "Select * From temp_MonthPowerFee";
            DataTable dt = SQLUtl.Query(sql).Tables["dataSet"];
            PowerFeeStatRep powerFeeStatRep = new PowerFeeStatRep();
            powerFeeStatRep.SetDataSource(dt);
            crystalReportViewer1.ReportSource = powerFeeStatRep;
            TextObject txtMonth = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtMonth"];
            txtMonth.Text = month;
            TextObject repNum = (TextObject) powerFeeStatRep.ReportDefinition.ReportObjects["txtNum"];
            repNum.Text = "(一)";

            sql = "Select * From temp_YearPowerFee";
            dt = SQLUtl.Query(sql).Tables["dataSet"];

            TextObject txtCountAmount = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtCountAmount"];
            txtCountAmount.Text = String.Format("{0:#,##0}",dt.Rows[0]["CountAmount"]);
            TextObject txtRuralFee = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtRuralFee"];
            txtRuralFee.Text = String.Format("{0:#,##0.00}", dt.Rows[0]["CountryAnnex"]);
            TextObject txtCityFee = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtCityFee"];
            txtCityFee.Text = String.Format("{0:#,##0.00}", dt.Rows[0]["CityAnnex"]);
            TextObject txtBaseFee = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtBaseFee"];
            txtBaseFee.Text = String.Format("{0:#,##0.00}", dt.Rows[0]["BaseFee"]);
            TextObject txtTotalFee = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtTotalFee"];
            txtTotalFee.Text = String.Format("{0:#,##0.00}", dt.Rows[0]["TotalFee"]);

            TextObject txtPnum = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtPNum"];
            txtPnum.Text = dt.Rows[0]["pt"].ToString();
            TextObject txtZnum = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtZNum"];
            txtZnum.Text = dt.Rows[0]["zz"].ToString();
            TextObject txtNnum = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtNnum"];
            txtNnum.Text = dt.Rows[0]["lw"].ToString();
            TextObject txtPeople = (TextObject)powerFeeStatRep.ReportDefinition.ReportObjects["txtPeople"];
            txtPeople.Text = Constant.LoginUser.UserName;
        }
Exemplo n.º 2
0
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
 {
     PowerFeeStatRep rpt = new PowerFeeStatRep();
     rpt.Site = this.Site;
     return rpt;
 }