public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
challanPrint rpt = new challanPrint();
rpt.Site = this.Site;
return(rpt);
}
public PrintChallan(string invoiceNo)
{
try
{
InitializeComponent();
string sqlstr1 = @"SELECT invoiceDetails.invoiceNo as invoiceNo, invoiceDetails.invoiceDate as invoiceDate, invoiceDetails.shipName as shipName, userDetails.city as city,
invoiceDetails.shipGstIn as shipGstIn, invoiceDetails.shipState as shipState, invoiceDetails.poNo, invoiceDetails.poDate,
invoiceDetails.shipCode as shipCode, invoiceDetails.totalQnty as totalQnty, invoiceProductDetails.productName as productName,
invoiceProductDetails.productCode as productCode, invoiceProductDetails.productQnty as productQnty, customerDetails.custphoneNumber,
customerDetails.custname as custname, customerDetails.custstate as custstate, customerDetails.custPanno as custPanno, customerDetails.shipPanno as shipPanno,
customerDetails.custcode as custcode, customerDetails.custgstin as custgstin, userDetails.name as name, userDetails.companyname as companyname, userDetails.panno as panno,
userDetails.email as email, userDetails.phoneNumber as phoneNumber, userDetails.gstin as gstin, userDetails.state as state,
userDetails.code as code, (invoiceDetails.shipAddress || "", "" || invoiceDetails.shipLandmark || "", "" || invoiceDetails.shipCity || ""-"" || invoiceDetails.shipPinCode) AS shipAddress,
(customerDetails.custaddress || "", "" || customerDetails.custlandmark || "", "" || customerDetails.custcity || ""-"" || customerDetails.custpincode) AS custaddress,
(userDetails.address || "", "" || userDetails.landmark || "", "" || userDetails.city || ""-"" || userDetails.pincode) AS address
FROM invoiceDetails
INNER JOIN invoiceProductDetails ON invoiceProductDetails.invoiceId = invoiceDetails.invoiceId
INNER JOIN customerDetails ON customerDetails.custId = invoiceDetails.custId
INNER JOIN userDetails ON userDetails.userId = invoiceDetails.userId
WHERE invoiceDetails.invoiceNo ='" + invoiceNo + "' AND invoiceDetails.userId ='" + BaseModel.Instance.CompanyId + "' AND invoiceDetails.financialYear='" + BaseModel.Instance.FinancialYear + "' AND invoiceDetails.IsActive = 1 ";
//LEFT JOIN additionalCharges ON additionalCharges.invoiceId = invoiceDetails.invoiceId
//additionalCharges.chargeName as chargeName, additionalCharges.chargeAmount as chargeAmount
InvoiceDetails dsVoucher = m1.selectDataAdapter(sqlstr1, 1);
string sqlstr = "select invoiceId from invoiceDetails WHERE invoiceDetails.invoiceNo ='" + invoiceNo + "' AND invoiceDetails.userId ='" + BaseModel.Instance.CompanyId + "' AND invoiceDetails.financialYear='" + BaseModel.Instance.FinancialYear + "' AND invoiceDetails.IsActive = 1 LIMIT 1";
int invoiceId = Convert.ToInt32(m1.scaler(sqlstr));
sqlstr = "select GROUP_CONCAT(challanNo) FROM invoiceChallanDetails WHERE invoiceId = " + invoiceId + " ";
string challanNOs = m1.scaler(sqlstr);
for (int i = 0; i < dsVoucher.Tables[0].Rows.Count; i++)
{
dsVoucher.Tables[0].Rows[i]["challanNo"] = challanNOs;
}
ReportDocument cryRpt = new challanPrint();
cryRpt.DataSourceConnections.Clear();
cryRpt.SetDataSource(dsVoucher.Tables[0]);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (Exception e1)
{
MessageBox.Show("Error :" + e1.Message);
}
}