protected void LnkExportExcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename = BaxisKecirilenQurumlar.xls");
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 1].Visible = false;
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 2].Visible = false;
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 3].Visible = false;
GrdAuditsOrganizations.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 1].Visible = false;
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 2].Visible = false;
GrdAuditsOrganizations.Columns[GrdAuditsOrganizations.Columns.Count - 3].Visible = false;
}
void BindGrid()
{
if (Session[_FilterSessionName] != null)
{
var DictionarySession = (Dictionary <string, object>)Session[_FilterSessionName];
if (DictionarySession.Count != 0)
{
TxtRowIndexFilter.Text = DictionarySession["RowIndex"]._ToString();
DlistRegionalCenterFilter.SelectedValue = DictionarySession["RegionalCentersID"]._ToString();
DListParentOrganizationFilter.SelectedValue = DictionarySession["ParentOrganizationsID"]._ToString();
DListTopOrganizationFilter_SelectedIndexChanged(null, null);
DListSubOrganizationFilter.SelectedValue = DictionarySession["OrganizationsID"]._ToString();
DlistVisitTypeFilter.SelectedValue = DictionarySession["VisitTypeID"]._ToString();
TxtVisitDtStartFilter.Text = DictionarySession["StartVisit_Dt"]._ToString();
TxtVisitDtEndFilter.Text = DictionarySession["EndVisit_Dt"]._ToString();
TxtDescriptionFilter.Text = DictionarySession["Descriptions"]._ToString();
DListDatePriority.SelectedValue = DictionarySession["DatePriority"]._ToString();
DListPageSize.SelectedValue = DictionarySession["PageSize"]._ToString();
}
}
#region BetweenDateFromat
string Date = "";
string Dt1 = "19000101";
string Dt2 = DateTime.Now.ToString("yyyyMMdd");
object DateFilter1 = Config.DateTimeFormat(TxtVisitDtStartFilter.Text.Trim());
object DateFilter2 = Config.DateTimeFormat(TxtVisitDtEndFilter.Text.Trim());
if (DateFilter1 == null && DateFilter2 == null)
{
Date = "";
}
else
{
if (DateFilter1 != null)
{
Dt1 = ((DateTime)DateFilter1).ToString("yyyyMMdd");
}
if (DateFilter2 != null)
{
Dt2 = ((DateTime)DateFilter2).ToString("yyyyMMdd");
}
Date = Dt1 + "&" + Dt2;
}
#endregion
var Dictionary = new Dictionary <string, object>()
{
{ "RegionalCentersID", DlistRegionalCenterFilter.SelectedValue },
{ "ParentOrganizationsID", DListParentOrganizationFilter.SelectedValue },
{ "OrganizationsID", DListSubOrganizationFilter.SelectedValue },
{ "VisitTypeID", DlistVisitTypeFilter.SelectedValue },
{ "Visit_Dt(BETWEEN)", Date },
{ "Descriptions(LIKE)", TxtDescriptionFilter.Text }
};
string OrderByType = "desc";
if (DListDatePriority.SelectedValue == "20")
{
OrderByType = "asc";
}
//Sira sayina gore filteri elave olaraq gonderirik
int RowIndex = -1;
if (!int.TryParse(TxtRowIndexFilter.Text, out RowIndex))
{
RowIndex = -1;
}
int PageNum;
int RowNumber = 30;
if (DListPageSize.SelectedValue == "20")
{
RowNumber = 10000;
}
if (!int.TryParse(Config._GetQueryString("p"), out PageNum))
{
PageNum = 1;
}
// Axirinci sehifeni secmedikce Cache temizlemirik herdefe count almasin deye
if (PageNum >= (Cache[_CountCacheName]._ToInt32() / RowNumber))
{
Cache.Remove(_CountCacheName);
}
HdnPageNumber.Value = PageNum.ToString();
DALC.DataTableResult ApplicationsList = DALC.GetAuditsOrganizations(Dictionary, PageNum, RowNumber, new object[] { RowIndex }, OrderByType);
if (ApplicationsList.Count == -1)
{
return;
}
if (ApplicationsList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/AuditsOrganizations/?p={0}", PageNum - 1));
}
int Total_Count = ApplicationsList.Count % RowNumber > 0 ? (ApplicationsList.Count / RowNumber) + 1 : ApplicationsList.Count / RowNumber;
HdnTotalCount.Value = Total_Count.ToString();
PnlPager.Visible = ApplicationsList.Count > RowNumber;
GrdAuditsOrganizations.DataSource = ApplicationsList.Dt;
GrdAuditsOrganizations.DataBind();
LblCountInfo.Text = string.Format("Axtarış üzrə nəticə: {0}", ApplicationsList.Count);
}
