private void AddCalculationField(string _displayName, string _algorithm, string _queryModelName, MDModel_Table _tb, string _resultType)
{
MD_ViewTableColumn _vtc = new MD_ViewTableColumn("", "", "", true, true, false, false, false, "", 0, 0);
_vtc.TableColumn = new MD_TableColumn("", "", "", true, _resultType, 0, 0, 0, "", "", 0, _displayName, "",
80, 1, 0, true, 0, "", "", "");
MDModel_Table_Column _newtc = new MDModel_Table_Column(_vtc);
_newtc.ColumnType = QueryColumnType.CalculationColumn;
_newtc.ColumnTitle = _displayName;
_newtc.ColumnName = "";
_newtc.ColumnAlgorithm = _algorithm;
_newtc.ColumnAlias = _tb.TableName + "_EXP" + ExpIndex++;
_newtc.QueryModelName = _queryModelName;
_newtc.ColumnDataType = _resultType;
_newtc.TableName = _tb.TableName;
_newtc.TID = _tb.TableID;
_tb.Columns.Add(_newtc);
_tb.AliasDict.Add(_newtc.ColumnAlias, _newtc);
this.treeList1.BeginUpdate();
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_newtc);
_tcItem.ParentID = _tb.TableDefine.TableID;
_tcItem.State = 2;
List <SinoSZUC_FieldTreeItem> _listData = this.treeList1.DataSource as List <SinoSZUC_FieldTreeItem>;
_listData.Add(_tcItem);
this.treeList1.EndUpdate();
this.treeList1.RefreshDataSource();
}
private void CreateList()
{
List <SinoSZUC_FieldTreeItem> _ret = new List <SinoSZUC_FieldTreeItem>();
SinoSZUC_FieldTreeItem _TableItem = new SinoSZUC_FieldTreeItem(TableDefine);
_ret.Add(_TableItem);
foreach (MDModel_Table_Column _tc in TableDefine.Columns)
{
if (_tc.ColumnDefine.CanShowAsResult)
{
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_tc);
_ret.Add(_tcItem);
}
}
this.treeList1.BeginUpdate();
this.treeList1.DataSource = _ret;
this.treeList1.ExpandAll();
this.treeList1.EndUpdate();
using (MetaDataQueryServiceClient _msc = new MetaDataQueryServiceClient())
{
List <MDQuery_ComputeColumnDefine> _personList = _msc.GetPersonSavedComputField(TableDefine.QueryModelName, TableDefine.TableName).ToList <MDQuery_ComputeColumnDefine>();
this.gridView1.BeginUpdate();
this.sinoCommonGrid1.DataSource = _personList;
this.gridView1.EndUpdate();
}
}
public static IList <SinoSZUC_FieldTreeItem> GetListByQueryView(MDModel_QueryModel _model)
{
List <SinoSZUC_FieldTreeItem> _ret = new List <SinoSZUC_FieldTreeItem>();
SinoSZUC_FieldTreeItem _mainTableItem = new SinoSZUC_FieldTreeItem(_model.MainTable);
_ret.Add(_mainTableItem);
foreach (MDModel_Table_Column _tc in _model.MainTable.Columns)
{
if (_tc.ColumnDefine.CanShowAsCondition || _tc.ColumnDefine.CanShowAsResult)
{
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_tc);
_ret.Add(_tcItem);
}
}
foreach (MDModel_Table _ctable in _model.ChildTableDict.Values)
{
SinoSZUC_FieldTreeItem _cTableItem = new SinoSZUC_FieldTreeItem(_ctable);
_ret.Add(_cTableItem);
foreach (MDModel_Table_Column _tc in _ctable.Columns)
{
if (_tc.ColumnDefine.CanShowAsCondition || _tc.ColumnDefine.CanShowAsResult)
{
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_tc);
_ret.Add(_tcItem);
}
}
}
return(_ret);
}
public static IList <SinoSZUC_FieldTreeItem> GetSingleLineDefaultListByQueryView(MDModel_QueryModel _model)
{
List <SinoSZUC_FieldTreeItem> _ret = new List <SinoSZUC_FieldTreeItem>();
SinoSZUC_FieldTreeItem _mainTableItem = new SinoSZUC_FieldTreeItem(_model.MainTable);
_ret.Add(_mainTableItem);
bool _haveSelected = false;
foreach (MDModel_Table_Column _tc in _model.MainTable.Columns)
{
if (_tc.ColumnDefine.CanShowAsCondition || _tc.ColumnDefine.CanShowAsResult)
{
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_tc);
if (_tc.ColumnDefine.DefaultResult)
{
_tcItem.State = 2;
_haveSelected = true;
}
_ret.Add(_tcItem);
}
}
if (_haveSelected)
{
_mainTableItem.State = 1;
}
foreach (MDModel_Table _ctable in _model.ChildTableDict.Values)
{
if (_ctable.TableDefine.ViewTableRelationType == MDType_ViewTableRelation.SingleChildRecord)
{
_haveSelected = false;
SinoSZUC_FieldTreeItem _cTableItem = new SinoSZUC_FieldTreeItem(_ctable);
_ret.Add(_cTableItem);
foreach (MDModel_Table_Column _tc in _ctable.Columns)
{
if (_tc.ColumnDefine.CanShowAsCondition || _tc.ColumnDefine.CanShowAsResult)
{
SinoSZUC_FieldTreeItem _tcItem = new SinoSZUC_FieldTreeItem(_tc);
if (_tc.ColumnDefine.DefaultResult)
{
_tcItem.state = 2;
_haveSelected = true;
}
_ret.Add(_tcItem);
}
}
if (_haveSelected)
{
_cTableItem.State = 1;
}
}
}
return(_ret);
}
/// <summary>
/// 显示单行默认结果列---(数据审核用)
/// </summary>
public void ShowSingleLineDefaultList()
{
if (QueryModel == null)
{
return;
}
this.treeList1.BeginUpdate();
IList <SinoSZUC_FieldTreeItem> _data = SinoSZUC_FieldTreeItem.GetSingleLineDefaultListByQueryView(queryModel);
this.treeList1.DataSource = _data;
this.treeList1.EndUpdate();
this.treeList1.ExpandAll();
}
public void ShowFieldsList()
{
if (QueryModel == null)
{
return;
}
this.treeList1.BeginUpdate();
IList <SinoSZUC_FieldTreeItem> _data = SinoSZUC_FieldTreeItem.GetListByQueryView(queryModel);
SelectedFirstTable(_data);
this.treeList1.DataSource = _data;
this.treeList1.EndUpdate();
}
