public void GetFilterSQL()
{
//QueryParameterInfo[] parInfos = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams);
//string sqlFilter = MB.Orm.DbSql.SqlShareHelper.Instance.QueryParametersToSqlString(null, parInfos);
QueryParameterInfo info1 = new QueryParameterInfo("Code", "111", Util.DataFilterConditions.Equal);
QueryParameterInfo info2 = new QueryParameterInfo("Date", "222", Util.DataFilterConditions.Between);
info2.Value2 = "333";
QueryParameterInfo info3 = new QueryParameterInfo("Name", "4444", Util.DataFilterConditions.Like);
QueryParameterInfo[] parInfos = new QueryParameterInfo[3];
parInfos[0] = info1;
parInfos[1] = info2;
parInfos[2] = info3;
string sqlFilter = MB.Orm.DbSql.SqlShareHelper.Instance.QueryParametersToSqlString(null, parInfos);
string xmlFilterParams = @"<FilterRoot AdvanceFilter='False'><Parameter><PropertyName>CREATE_DATE</PropertyName><Value><![CDATA[2007/5/3 0:00:00]]></Value><Value2><![CDATA[2012/5/17 0:00:00]]></Value2><Condition>Between</Condition><DataType>DateTime</DataType><OrderIndex>0</OrderIndex><Limited>False</Limited><MultiValue>False</MultiValue></Parameter><Parameter><PropertyName>LAST_MODIFIED_DATE</PropertyName><Value><![CDATA[2007/5/17 0:00:00]]></Value><Value2><![CDATA[2012/5/17 0:00:00]]></Value2><Condition>Between</Condition><DataType>DateTime</DataType><OrderIndex>0</OrderIndex><Limited>False</Limited><MultiValue>False</MultiValue></Parameter></FilterRoot>";
parInfos = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams);
sqlFilter = MB.Orm.DbSql.SqlShareHelper.Instance.QueryParametersToSqlString(null, parInfos);
}
/// <summary>
/// 动态聚组查询获取数据
/// </summary>
/// <param name="setting"></param>
/// <param name="xmlFilterParams"></param>
/// <returns></returns>
public virtual System.Data.DataSet GetDynamicGroupQueryData(MB.Util.Model.DynamicGroupSetting setting, string xmlFilterParams)
{
using (MB.Orm.DB.OperationDatabaseScope scope = new OperationDatabaseScope(true)) {
QueryParameterInfo[] filters = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams);
return(new ObjectEditHelper().GetDynamicGroupQueryData(setting, filters));
}
}
/// <summary>
/// 根据过滤的条件获取指定类型实体对象的集合。
/// </summary>
/// <param name="xmlFilterParams">QueryParameterInfo[] 系列化后的字符窜</param>
/// <returns>得到的实体集合</returns> // [OperationBehavior(TransactionScopeRequired = true, TransactionAutoComplete = true)]
public virtual IList GetObjects(int dataInDocType, string xmlFilterParams)
{
using (MB.Orm.DB.OperationDatabaseScope scope = new OperationDatabaseScope(true)) {
QueryParameterInfo[] filters = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams);
var qh = MessageHeaderHelper.GetQueryBehavior(_MessageHeaderKey); //modify by aifang 动态列设置 var qh = MessageHeaderHelper.GetQueryBehavior();
return(new ObjectEditHelper(qh).GetObjects <System.Object>(this, ConvertDataInDocType(dataInDocType), filters));
}
}
/// <summary>
/// 系列为XML 字符窜。
/// </summary>
/// <returns></returns>
public string SerializerToXmlString()
{
if (_XmlSerializer == null)
{
_XmlSerializer = new MB.Util.Serializer.QueryParameterXmlSerializer();
}
return(_XmlSerializer.Serializer(_DataList.ToArray()));
}
/// <summary>
/// 提供对象数组转换为集合类的处理。
/// </summary>
/// <param name="xmlFilterParams">查询参数系列化字符窜</param>
public QueryParameterHelper(string xmlFilterParams)
{
if (_XmlSerializer == null)
{
_XmlSerializer = new MB.Util.Serializer.QueryParameterXmlSerializer();
}
var filters = _XmlSerializer.DeSerializer(xmlFilterParams);
_DataList = new List <QueryParameterInfo>(filters);
}
private void button2_Click_1(object sender, EventArgs e)
{
//frmTestMain frm = new frmTestMain();
//frm.ShowDialog();
// Form2 frm = new Form2();
// frm.ShowDialog();
List <MB.Util.Model.QueryParameterInfo> pars = new List <QueryParameterInfo>();
pars.Add(new QueryParameterInfo("Name", "站三", DataFilterConditions.Equal));
pars.Add(new QueryParameterInfo("Code", "站三234525", DataFilterConditions.GreaterOrEqual));
pars.Add(new QueryParameterInfo("Address", "站三2352525", DataFilterConditions.Equal));
MB.Util.Serializer.QueryParameterXmlSerializer s = new MB.Util.Serializer.QueryParameterXmlSerializer();
string xml = s.Serializer(pars.ToArray());
MB.Util.Model.QueryParameterInfo[] pp = s.DeSerializer(xml);
}