/// <summary> /// Loads export histories list. /// </summary> private void LoadExportHistories() { lstExports.Items.Clear(); string where = null; int siteId = ValidationHelper.GetInteger(siteSelector.Value, 0); if (siteId != 0) { where += "ExportSiteID=" + siteSelector.Value; } else { where += "ExportSiteID IS NULL"; } DataSet ds = ExportHistoryInfoProvider.GetExportHistories(where, "ExportDateTime DESC", "ExportDateTime,ExportFileName,ExportID", 0); if (!DataHelper.DataSourceIsEmpty(ds)) { radExport.Enabled = true; foreach (DataRow dr in ds.Tables[0].Rows) { lstExports.Items.Add(new ListItem(ValidationHelper.GetString(dr["ExportDateTime"], "yyyy-mm-ddd") + " - " + ValidationHelper.GetString(dr["ExportFileName"], "filename"), ValidationHelper.GetString(dr["ExportID"], null))); } } }
/// <summary> /// Loads export histories list. /// </summary> private void LoadExportHistories() { lstExports.Items.Clear(); var where = new WhereCondition(); int siteId = ValidationHelper.GetInteger(siteSelector.Value, 0); if (siteId != 0) { where.Where("ExportSiteID", QueryOperator.Equals, siteSelector.Value); } else { where.WhereNull("ExportSiteID"); } var histories = ExportHistoryInfoProvider.GetExportHistories() .Where(where) .OrderByDescending("ExportDateTime") .Columns(new[] { "ExportDateTime", "ExportFileName", "ExportID" }); if (DataHelper.DataSourceIsEmpty(histories)) { return; } radExport.Enabled = true; foreach (DataRow dr in histories.Tables[0].Rows) { lstExports.Items.Add(new ListItem(ValidationHelper.GetString(dr["ExportDateTime"], "yyyy-mm-ddd") + " - " + ValidationHelper.GetString(dr["ExportFileName"], "filename"), ValidationHelper.GetString(dr["ExportID"], null))); } }