public static Component GetTableAdapterToHistoricalData(Component adapter, string endDateField, string StartDateField, DateTime?HistolicalPoint, Type typeTableAdapter, int commandIndex)
{
WebInitializer.Initialize();
QueryConditionList queryConditions = GetHistoricalCondition(endDateField, StartDateField, HistolicalPoint);
var queryGenerator = new QueryGenerator(adapter, commandIndex);
return(queryGenerator.GetTableAdapter(queryConditions));
}
public static QueryConditionList GetHistoricalOverCondition(string endDateField, DateTime?HistolicalPoint)
{
var queryConditions = new QueryConditionList();
DateTime Date = HistolicalPoint ?? DateTime.Now;
var condition = new QueryCondition(endDateField, ColumnFilterType.Less, Date, null);
queryConditions.Add(condition);
return(queryConditions);
}
public void SetToViewConditions(QueryConditionList queryConditions)
{
if (queryConditions != null)
{
var view = (TableDataSourceView)GetData();
foreach (QueryCondition queryCondition in queryConditions)
{
view.CustomConditions.Add(queryCondition);
}
}
}
public override void ShowNewReport(string reportUrl, QueryConditionList conditionList)
{
var parameters = conditionList.GetFilterParameters();
var sb = new StringBuilder();
sb.Append(ReportInitializerSection.GetReportInitializerSection().ReportingServicesPageViewer);
sb.Append("?");
sb.Append(reportUrl);
foreach (var parameter in parameters)
{
sb.Append("&");
sb.Append(parameter.Key);
sb.Append("=");
sb.Append(parameter.Value);
}
HttpContext.Current.Response.Redirect(sb.ToString());
}
public static QueryConditionList GetHistoricalCondition(string endDateField, string StartDateField, DateTime?HistolicalPoint)
{
var queryConditions = new QueryConditionList();
DateTime Date = HistolicalPoint ?? DateTime.Now;
var startDateCondition = new QueryCondition(StartDateField, ColumnFilterType.LessOrEqual, Date, null);
queryConditions.Add(startDateCondition);
var nullEndDateCondition = new QueryCondition(endDateField, ColumnFilterType.IsNull);
var lessEndDateCondition = new QueryCondition(endDateField, ColumnFilterType.MoreOrEqual, Date, null);
var endDateCondition = new QueryCondition();
endDateCondition.Conditions = new QueryConditionList {
ConditionJunction = ConditionJunction.Or
};
endDateCondition.Conditions.Add(nullEndDateCondition);
endDateCondition.Conditions.Add(lessEndDateCondition);
queryConditions.Add(endDateCondition);
return(queryConditions);
}
protected void FillView()
{
var view = (TableDataSourceView)GetData();
QueryConditionList queryConditions = GetQueryConditions();
view.FillType = TableDataSourceFillType.Always;
SetToViewConditions(queryConditions);
try
{
gridView.DataBind();
GridViewFilled = true;
gridView.SelectedIndex = -1;
hiddenField.Value = String.Empty;
EmptyDataText = LookupControlsResources.SNoDataByFilterCriteria;
}
finally
{
RemoveFromViewConditions(queryConditions);
view.FillType = TableDataSourceFillType.Never;
}
}
private void LoadFiltersState()
{
var sid = GetSidBytes();
// Loading user dependend filters state settings
// In case there is no user setting apply default settings
StorageValues storageValues = StorageValues.GetStorageValues(string.Format("{0}_{1}", Page.AppRelativeVirtualPath, ClientID), sid);
if (storageValues != null)
{
foreach (ColumnFilterStorage storage in ColumnFilterStorages)
{
storageValues.SetStorage(storage);
}
}
else
{
WebInitializer.Initialize();
foreach (ColumnFilterStorage storage in ColumnFilterStorages)
{
ColumnFilterType columnFilterType = (ColumnFilterType)(DataSetResourceManager.GetColumnExtProperty(
dataTable.Columns[storage.Name], ColumnExtProperties.FILTER_DEFAULT_CONDITION) ?? ColumnFilterType.None);
if (columnFilterType != ColumnFilterType.None)
{
if (!dataTable.Columns.Contains(storage.Name))
{
continue;
}
object[] values = new object[2];
values[0] = DataSetResourceManager.GetColumnExtProperty(dataTable.Columns[storage.Name], ColumnExtProperties.FILTER_DEFAULT_VALUE_1) ?? null;
values[1] = DataSetResourceManager.GetColumnExtProperty(dataTable.Columns[storage.Name], ColumnExtProperties.FILTER_DEFAULT_VALUE_2) ?? null;
string codeField = (String)DataSetResourceManager.GetColumnExtProperty(dataTable.Columns[storage.Name], ColumnExtProperties.FILTER_DEFAULT_VALUE_CODE_FIELD);
if (storage.IsRefBound && !string.IsNullOrEmpty(codeField))
{
for (int i = 0; i < values.Length; i++)
{
if (values[i] != null)
{
DataTable table = (DataTable)storage.RefDataSource;
QueryConditionList queryConditionList = new QueryConditionList();
QueryCondition queryCondition = new QueryCondition(codeField, ColumnFilterType.Equal, values[i], null);
queryConditionList.Add(queryCondition);
Type tableAdapterType = TableAdapterTools.GetTableAdapterType(table.GetType());
QueryGenerator queryGenerator;
if (table.Columns.IndexOf("dateEnd") != -1 && table.Columns.IndexOf("dateStart") != -1)
{
Component adapter = HistoricalData.GetTableAdapterToHistoricalData("dateEnd", "dateStart", DateTime.Now, tableAdapterType, 0);
queryGenerator = new QueryGenerator(adapter);
}
else
{
queryGenerator = new QueryGenerator(table);
}
queryGenerator.TopCount = 1;
queryGenerator.Fill(table, queryConditionList);
if (table.Rows.Count != 0)
{
values[i] = table.Rows[0][storage.ValueColumn];
}
}
}
}
storage.FilterType = columnFilterType;
try
{
for (int i = 0; i != 2; i++)
{
if (values[i] != null)
{
storage.SetValue(i, Convert.ChangeType(values[i], storage.DataType));
}
}
}
catch (InvalidCastException)
{
}
}
}
}
}
