private void setGridThesisSource()
{
Business.university.Request.CheckOutRequestBusiness chrb = new Business.university.Request.CheckOutRequestBusiness();
DataTable dt = chrb.getThesisByFiltering(getDaneshFilter(), getFieldFilter(), txtFamily.Text.Trim(), txtStcode.Text.Trim());
grdThesis.DataSource = dt;
}
private void setGridSource_byEnterYear()
{
Business.university.Request.CheckOutRequestBusiness r = new Business.university.Request.CheckOutRequestBusiness();
var dt = r.getCheckoutFrequency_ByEnterYear();
grdEnter.DataSource = dt;
grdEnter.DataBind();
}
private void setGridSource_byDepartment()
{
Business.university.Request.CheckOutRequestBusiness r = new Business.university.Request.CheckOutRequestBusiness();
var dt = r.getCheckoutFrequency_ByDepartment();
grdDanesh.DataSource = dt;
grdDanesh.DataBind();
}
private void setGridSource_byPerson()
{
Business.university.Request.CheckOutRequestBusiness r = new Business.university.Request.CheckOutRequestBusiness();
var dt = r.getCheckoutFrequencyAllStudents();
grdReason.DataSource = dt;
grdReason.DataBind();
}
private void setGridSource_reasonIteration()
{
Business.university.Request.CheckOutRequestBusiness r = new Business.university.Request.CheckOutRequestBusiness();
var dt = r.getCheckoutFrequencyIteration();
grdReport.DataSource = dt;
grdReport.DataBind();
}
protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
System.Data.DataSet ds = new DataSet();
Business.university.Request.CheckOutRequestBusiness r = new Business.university.Request.CheckOutRequestBusiness();
bool allInOne = true;
if (!allInOne)
{
switch (drpReportType.SelectedItem.Value)
{
case "st":
ds.Tables.Add(r.getCheckoutFrequencyAllStudents());
ds.Tables[ds.Tables.Count - 1].TableName = "علت انصراف هر دانشجو";
break;
case "rsn":
ds.Tables.Add(r.getCheckoutFrequencyIteration());
ds.Tables[ds.Tables.Count - 1].TableName = "فراوانی در هر دسته بندی";
break;
case "dnsh":
ds.Tables.Add(r.getCheckoutFrequency_ByDepartment());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک دانشکده";
break;
case "lvl":
ds.Tables.Add(r.getCheckoutFrequency_ByLevel());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک مقطع";
break;
case "ent":
ds.Tables.Add(r.getCheckoutFrequency_ByEnterYear());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک ورودی";
break;
}
}
else
{
ds.Tables.Add(r.getCheckoutFrequencyAllStudents());
ds.Tables[ds.Tables.Count - 1].TableName = "علت انصراف هر دانشجو";
ds.Tables.Add(r.getCheckoutFrequencyIteration());
ds.Tables[ds.Tables.Count - 1].TableName = "فراوانی در هر دسته بندی";
ds.Tables.Add(r.getCheckoutFrequency_ByDepartment());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک دانشکده";
ds.Tables.Add(r.getCheckoutFrequency_ByLevel());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک مقطع";
ds.Tables.Add(r.getCheckoutFrequency_ByEnterYear());
ds.Tables[ds.Tables.Count - 1].TableName = "به تفکیک ورودی";
}
createExcel(ds, string.Format("{0} _ {1}", DateTime.Now.ToPeString().Replace("/", "-"), "گزارش علت انصراف دانشجویان"));
}
