public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptFamilyAid rpt = new rptFamilyAid();
rpt.Site = this.Site;
return(rpt);
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
StringBuilder query = new StringBuilder();
StringBuilder filter = new StringBuilder();
query.Append(@"SELECT tblHelp.ID, tblHelp.FCardNo, tblHelp.HeadofFamily, tblHelp.FName, tblHelp.Orakh, tblHelp.ReceiveDate, tblHelp.Status, tblHelp.Amount,
tblHelp.CompleteDate, tblHelp.SerialNo, tblHelp.Remarks, tblAids.Aid, tblFamilyMember.MemberName, tblHelp.AidFrom
FROM tblHelp INNER JOIN
tblAids ON tblHelp.HelpType = tblAids.ID INNER JOIN
tblFamilyMember ON tblHelp.Name = tblFamilyMember.FamilyMemberID ");
bool isWhereIncluded = false;
if (chkByAidType.Checked)
{
query.Append("where HelpType =" + cmbAidType.SelectedValue);
isWhereIncluded = true;
filter.Append("Aid Type=" + cmbAidType.Text + ",");
}
if (chkByFamilyCard.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.FCardNo='" + txtFamilyCardNo.Text.PadLeft(5, '0') + "'");
filter.Append("Family Card=" + txtFamilyCardNo.Text.PadLeft(5, '0') + ",");
}
if (chkByOrakh.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.Orakh='" + cmbOrakh.Text + "'");
filter.Append("Orakh=" + cmbOrakh.Text + ",");
}
if (chkByStatus.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.Status='" + cmbStatus.Text + "'");
filter.Append("Status=" + cmbStatus.Text + ",");
}
if (chkAidFrom.Checked)
{
query.Append("where AidFrom ='" + cmbAidFrom.Text + "'");
isWhereIncluded = true;
filter.Append("Aid From=" + cmbAidFrom.Text + ",");
}
query.Append(" ORDER BY tblHelp.FCardNo Asc");
Community.DBLayer DBLayer = new Community.DBLayer();
DataTable dt = DBLayer.GetDataByQuery(query.ToString());
MCKJ.ComDataSet dsCom = new ComDataSet();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dsCom.tblHelp.NewRow();
int index = dsCom.tblHelp.Rows.Count - 1;
for (int j = 0; j < dsCom.tblHelp.Columns.Count; j++)
{
dr[dsCom.tblHelp.Columns[j].ColumnName] = dt.Rows[i][dsCom.tblHelp.Columns[j].ColumnName];
}
dsCom.tblHelp.Rows.Add(dr);
}
MCKJ.Reports.FamilyAid.rptFamilyAid rptAidRpt = new rptFamilyAid();
MCKJ.Reports.FamilyAid.frmViewer frmViewer = new frmViewer();
rptAidRpt.SetDataSource(dsCom);
frmViewer.crystalReportViewer1.ReportSource = rptAidRpt;
string filterSettings = filter.ToString();
rptAidRpt.SetParameterValue("Filter", "");
if (filterSettings.Length > 0)
{
rptAidRpt.SetParameterValue("Filter", filterSettings.Substring(0, filterSettings.Length - 1));
}
frmViewer.Show();
//if (chkByAidType.Checked == false && chkByFamilyCard.Checked == false && chkByOrakh.Checked == false && chkByStatus.Checked == false)
//{
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}