private void InitReferenceDiagram(String Cell)
{
tableFlow1.Clear();
SheetReference Reference = CellType.ReferenceInfo as SheetReference;
if (Reference != null && !String.IsNullOrEmpty(Reference.ReferenceXml))
{
TableName = Reference.TableName;
ColumnName = Reference.ColumnName;
DataFilter = Reference.DataFilter;
LoadFromXml(Reference.ReferenceXml);
}
else
{
DataTableSchema DataTable = SheetConfiguration.DataTableSchema;
bool HaveItem = DataTable.HaveDataItem(Cell);
if (HaveItem)
{
FieldDefineInfo FieldInfo = DataTable.GetDataItem(Cell);
if (FieldInfo != null && DataTable.Schema != null)
{
TableName = DataTable.Schema.Name;
ColumnName = FieldInfo.FieldName;
AppendTableByTableName(TableName, false);
}
else
{
MessageBox.Show("表单‘" + SheetConfiguration.Description + "’没有设置数据项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
public SheetReferenceFilterDialog(String TableName, DataFilterCondition dataFilterCondition)
{
InitializeComponent();
this.TableName = TableName;
this.dataFilterCondition = dataFilterCondition;
}
public SheetReferenceDialog(int RowIndex, int ColumnIndex, DownListCellType CellType)
{
InitializeComponent();
this.SheetConfiguration = SheetConfiguration;
this.RowIndex = RowIndex;
this.ColumnIndex = ColumnIndex;
this.CellType = CellType;
DataFilter = new DataFilterCondition();
}
protected override SQLDataFilterParameter[] GetParameters(DataFilterCondition condition)
{
if (condition.Parameter.Name == "ClientId")
{
if (condition.LeftOperand == string.Empty)
{
return(new SQLDataFilterParameter[] { });
}
ClientBLL requestedClient = ClientBLL.GetClinet(condition.LeftOperand);
DataFilterParameter dfp = new DataFilterParameter(
"ClientId", string.Empty, typeof(Guid), string.Empty, FilterConditionType.Comparison);
DataFilterCondition clientCondition = new DataFilterCondition(
dfp, FilterConditionType.Comparison, "=", ((requestedClient == null)? Guid.Empty : requestedClient.ClientUniqueIdentifier).ToString());
return(base.GetParameters(clientCondition));
}
else
{
return(base.GetParameters(condition));
}
}
/// <summary>
/// 增加数据筛选
/// </summary>
/// <param name="series">SeriesBase</param>
/// <param name="columnName">列名称</param>
/// <param name="value">列名称对应的筛选数值</param>
/// <param name="dataFilterCondition">DataFilterCondition枚举</param>
public static void AddDataFilter(this SeriesBase series, string columnName, object value, DataFilterCondition dataFilterCondition)
{
series.DataFilters.Add(new DataFilter(columnName, value.GetType().FullName, dataFilterCondition, value));
}
