private void InsertQueryResult(MC_QueryRequsetFactory _queryRequestFactory)
{
_queryRequestFactory.AddResultTable(this._queryModel.MainTable);
foreach (MDModel_Table_Column _tc in this._queryModel.MainTable.Columns)
{
if (_tc.ColumnDefine.DefaultResult)
{
_queryRequestFactory.AddResultTableColumn(this._queryModel.MainTable, _tc);
}
}
foreach (CheckedListBoxItem _item in this.checkedListBoxControl1.CheckedItems)
{
FixChildItem _itemData = _item.Value as FixChildItem;
MDModel_Table _table = _itemData.TableDefine;
_queryRequestFactory.AddResultTable(_table);
foreach (MDModel_Table_Column _tc2 in _table.Columns)
{
if (_tc2.ColumnDefine.DefaultResult)
{
_queryRequestFactory.AddResultTableColumn(_table, _tc2);
}
}
}
}
private MDQuery_Request CreateZGDQueryRequest(string _dh, DateTime _sdate, DateTime _edate)
{
string _qvName = "HG_GDFS.海关报关单";
MDModel_QueryModel _qv = MetaDataCache.GetQueryModelDefine(_qvName);
MC_QueryRequsetFactory _rf = new MC_QueryRequsetFactory();
_rf.QueryModelName = _qvName;
//加条件
MDQuery_ConditionItem _cItem = new MDQuery_ConditionItem();
_cItem.ColumnIndex = "1";
_cItem.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("VOYAGE_NO"));
_cItem.Operator = "等于";
_cItem.Values = new List <string>();
_cItem.Values.Add(_dh);
_rf.AddConditonItem(_cItem);
_cItem = new MDQuery_ConditionItem();
_cItem.ColumnIndex = "2";
_cItem.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("D_DATE"));
_cItem.Operator = "时间段";
_cItem.Values = new List <string>();
_cItem.Values.Add(_sdate.ToString("yyyyMMdd"));
_cItem.Values.Add(_edate.ToString("yyyyMMdd"));
_rf.AddConditonItem(_cItem);
_rf.AddExpression("1*2");
//加结果
_rf.AddResultTable(_qv.MainTable);
foreach (MDModel_Table_Column _tc in _qv.MainTable.Columns)
{
_rf.AddResultTableColumn(_qv.MainTable, _tc);
}
foreach (string _cTName in _qv.ChildTableDict.Keys)
{
MDModel_Table _ctable = _qv.ChildTableDict[_cTName];
_rf.AddResultTable(_ctable);
foreach (MDModel_Table_Column _ccol in _ctable.Columns)
{
_rf.AddResultTableColumn(_ctable, _ccol);
}
}
return(_rf.GetQueryRequest());
}
public void InsertResultFields2QueryRequest(MC_QueryRequsetFactory _queryRequestFactory)
{
_queryRequestFactory.AddResultTable(this.QueryModel.MainTable);
foreach (TreeListNode _node in this.treeList1.Nodes)
{
string _itemType = (string)_node.GetValue("ItemType");
if (_itemType == "TABLE")
{
//如果是表则处理
int _state = (int)_node.GetValue("State");
if (_state > 0)
{
//如果是选中部分或全选中状态
MDModel_Table _ctable = _node.GetValue("Data") as MDModel_Table;
_queryRequestFactory.AddResultTable(_ctable);
AddTableColumn(_queryRequestFactory, _ctable, _node);
}
}
}
}
private MDQuery_Request CreateBGDQueryRequest(string _dh)
{
string _qvName = "HG_GDFS.海关报关单";
MDModel_QueryModel _qv = MetaDataCache.GetQueryModelDefine(_qvName);
MC_QueryRequsetFactory _rf = new MC_QueryRequsetFactory();
_rf.QueryModelName = _qvName;
//加条件
MDQuery_ConditionItem _cItem = new MDQuery_ConditionItem();
_cItem.ColumnIndex = "1";
_cItem.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("ENTRY_ID_14"));
_cItem.Operator = "等于";
_cItem.Values = new List <string>();
foreach (string _s in _dh.Split(','))
{
_cItem.Values.Add(_s);
}
_rf.AddConditonItem(_cItem);
_rf.AddExpression("1");
//加结果
_rf.AddResultTable(_qv.MainTable);
foreach (MDModel_Table_Column _tc in _qv.MainTable.Columns)
{
_rf.AddResultTableColumn(_qv.MainTable, _tc);
}
foreach (string _cTName in _qv.ChildTableDict.Keys)
{
MDModel_Table _ctable = _qv.ChildTableDict[_cTName];
_rf.AddResultTable(_ctable);
foreach (MDModel_Table_Column _ccol in _ctable.Columns)
{
_rf.AddResultTableColumn(_ctable, _ccol);
}
}
return(_rf.GetQueryRequest());
}
private MDQuery_Request CreateBGDQueryRequest2(DateTime I_E_Date, string _IEFlagNum, string _formID)
{
string _qvName = "HG_GDFS.海关报关单";
MDModel_QueryModel _qv = MetaDataCache.GetQueryModelDefine(_qvName);
MC_QueryRequsetFactory _rf = new MC_QueryRequsetFactory();
_rf.QueryModelName = _qvName;
//加条件 D_Date> I_E_DATE-半年
MDQuery_ConditionItem _cItem_startDate = new MDQuery_ConditionItem();
_cItem_startDate.ColumnIndex = "1";
_cItem_startDate.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("D_DATE"));
_cItem_startDate.Operator = "大于";
_cItem_startDate.Values = new List <string>();
DateTime _startDate = I_E_Date.AddMonths(-6);
_cItem_startDate.Values.Add(_startDate.ToString("yyyyMMdd"));
_rf.AddConditonItem(_cItem_startDate);
//加条件 ENTRY_ID_SHORT = 进出口标志+单证号
MDQuery_ConditionItem _cItem = new MDQuery_ConditionItem();
_cItem.ColumnIndex = "2";
_cItem.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("ENTRY_ID_SHORT"));
_cItem.Operator = "等于";
_cItem.Values = new List <string>();
_cItem.Values.Add(string.Format("{0}{1}", _IEFlagNum, _formID));
_rf.AddConditonItem(_cItem);
//加条件 D_DATE<I_E_DATE
MDQuery_ConditionItem _cItem_endDate = new MDQuery_ConditionItem();
_cItem_endDate.ColumnIndex = "3";
_cItem_endDate.Column = new MDQuery_TableColumn(_qv.MainTable.GetColumnByName("D_DATE"));
_cItem_endDate.Operator = "小于";
_cItem_endDate.Values = new List <string>();
DateTime _endDate = I_E_Date.AddDays(1);
_cItem_endDate.Values.Add(_endDate.ToString("yyyyMMdd"));
_rf.AddConditonItem(_cItem_endDate);
_rf.AddExpression("1*2*3");
//加结果
_rf.AddResultTable(_qv.MainTable);
foreach (MDModel_Table_Column _tc in _qv.MainTable.Columns)
{
_rf.AddResultTableColumn(_qv.MainTable, _tc);
}
foreach (string _cTName in _qv.ChildTableDict.Keys)
{
MDModel_Table _ctable = _qv.ChildTableDict[_cTName];
_rf.AddResultTable(_ctable);
foreach (MDModel_Table_Column _ccol in _ctable.Columns)
{
_rf.AddResultTableColumn(_ctable, _ccol);
}
}
return(_rf.GetQueryRequest());
}