public void RefreshDisplayTree( )
{
DisplayTreeListCtrl.TableName = this.TableName;
DisplayTreeListCtrl.InnerTreeList.Columns.Clear();
DisplayTreeListCtrl.ColumnConfigs = this.ColumnList;
DisplayTreeListCtrl.Manager.ConfigList = this.Manager.ConfigList;//new
DisplayTreeListCtrl.InitColumns();
#region Script
if (String.IsNullOrWhiteSpace(this.TableName))
{
if (String.IsNullOrWhiteSpace(Script) == false)
{
DataSet ds = DataQueryProvider.RunQuery(Script);
if (ds != null && ds.Tables.Count > 0)
{
Manager.Invalidate(ds);
DisplayTreeListCtrl.InnerTreeList.ColumnsCustomization();
}
}
return;
}
#endregion
if (DataCachingProvider.LookupTables.ContainsKey(this.TableName))
{
Manager.Invalidate(DataCachingProvider.LookupTables[this.TableName]);
}
else
{
ABCHelper.ConditionBuilder strBuilder = new ABCHelper.ConditionBuilder();
strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0} ", this.TableName));
if (DataStructureProvider.IsExistABCStatus(this.TableName))
{
strBuilder.AddCondition(QueryGenerator.GenerateCondition(this.TableName, ABCCommon.ABCColumnType.ABCStatus));
}
strBuilder.Append(String.Format(@" ORDER BY {0} DESC", DataStructureProvider.GetPrimaryKeyColumn(this.TableName)));
try
{
DataSet ds = DataQueryProvider.RunQuery(strBuilder.ToString());
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayTreeListCtrl.InnerTreeList.DataSource = ds.Tables[0];
}
}
catch (Exception ex)
{
}
}
this.DisplayTreeListCtrl.InnerTreeList.RefreshDataSource();
DisplayTreeListCtrl.InnerTreeList.ColumnsCustomization();
}
public void RefreshDisplayGrid( )
{
DisplayGridCtrl.TableName = this.TableName;
DisplayGridCtrl.Grid.Fields.Clear();
DisplayGridCtrl.FieldConfigs = this.FieldsList;
DisplayGridCtrl.InitFields();
DisplayGridCtrl.Grid.OptionsView.RowTreeWidth = RowTreeWidth;
DisplayGridCtrl.UseChartControl = UseChartControl;
DisplayGridCtrl.Script = Script;
if (String.IsNullOrWhiteSpace(this.TableName))
{
DisplayGridCtrl.LoadDataSourceFromScript();
return;
}
if (DataCachingProvider.LookupTables.ContainsKey(this.TableName))
{
this.DisplayGridCtrl.GridDataSource = DataCachingProvider.LookupTables[this.TableName];
}
else
{
ABCHelper.ConditionBuilder strBuilder = new ABCHelper.ConditionBuilder();
strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0}", this.TableName));
if (DataStructureProvider.IsExistABCStatus(this.TableName))
{
strBuilder.AddCondition(QueryGenerator.GenerateCondition(this.TableName, ABCCommon.ABCColumnType.ABCStatus));
}
strBuilder.Append(String.Format(@" ORDER BY {0} DESC", DataStructureProvider.GetPrimaryKeyColumn(this.TableName)));
try
{
DataSet ds = DataQueryProvider.RunQuery(strBuilder.ToString());
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayGridCtrl.GridDataSource = ds.Tables[0];
}
}
catch (Exception ex)
{
}
}
this.DisplayGridCtrl.RefreshDataSource();
DisplayGridCtrl.Grid.FieldsCustomization(splitContainerControl2.Panel2);
}
public BusinessObject GetFirstObject( )
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append(String.Format("Select Top(1) * From [{0}] ", TableName));
if (DataStructureProvider.IsExistABCStatus(TableName))
{
strBuilder.Append(" WHERE ");
strBuilder.Append(String.Format("[{0}]='{1}'", ABCCommon.ABCConstString.colABCStatus, ABCCommon.ABCConstString.ABCStatusAlive));
}
String strQuery = strBuilder.ToString();
if (DatabaseHelper.IsSQLConnection() == false)
{
strQuery = SQLiteDatabaseHelper.RepairSelectSQLite(strQuery);
}
DataSet ds = DatabaseHelper.RunQuery(strQuery);
return(BusinessObjectHelper.GetBusinessObject(ds, TableName));
}
public void RefreshDisplayGrid( )
{
DisplayGridView.TableName = this.TableName;
DisplayGridView.Columns.Clear();
DisplayGridView.Bands.Clear();
DisplayGridView.BandConfigs = this.BandsList;
DisplayGridView.ColumnConfigs = this.ColumnList;
DisplayGridView.LoadBands();
#region Script
if (String.IsNullOrWhiteSpace(this.TableName))
{
if (String.IsNullOrWhiteSpace(Script) == false)
{
DataSet ds = DataQueryProvider.RunQuery(Script);
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayGridCtrl.DataSource = ds.Tables[0];
this.DisplayGridCtrl.RefreshDataSource();
DisplayGridView.ShowCustomization();
}
}
return;
}
#endregion
if (DataCachingProvider.LookupTables.ContainsKey(this.TableName))
{
this.DisplayGridCtrl.DataSource = DataCachingProvider.LookupTables[this.TableName];
}
else
{
ABCHelper.ConditionBuilder strBuilder = new ABCHelper.ConditionBuilder();
strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0}", this.TableName));
if (DataStructureProvider.IsExistABCStatus(this.TableName))
{
strBuilder.AddCondition(QueryGenerator.GenerateCondition(this.TableName, ABCCommon.ABCColumnType.ABCStatus));
}
strBuilder.Append(String.Format(@" ORDER BY {0} DESC", DataStructureProvider.GetPrimaryKeyColumn(this.TableName)));
try
{
DataSet ds = DataQueryProvider.RunQuery(strBuilder.ToString());
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayGridCtrl.DataSource = ds.Tables[0];
}
}
catch (Exception ex)
{
}
}
this.DisplayGridCtrl.RefreshDataSource();
if (DisplayGridView.CustomizationForm == null || DisplayGridView.CustomizationForm.Visible == false)
{
DisplayGridView.ShowCustomization();
}
}