public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CrtLeadTime rpt = new CrtLeadTime();
rpt.Site = this.Site;
return rpt;
}
public PrintLeadTime(Surat objSurat)
{
InitializeComponent();
this.objSurat = objSurat;
sqlCustomerTransRepository = new SqlCustomerTransRepository();
reportDocument = new ReportDocument();
paramFields = new ParameterFields();
crtLeadTime = new CrtLeadTime();
//Execute Query
String strQry = "Select [CUSTOMER_TRANS_DETAIL].no_container as Column1, " +
"(Select Top 1 address From WareHouse Where stuffing_place_id = stuffing_place) as Column2, " +
"[CUSTOMER_TRANS_DETAIL].terima_toko as Column3 From [CUSTOMER_TRANS_DETAIL] " +
"Join [Customer_Trans] On " +
"[Customer_Trans].tgl_transaksi = cast('" + Utility.Utility.ConvertDateToString(objSurat.Tgl) + "' as date) And " +
"[Customer_Trans].Customer_id = '" + objSurat.CustomerID + "' And " +
"([Customer_Trans].deleted is not null Or [Customer_Trans].deleted = 0) " +
"And [Customer_Trans].id = [Customer_Trans_Detail].customer_trans_id";
int columnNo = 1;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Container";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
columnNo++;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Tgl penerimaan Container";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
columnNo++;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Gudang";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "noSurat";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = objSurat.NoSurat;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "parameterReceive";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = objSurat.CustomerName;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
SqlDataAdapter da = new SqlDataAdapter(strQry, VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
ShippingMainDataSet ds = new ShippingMainDataSet();
da.Fill(ds, "Surat_Lead_Time");
crtLeadTime.SetDataSource(ds);
crystalReportViewer1.ReportSource = crtLeadTime;
}
