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(); }