private void ShowImportedDataasRpt(List <CSOMaster> oListSOMaster) { POS posdateset = new POS(); DataTable dtDailySale = posdateset.DailySales; foreach (CSOMaster oSOMaster in oListSOMaster) { foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drDailySale = dtDailySale.NewRow(); drDailySale["BranchName"] = oSOMaster.SOMstr_Branch; drDailySale["Address"] = currentBranch.CompBrn_Street; drDailySale["Road"] = currentBranch.CompBrn_Road; drDailySale["City"] = currentBranch.CompBrn_City; drDailySale["Phone"] = currentBranch.CompBrn_Phone; drDailySale["Mobile"] = currentBranch.CompBrn_Mobile; drDailySale["ItemName"] = oSODetails.SODet_ItemName; drDailySale["Qty"] = oSODetails.SODet_QTY; drDailySale["Rate"] = oSODetails.SODet_Price; drDailySale["Amount"] = oSODetails.SODet_Amount; drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt; drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt; drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt; dtDailySale.Rows.Add(drDailySale); } } rptDailySales orpt = new rptDailySales(); orpt.SetDataSource(posdateset); orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim()); orpt.SetParameterValue(1, oListSOMaster[0].SOMstr_Date.Date); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }
private void ShowReport() { #region 1 List <CSOMaster> oListSOMaster = LoadSOData(); POS posdateset = new POS(); DataTable dtDailySale = posdateset.DailySales; foreach (CSOMaster oSOMaster in oListSOMaster) { int i = 0; foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drDailySale = dtDailySale.NewRow(); //drDailySale["InvoiceNo"] = dr1["InvoiceNo"]; drDailySale["BranchName"] = oSOMaster.SOMstr_Branch; drDailySale["Address"] = currentBranch.CompBrn_Street; drDailySale["Road"] = currentBranch.CompBrn_Road; drDailySale["City"] = currentBranch.CompBrn_City; drDailySale["Phone"] = currentBranch.CompBrn_Phone; drDailySale["Mobile"] = currentBranch.CompBrn_Mobile; drDailySale["ItemName"] = oSODetails.SODet_ItemName; drDailySale["Qty"] = oSODetails.SODet_QTY; drDailySale["Rate"] = oSODetails.SODet_Price; drDailySale["Amount"] = oSODetails.SODet_Amount; drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt; if (i == 0) { drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt; } if (i != 0) { drDailySale["DiscAmount"] = 0; } drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt; drDailySale["PPrice"] = oSODetails.SODet_PPrice; dtDailySale.Rows.Add(drDailySale); i++; } } #endregion List <CReturnItem> oListCReturnItem = new List <CReturnItem>(); //List<CSOMaster> oListSOMasterretu = new List<CSOMaster>(); CSOBO oCSOBO = new CSOBO(); CResult oResult = new CResult(); DateTime date = dtpDate.Value.Date; oListCReturnItem = oCSOBO.ReadSalesReturn(dtpDate.Value.Date, currentBranch.CompBrn_Code); //oListCReturnItem.Add(oListSOMasterretu); New PosDataSet11 = new New(); DataTable dtReturn = PosDataSet11.ReturnItems; //foreach (CSOMaster oSoMaster in oListSOMasterretu) //{ //oListCReturnItem.Add(oSoMaster); //} foreach (CReturnItem oSoDetail in oListCReturnItem) { DataRow odr = dtReturn.NewRow(); odr["ItemName"] = oSoDetail.ItemName; odr["Ret_QTY"] = oSoDetail.Ret_QTY; odr["ItemPrice"] = float.Parse(oSoDetail.ItemPrice.ToString()); odr["BranchName"] = oSoDetail.Ret_BranchOID; odr["Ret_DiscountAmount"] = oSoDetail.Ret_DiscountAmount; //odr["ReturnDate"] = oSoDetail.date; dtReturn.Rows.Add(odr); } //ReturnReport re = new ReturnReport(); //re.SetDataSource(PosDataSet11); rptDailySales orpt = new rptDailySales(); orpt.SetDataSource(posdateset); //orpt.Load("ReturnReport.rpt"); orpt.OpenSubreport("ReturnReport.rpt").SetDataSource(PosDataSet11); orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim()); orpt.SetParameterValue(1, dtpDate.Value.Date); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }