public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CtrInvoiceReport rpt = new CtrInvoiceReport(); rpt.Site = this.Site; return rpt; }
private void Data() { sb = new StringBuilder(); String sql; sb.Remove(0, sb.Length); sb.Append("SELECT "); sb.Append("A.InvoiceNumber, "); sb.Append("A.StatementHeadDatetime, "); sb.Append("C.CustomerName, "); sb.Append("B.SaleHeadId, "); sb.Append("(D.BankAccountNameBank+' '+'สาขา : '+D.BankAccountBrance) AS BankAccountNameBank, "); sb.Append("B.moneyPay "); sb.Append("FROM STATEMENT_HEAD A "); sb.Append("JOIN STATEMENT_DETAIL B "); sb.Append("ON A.StatementHeadId = B.StatementHeadId "); sb.Append("LEFT JOIN CUSTOMER C "); sb.Append("ON A.CustomerId = C.CustomerId "); sb.Append("LEFT JOIN BANKACCOUNT D "); sb.Append("ON D.BankAccountId = A.BankAccountId "); sb.Append("WHERE A.StatementHeadId = @StatementHeadId"); sql = sb.ToString(); com = new SqlCommand(sql, Conn); com.Parameters.Add("@StatementHeadId", SqlDbType.Int).Value = StatementHeadId; // dt = new SqlDataAdapter(com); dt.Fill(SaleDataset, "Sale"); Conn.Close(); Statement.CtrInvoiceReport Ctr = new CtrInvoiceReport(); Ctr.SetDataSource(SaleDataset.Tables[0]); CrvVC.ReportSource = Ctr; CrvVC.Refresh(); CrvVC.Show(); }