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