protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e) { try { if (e.CommandName == "Select") { GridDataItem dataitem = e.Item as GridDataItem; DataTable dd = Main.SelectJobFromRegister("CASE4", dataitem["REQUEST_ID"].Text, "", "", System.DateTime.Now); grdRequest.DataSource = dd; grdRequest.DataBind(); DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dataitem["REQUEST_ID"].Text, "", "", System.DateTime.Now); GrdEvents.DataSource = dtEvents; GrdEvents.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message; lblError.Visible = true; return; } }
private void BindGrdEvents() { GrdEvents.DataSource = null; GrdEvents.DataBind(); PnlSearch.BindControls(FilterDictionary, TableName); #region BetweenDateFromat string Date = ""; string Dt1 = "20170101"; string Dt2 = DateTime.Now.ToString("yyyyMMdd"); object DateFilter1 = Config.DateTimeFormat(TxtFilterEvents_StartDt.Text.Trim()); object DateFilter2 = Config.DateTimeFormat(TxtFilterEvents_EndDt.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>() { { "ID", TxtFilterEventsID.Text }, { "EventsTypesID", int.Parse(DListFilterEventsTypes.SelectedValue) }, { "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) }, { "EventsDirectionTypesID", int.Parse(DListFilterEventsDirectionTypes.SelectedValue) }, { "EventsPolicyTypesID", int.Parse(DListFilterEventsPolicyTypes.SelectedValue) }, { "Name(LIKE)", TxtFilterName.Text }, { "Subject(LIKE)", TxtFilterSubject.Text }, { "Place(LIKE)", TxtFilterPlace.Text }, { "Organizer(LIKE)", TxtFilterOrganizer.Text }, { "Events_StartDt(BETWEEN)", Config.DateTimeFilter(TxtFilterEvents_StartDt.Text, TxtFilterEvents_EndDt.Text) }, { "Events_EndDt(BETWEEN)", Config.DateTimeFilter(TxtFilterEvents_StartDt.Text, TxtFilterEvents_EndDt.Text) }, }; int PageNum; int RowNumber = 20; if (!int.TryParse(Config._GetQueryString("p"), out PageNum)) { PageNum = 1; } HdnPageNumber.Value = PageNum.ToString(); DALC.DataTableResult FilterList = DALC.GetFilterList(TableName, Dictionary, PageNum, RowNumber); if (FilterList.Count == -1) { return; } if (FilterList.Dt.Rows.Count < 1 && PageNum > 1) { Config.RedirectURL(string.Format("/tools/events/?p={0}", PageNum - 1)); } LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", FilterList.Count); int Total_Count = 0; if (FilterList.Count % RowNumber > 0) { Total_Count = (FilterList.Count / RowNumber) + 1; } else { Total_Count = FilterList.Count / RowNumber; } HdnTotalCount.Value = Total_Count.ToString(); PnlPager.Visible = FilterList.Count > RowNumber; GrdEvents.DataSource = FilterList.Dt; GrdEvents.DataBind(); }