public FrmCrystalReport(VehicleFeeReport report)
{
InitializeComponent();
crystalReportViewer1.ReportSource = report;
this.WindowState = FormWindowState.Maximized;
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (cbFeeExport.Checked == false && cbFeeImport.Checked == false)
{
MessageBox.Show("Bạn cần chọn loại báo cáo");
return;
}
try
{
var dateImportValueFrom = new DateTime(dtpImportFrom.Value.Year, dtpImportFrom.Value.Month, dtpImportFrom.Value.Day, 0, 0, 0);
var dateImportValueTo = new DateTime(dtpImportTo.Value.Year, dtpImportTo.Value.Month, dtpImportTo.Value.Day, 23, 59, 59);
var dateExportValueFrom = new DateTime(dtpExportFrom.Value.Year, dtpExportFrom.Value.Month, dtpExportFrom.Value.Day, 0, 0, 0);
var dateExportValueTo = new DateTime(dtpExportTo.Value.Year, dtpExportTo.Value.Month, dtpExportTo.Value.Day, 23, 59, 59);
var vehicleFeeReport = new VehicleFeeReport();
var connection = new SqlConnection(Common.Decrypt(System.Configuration.ConfigurationSettings.AppSettings["connectionString"], true));
((TextObject)vehicleFeeReport.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
var createdBy = (TextObject)vehicleFeeReport.Section1.ReportObjects["CreatedBy"];
createdBy.Text = _userInfo.Name;
var dateImportFrom = (TextObject)vehicleFeeReport.Section1.ReportObjects["dateImportFrom"];
dateImportFrom.Text = dtpImportFrom.Value.ToString("dd/MM/yyy");
var dateImportTo = (TextObject)vehicleFeeReport.Section1.ReportObjects["dateImportTo"];
dateImportTo.Text = dtpImportTo.Value.ToString("dd/MM/yyy");
var dateExportFrom = (TextObject)vehicleFeeReport.Section1.ReportObjects["dateExportFrom"];
dateExportFrom.Text = dtpExportFrom.Value.ToString("dd/MM/yyy");
var dateExportTo = (TextObject)vehicleFeeReport.Section1.ReportObjects["dateExportTo"];
dateExportTo.Text = dtpExportTo.Value.ToString("dd/MM/yyy");
var sql = new StringBuilder();
if (cbFeeImport.Checked == true && cbFeeExport.Checked == false)
{
dateExportFrom.Text = "";
dateExportTo.Text = "";
sql.Append("select * from ViewVehicleFee");
sql.Append(" where FeeTypeID=2");
sql.Append(" AND FeeDate >= '" + dateImportValueFrom.ToString("yyyy-MM-dd HH:mm"));
sql.Append("' AND FeeDate < = '" + dateImportValueTo.ToString("yyyy-MM-dd HH:mm") + "'");
}
if (cbFeeImport.Checked == false && cbFeeExport.Checked == true)
{
dateImportFrom.Text = "";
dateImportTo.Text = "";
sql.Append("select * from ViewVehicleFee");
sql.Append(" where FeeTypeID=1");
sql.Append(" AND FeeDate >= '" + dateExportValueFrom.ToString("yyyy-MM-dd HH:mm"));
sql.Append("' AND FeeDate < = '" + dateExportValueTo.ToString("yyyy-MM-dd HH:mm") + "'");
}
if (cbFeeImport.Checked == true && cbFeeExport.Checked == true)
{
sql.Append("select * from ViewVehicleFee");
sql.Append(" where (FeeTypeID=1");
sql.Append(" AND FeeDate >= '" + dateExportValueFrom.ToString("yyyy-MM-dd HH:mm"));
sql.Append("' AND FeeDate < = '" + dateExportValueTo.ToString("yyyy-MM-dd HH:mm") + "')");
sql.Append(" OR (FeeTypeID=2");
sql.Append(" AND FeeDate >= '" + dateImportValueFrom.ToString("yyyy-MM-dd HH:mm"));
sql.Append("' AND FeeDate < = '" + dateImportValueTo.ToString("yyyy-MM-dd HH:mm") + "')");
}
var adpater = new SqlDataAdapter(sql.ToString(), connection);
var dt = new DataTable();
adpater.Fill(dt);
vehicleFeeReport.SetDataSource(dt);
adpater.Dispose();
FrmCrystalReport frmReport = new FrmCrystalReport(vehicleFeeReport);
frmReport.MaximizeBox = true;
frmReport.Show(this);
}
catch (Exception ex)
{
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
VehicleFeeReport rpt = new VehicleFeeReport();
rpt.Site = this.Site;
return rpt;
}