public void InsertConditions2QueryRequest(MC_QueryRequsetFactory _queryRequestFactory) { _queryRequestFactory.AddExpression(this.textEdit1.EditValue.ToString()); foreach (SinoSZUC_ConditionItem _c in this.xtraScrollableControl1.Controls) { MDQuery_ConditionItem _cItem = _c.GetConditionItem(); _queryRequestFactory.AddConditonItem(_cItem); } }
public void InsertConditions2QueryRequest(MC_QueryRequsetFactory _queryRequestFactory) { string _expression = ""; string _fg = ""; foreach (SinoSZUC_ConditionItem _c in this.xtraScrollableControl1.Controls) { string _msg = ""; if (_c.CheckInput(ref _msg)) { MDQuery_ConditionItem _cItem = _c.GetConditionItem(); _queryRequestFactory.AddConditonItem(_cItem); _expression += string.Format("{0}{1}", _fg, _cItem.ColumnIndex); _fg = "*"; } } _queryRequestFactory.AddExpression(_expression); }
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()); }
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()); }