private void SalesBillPrivew_Load(object sender, EventArgs e)
{
string s = "Select i.Item_Name as [Item],s.Quantity as [Qty],i.ITEM_RETAIL_PRICE as [Price],s.Quantity*i.ITEM_RETAIL_PRICE as [Amount] from tbl_Item i Join tbl_Sales s on i.Item_id=s.Itemno where s.BillNo=" + SchoolManagement.salesbillno;
SqlDataAdapter da = new SqlDataAdapter(s, d.con);
DataSet ds = new DataSet();
da.Fill(ds);
SalesBill sb = new SalesBill();
sb.SetDataSource(ds.Tables[0]);
sb.SetParameterValue("BillNo", SchoolManagement.salesbillno);
sb.SetParameterValue("Admno", SchoolManagement.sladmno);
sb.SetParameterValue("Name", SchoolManagement.slname);
sb.SetParameterValue("Discount", SchoolManagement.sldiscount);
sb.SetParameterValue("TotalAmount", SchoolManagement.sltotal);
//sb.SetParameterValue("SchoolName", SchoolManagement.SchoolName);
sb.SetParameterValue("SchoolName", "Nizamia Public School");
sb.SetParameterValue("DT", DateTime.Now.ToString());
sb.SetParameterValue("std", SchoolManagement.rptstd);
sb.SetParameterValue("div", SchoolManagement.rptdiv);
sb.SetParameterValue("Addr", "Pothencode, Trivandrum");
sb.SetParameterValue("Phone", "0471-6444002");
crystalReportViewer1.ReportSource = sb;
}
private void Load_Report(string BillNo)
{
string s = "Select i.Item_Name as [Item],s.Quantity as [Qty],i.ITEM_RETAIL_PRICE as [Price],s.Quantity*i.ITEM_RETAIL_PRICE as [Amount] from tbl_Item i Join tbl_Sales s on i.Item_id=s.Itemno where s.BillNo=" + BillNo;
SqlDataAdapter da1 = new SqlDataAdapter(s, d.con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
SalesBill sb = new SalesBill();
sb.SetDataSource(ds1.Tables[0]);
string SQL = "Select sm.admno,s.sname,sm.Discount,sm.Amount,Convert(varchar(20),sm.CurrDate,101),s.cstandard,std.division from tbl_SalesMaster sm inner join tbl_student s on s.adno=sm.admno inner join tbl_stddivision std on std.adno=s.adno where sm.BillNo=" + BillNo;
SqlDataAdapter da = new SqlDataAdapter(SQL, d.con);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow dr;
if (ds.Tables[0].Rows.Count >= 1)
{
dr = ds.Tables[0].Rows[0];
sb.SetParameterValue("BillNo", BillNo);
sb.SetParameterValue("Admno", dr[0].ToString());
sb.SetParameterValue("Name", dr[1].ToString());
sb.SetParameterValue("Discount", dr[2].ToString());
sb.SetParameterValue("TotalAmount", dr[3].ToString());
sb.SetParameterValue("SchoolName", "Nizamia Public School");
sb.SetParameterValue("DT", dr[4].ToString());
sb.SetParameterValue("std", dr[5].ToString());
sb.SetParameterValue("div", dr[6].ToString());
sb.SetParameterValue("Addr", "Pothencode, Trivandrum");
sb.SetParameterValue("Phone", "0471-6444002");
crystalReportViewer1.ReportSource = sb;
}
/*sb.SetParameterValue("BillNo", SchoolManagement.salesbillno);
* sb.SetParameterValue("Admno", SchoolManagement.sladmno);
* sb.SetParameterValue("Name", SchoolManagement.slname);
* sb.SetParameterValue("Discount", SchoolManagement.sldiscount);
* sb.SetParameterValue("TotalAmount", SchoolManagement.sltotal);
* //sb.SetParameterValue("SchoolName", SchoolManagement.SchoolName);
* sb.SetParameterValue("SchoolName", "Nizamia Public School");
* sb.SetParameterValue("DT", DateTime.Now.ToString());
* sb.SetParameterValue("std", SchoolManagement.rptstd);
* sb.SetParameterValue("div", SchoolManagement.rptdiv);
* sb.SetParameterValue("Addr", "Pothencode, Trivandrum");
* sb.SetParameterValue("Phone", "0471-6444002");
* crystalReportViewer1.ReportSource = sb;*/
}