public FrmCrystalReport(HandoverQuaCanh report, UserInfo userInfo)
{
InitializeComponent();
_userInfo = userInfo;
crystalReportViewer1.ReportSource = report;
this.WindowState = FormWindowState.Maximized;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
HandoverQuaCanh rpt = new HandoverQuaCanh();
rpt.Site = this.Site;
return rpt;
}
private void btnReportQC_Click(object sender, EventArgs e)
{
// Get Decleration information
var declarationInfo = DeclarationFactory.GetByID(this._declerationID);
var report = new HandoverQuaCanh();
// Cuc hai quan
((TextObject)report.Section1.ReportObjects["SuperiorCompany"]).Text = GetUserConfig().ToUpper();
// Chi cuc hai quan
((TextObject)report.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
//((TextObject)report.Section1.ReportObjects["txtHandoverNumber"]).Text = declarationInfo.NumberHandover!=null? declarationInfo.NumberHandover.ToString() : "";
if (declarationInfo.DateHandover != null)
{
((TextObject)report.Section1.ReportObjects["txtDate"]).Text = "Hồi " + declarationInfo.DateHandover.Value.Hour + " giờ " + declarationInfo.DateHandover.Value.Minute + " phút, " + "ngày " + declarationInfo.DateHandover.Value.Day + " tháng " + declarationInfo.DateHandover.Value.Month + " năm " + declarationInfo.DateHandover.Value.Year + ",";
}
// Chi cuc hai quan
((TextObject)report.Section1.ReportObjects["txtBranchName"]).Text = GlobalInfo.CompanyName.ToUpper();
((TextObject)report.Section1.ReportObjects["txtBranchName"]).Text = GlobalInfo.CompanyName.ToUpper();
((TextObject)report.Section1.ReportObjects["txtCompany"]).Text = declarationInfo.CompanyName;
((TextObject)report.Section1.ReportObjects["txtNumber"]).Text = declarationInfo.Number.ToString();
StringBuilder buffer = new StringBuilder();
buffer.Append(" SELECT * FROM ViewAllDeclarationTNTX ");
buffer.Append(" WHERE ");
buffer.Append(" DeclarationID = " + _declerationID);
var connection = new SqlConnection(Common.Decrypt(System.Configuration.ConfigurationSettings.AppSettings["connectionString"], true));
var adpater = new SqlDataAdapter(buffer.ToString(), connection);
var dt = new DataTable();
adpater.Fill(dt);
report.SetDataSource(dt);
//preview report
var reportForm = new FrmCrystalReport(report, _userInfo);
reportForm.MaximizeBox = true;
reportForm.Show(this);
}