public void RefreshDisplayGrid( )
{
DisplayGridView.TableName = this.TableName;
DisplayGridView.Columns.Clear();
DisplayGridView.ColumnConfigs = this.ColumnList;
DisplayGridView.InitColumns();
#region Script
if (String.IsNullOrWhiteSpace(this.TableName))
{
if (String.IsNullOrWhiteSpace(Script) == false)
{
DataSet ds = ConnectionManager.DatabaseHelper.RunQuery(Script);
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayGridCtrl.DataSource = ds.Tables[0];
this.DisplayGridCtrl.RefreshDataSource();
DisplayGridView.ShowCustomization();
}
}
return;
}
#endregion
if (ABCDataLib.Tables.CachingProvider.LookupTables.ContainsKey(this.TableName))
{
this.DisplayGridCtrl.DataSource = ABCDataLib.Tables.CachingProvider.LookupTables[this.TableName];
}
else
{
ConditionBuilder strBuilder = new ConditionBuilder();
strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0} ", this.TableName));
if (ABCDataLib.Tables.StructureProvider.IsExistABCStatus(this.TableName))
{
strBuilder.AddCondition(ABCDataLib.Generation.QueryGenerator.GenerateCondition(this.TableName, DataDefine.ColumnType.ABCStatus));
}
strBuilder.Append(String.Format(@" ORDER BY {0} DESC", ABCDataLib.Tables.StructureProvider.GetPrimaryKeyColumn(this.TableName)));
try
{
DataSet ds = ConnectionManager.DatabaseHelper.RunQuery(strBuilder.ToString());
if (ds != null && ds.Tables.Count > 0)
{
this.DisplayGridCtrl.DataSource = ds.Tables[0];
}
}
catch (Exception ex)
{
}
}
this.DisplayGridCtrl.RefreshDataSource();
DisplayGridView.ShowCustomization();
}
public void Test_Block()
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
ConditionBuilder builder = new ConditionBuilder();
builder.Append("A.CreateTime", SqlOperator.Equal, DateTime.Now);
builder.Between("B.CreateTime", DateTime.Now, DateTime.Now.AddDays(1));
//builder.Block(RelationType.And, childBuilder);
builder.Or(child =>
{
child.Equal("D.CreateTime", DateTime.Now);
child.Equal("E.CreateTime", DateTime.Now);
child.Equal("E.CreateTime", DateTime.Now);
child.And(c2 =>
{
c2.Append("HH.CreateTime", SqlOperator.Equal, 5);
});
}).Or(child =>
{
child.Append(RelationType.And, "E.CreateTime", SqlOperator.Equal, DateTime.Now);
});
builder.Append(RelationType.And, "F.CreateTime", SqlOperator.Equal, DateTime.Now);
builder.Append(RelationType.And, "A.ID", SqlOperator.In, new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 });
builder.Append(RelationType.And, "B.ID", SqlOperator.In, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
builder.AppendRaw("E.CreateTime like '%123456%'");
builder.Between("H.CreateTime", DateTime.Now, DateTime.Now.AddDays(5));
var result = builder.ToString();
stopwatch.Stop();
var param = builder.GetParamDict().ToJson();
Console.WriteLine(result);
Console.WriteLine(param);
Console.WriteLine(stopwatch.Elapsed.Milliseconds);
}