private void btnReportBBBG_Click(object sender, EventArgs e)
{
if (grvDecleration.SelectedRows.Count == 0)
{
MessageBox.Show("Bạn cần chọn 1 tờ khai để in biên bản bàn giao.");
return;
}
var declerationId = Convert.ToInt64(grvDecleration.SelectedRows[0].Cells["DeclarationID"].Value);
// Get Decleration information
var declarationInfo = DeclarationFactory.GetByID(declerationId);
ECustoms.HandoverTempImportReExport report = new HandoverTempImportReExport();
// 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["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);
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
ECustoms.HandoverStatisticReport report = new HandoverStatisticReport();
// Cuc hai quan
((TextObject)report.Section1.ReportObjects["SuperiorCompany"]).Text = GetUserConfig().ToUpper();
// Chi cuc hai quan
((TextObject)report.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
//StringBuilder buffer = new StringBuilder();
//buffer.Append(" SELECT * FROM ViewAllDeclarationTNTX ");
//buffer.Append(" WHERE DeclarationID != 0 AND DeclarationID != 1 ");
//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);
DataSet2 dataSet2 = new DataSet2();
DataTable table1 = dataSet2.ViewAllDeclarationTNTX;
foreach (ViewAllDeclaration obj in _listDeclarationinfo)
{
table1.Rows.Add(
obj.DeclarationID,
obj.Number,
null,
null,
null,
obj.Unit,
null,
null,
null,
null,
null,
null,
obj.Type,
null,
obj.RegisterDate,
null,
null,
null,
obj.RegisterPlace,
null,
obj.NumberHandover,
obj.DateHandover,
null,
null,
null,
null,
null,
null,
obj.Seal,
1,
null,
null,
null,
null,
null,
null,
null);
}
report.SetDataSource(dataSet2);
//preview report
var reportForm = new FrmCrystalReport(report, _userInfo);
reportForm.MaximizeBox = true;
reportForm.Show(this);
}
/// <summary>
/// Get DataTable to report
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
if ((cbReportType.SelectedValue + "").Equals(""))
{
MessageBox.Show(this,"Chưa chọn loại báo cáo","Cảnh báo",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
try
{
var from = new DateTime(dtpExportFrom.Value.Year, dtpExportFrom.Value.Month, dtpExportFrom.Value.Day, 0, 0, 0);
var to = new DateTime(dtpExportTo.Value.Year, dtpExportTo.Value.Month, dtpExportTo.Value.Day, 23, 59, 59);
var reportType = GetReportType(Int32.Parse(cbReportType.SelectedValue + ""));
var branchId = cbUnit.SelectedValue.ToString();
var type = cbType.SelectedValue.ToString();
var report = new FrmCrystalReport(reportType, from, to, _userInfo, branchId, type);
report.MaximizeBox = true;
report.Show(this);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
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);
}
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)
{
}
}