public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptMainBill rpt = new rptMainBill();
rpt.Site = this.Site;
return(rpt);
}
private void frmMainBillView_Load(object sender, EventArgs e)
{
try
{
rptMainBill rpt = new rptMainBill();
dsCommon ds = new dsCommon();
SQLiteConnection con = new SQLiteConnection("Data Source=" + System.IO.Path.Combine(AIO.path, AIO.file) + ";foreign keys=true;");//Password=5gs6hf7tjg86sjhfr6hkdg87grfj6ehgfr78lcmksd8;
AIO.command = "select abtComName as [Name],abtComAdd as [Add],abtComMob as [Mob],abtComEmail as [Email],abtVatTIN as [TIN],abtCstNo as [CST],abtPAN as [PAN],abtCIN as [CIN],abtEsta as [Esta] from AboutMe as [AM]";
SQLiteDataAdapter da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "AM");
AIO.command = "select tranNo as[No],tranDate as [Date],tranTotal as [Price],tranTax1 as [Tax1],tranTax2 as [Tax2],tranDiscPerc as [DiscPerc],tranDiscRs as [DiscRs],tranFinalTotal as [Total],tranInvoice as [Invoice],tranTax1Name as [tax1n],tranTax2Name as [tax2n] from Trans as [T] where id=" + ID;
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "Trans");
//AIO.command = "select id,itgQTY as [qty],itgPrice as [price],itgDesc as [desc] from TranItemsGrid where itgTranID=" + ID + " order by id asc";
//da = new SQLiteDataAdapter(AIO.command, con);
//da.Fill(ds, "TG");
AIO.command = "select tcVal as [val] from TermsCond";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "TC");
AIO.command = "select bnkName as [name],bnkBranch as [branch],bnkACNo as [acno],bnkIFSC as [ifsc] from Banks where id=(select tranBankID from Trans where id=" + ID + ")";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "Bank");
AIO.command = "select custName as [name],custAdd as [add],custMob as [mob],custEmail as [email],custVatTIN as [vat],custCstNo as [cst],custPAN as [pan] from Customer where id=(select tranCustID from Trans where id=" + ID + ")";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "Cust");
AIO.command = "select todDeliveryNote as [tod1],todSupplierRef as [tod2],todMOP as [tod3],todOtherRef as [tod4],todBuyerNo as [tod5],todBuyerDated as [tod6],todDispatchDoc as [tod7],todDispatchDated as [tod8],todDispatchThrough as [tod9],todDestination as [tod10],todTerms as [tod11] from TranOtherDetails where todTransID=" + ID;
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "TOD");
//AIO.command = "select itgModID from TranItemsGrid where itgTranID="+ID;
//var dt = a1.dataload();
//string models = "";
//foreach (DataRow row in dt.Rows)
//{
// models += row["itgModID"].ToString()+",";
//}
//models = models.Remove(models.Length - 1, 1);
//AIO.command = "select modCatID from model where id in (" + models + ")";
//var dt2 = a1.dataload();
//string coms = "";
//foreach (DataRow row in dt2.Rows)
//{
// coms += coms + row["modCatID"].ToString() + ",";
//}
//coms = coms.Remove(coms.Length - 1, 1);
AIO.command = "select (select comName from Company where id=(select catComID from Category where id=modCatID)) as [com],modName as [mod],itgQTY as [qty],itgPrice as [price],itgDesc as [desc] from model as m left join TranItemsGrid as tg on m.id=tg.itgModID where m.id in (select itgModID from TranItemsGrid where itgTranID=" + ID + ") and tg.itgTranID=" + ID + " order by tg.id ASC";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "CM");
AIO.command = "select tax1name,tax2name from GeneralSettings";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "General");
//ParameterFieldDefinitions crParameterFieldDefinitions;
//ParameterFieldDefinition crParameterFieldDefinition;
//ParameterValues crParameterValues = new ParameterValues();
//ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
//crParameterDiscreteValue.Value = "Purchase";
//crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields;
//crParameterFieldDefinition = crParameterFieldDefinitions["reportType"];
//crParameterValues = crParameterFieldDefinition.CurrentValues;
//crParameterValues.Clear();
//crParameterValues.Add(crParameterDiscreteValue);
//crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//rpt.SetParameterValue(0, "Purchase");
rpt.SetDataSource(ds);
rpt.Refresh();
//rpt.ExportToDisk(ExportFormatType.PortableDocFormat, Path.Combine(Path.GetDirectoryName(Application.ExecutablePath) ,@"\Report\tmpExport.pdf"));
//string path = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\Fire Shadow";
//rpt.ExportToDisk(ExportFormatType.PortableDocFormat, System.IO.Path.Combine(path,ds.Tables["Trans"].Rows[0]["No"].ToString()) + ".pdf");
crvMainBill.ReportSource = rpt;
crvMainBill.RefreshReport();
//crvMainBill.ExportReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
