public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmployeeRptALL rpt = new EmployeeRptALL();
rpt.Site = this.Site;
return(rpt);
}
private void button2_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 2000;
cmd.Connection = frmMainForm._MasterCon;
string FilterString = "";
bool FilterFlag = false;
string inFilter = "";
if (cmbLocation.SelectedItem != null)
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " LOCATION ='" + cmbLocation.SelectedItem.ToString() + "' ";
}
if (cmbCompany.SelectedItem != null)
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " COMPANY = '" + cmbCompany.SelectedItem.ToString() + "' ";
}
if (cmbDep.SelectedValue.ToString() != "")
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + "CRD_DEPARTMENT = '" + cmbDep.SelectedValue.ToString() + "'";
}
if (cmb_permit.SelectedValue.ToString() != "")
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " PERMITION = '" + cmb_permit.SelectedValue.ToString() + "'";
}
if (cmb_status.SelectedValue.ToString() != "")
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " STATUS = '" + cmb_permit.SelectedValue.ToString() + "'";
}
if (checkBox1.Checked)
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " IN_JOB = 1";
}
if (!checkBox1.Checked)
{
string initalFilter = "";
if (!FilterFlag)
{
initalFilter = " where ";
FilterFlag = true;
}
else
{
initalFilter = " and ";
}
FilterString += initalFilter + " IN_JOB = 0";
}
inFilter = "";
if (!FilterFlag)
{
inFilter = " where ";
FilterFlag = true;
}
else
{
inFilter = " and ";
}
FilterString += inFilter + " CRD_NAME NOT LIKE '%V' ";
cmd.CommandText = "SELECT EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, EMPLOYEE_CARDS.CRD_STARTING_DATE, EMPLOYEE_CARDS.CRD_EXPIRY_DATE, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_LAST_TRANSACTION_TYPE, EMPLOYEE_CARDS.CRD_DEPARTMENT,EMPLOYEE_CARDS.LOCATION,EMPLOYEE_CARDS.COMPANY,AR_NAME,ADDRESS,NATIONAL_ID,PHONE,STATUS,PERMITION,VALID_TO,AR_JOB,AR_DEP,STATUS_DATE FROM EMPLOYEE_CARDS " + FilterString + " order by CRD_NAME";
DataTable dt = new DataTable();
SqlDataAdapter _da = new SqlDataAdapter(cmd);
_da.Fill(dt);
frmReportViewer2 Viewer = new frmReportViewer2();
EmployeeRptALL rpt = new EmployeeRptALL();
rpt.Database.Tables[0].SetDataSource(dt);
Viewer.crystalReportViewer1.ReportSource = rpt;
Viewer.ShowDialog();
this.Close();
}
