/// <summary>
/// Generate filter according to each query item(along with filter description)
/// </summary>
public BusinessFilter GetBusinessFilter(out string filterDescription)
{
BusinessFilter queryFilter = new BusinessFilter(this.BusinessObjectView.BusinessObjectName);
HtmlTable queryTable = this.queryHolder.FindControl("__queryTable") as HtmlTable;
AndOr filterJunction = GetFilterJunction(queryTable);
StringBuilder queryDesc = new StringBuilder();
// queryTable的最后一行是queryType（满足全部、满足任一）
for (int i = 0; i < queryTable.Rows.Count - 1; i++)
{
HtmlTableRow queryItem = queryTable.FindControl("__queryitem_" + i.ToString()) as HtmlTableRow;
HtmlInputCheckBox checkbox = queryTable.FindControl("__checkbox_" + i.ToString()) as HtmlInputCheckBox;
if (checkbox.Checked)
{
LiteralControl desc = queryTable.FindControl("__desc_" + i.ToString()) as LiteralControl;
ViewItemDisplayType itemType = (ViewItemDisplayType)int.Parse(queryItem.Attributes["displayType"]);
if (itemType == ViewItemDisplayType.CheckBox)
{
// Filter
HtmlInputCheckBox boolCtl = queryTable.FindControl("__bool_" + i.ToString()) as HtmlInputCheckBox;
if (queryItem.Attributes["isVirtual"] != "true")
{
queryFilter.AddFilterItem(queryItem.Attributes["fieldName"],
Convert.ToInt32(boolCtl.Checked).ToString(), Operation.Equal, FilterType.NumberType, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
else
{
queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + "=" + Convert.ToInt32(boolCtl.Checked).ToString(), queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
// Desc
queryDesc.AppendFormat("{0}：{1}.", desc.Text, boolCtl.Checked);
}
else if (itemType == ViewItemDisplayType.Literal)
{
// Filter
HtmlInputText textbox = queryTable.FindControl("__textbox_" + i.ToString()) as HtmlInputText;
if (textbox.Value != string.Empty)
{
GlobalFacade.PageContext pgCtx = GlobalFacade.SystemContext.GetContext().GetPageContext(this.openerId);
pgCtx.Parms.Clear();
RadioButtonList FuzzyEnquiry = queryTable.FindControl("__Fuzzytxt_" + i.ToString()) as RadioButtonList;
if (queryItem.Attributes["isVirtual"] != "true")
{
if (FuzzyEnquiry != null)
{
if (FuzzyEnquiry.SelectedIndex == 0)
{
queryFilter.AddFilterItem(queryItem.Attributes["fieldName"], textbox.Value.Replace("'", "''"), Operation.Like, FilterType.StringType, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
else
{
queryFilter.AddFilterItem(queryItem.Attributes["fieldName"], textbox.Value.Replace("'", "''"), Operation.Equal, FilterType.StringType, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
}
else
{
queryFilter.AddFilterItem(queryItem.Attributes["fieldName"], textbox.Value.Replace("'", "''"), Operation.Like, FilterType.StringType, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
}
else
{
if (FuzzyEnquiry != null)
{
if (FuzzyEnquiry.SelectedIndex == 0)
{
queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " LIKE '%" + textbox.Value.Replace("'", "''") + "%'", queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
else
{
queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " = '" + textbox.Value.Replace("'", "''") + "'", queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
}
else
{
queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " LIKE '%" + textbox.Value.Replace("'", "''") + "%'", queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
}
// if(queryItem.Attributes["isVirtual"] != "true")
// queryFilter.AddFilterItem(queryItem.Attributes["fieldName"],
// textbox.Value.Replace("'", "''"), Operation.Like, FilterType.StringType, filterJunction); // 2007-4-5, Tony, 将单引号替换成两个单引号，避免查询时报错
// else
// {
// /* Andy Modify 2008-07-30 只有Client的Mobile、TelePhone、ChineseName、EnglishName用前匹配模糊查询 */
// if(this.BusinessObjectView.BusinessObjectName.ToLower() == "client")
// {
// if( queryItem.Attributes["fieldName"].ToLower().Trim().IndexOf("mobile") == -1 &&
// queryItem.Attributes["fieldName"].ToLower().Trim().IndexOf("telephone") == -1 &&
// queryItem.Attributes["fieldName"].ToLower().Trim().IndexOf("chinesename") == -1 &&
// queryItem.Attributes["fieldName"].ToLower().Trim().IndexOf("englishname") == -1)
// {
// queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " LIKE '%" + textbox.Value.Replace("'", "''") + "%'", filterJunction);// 2007-4-5, Tony, 将单引号替换成两个单引号，避免查询时报错
// }
// else
// queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " LIKE '" + textbox.Value.Replace("'", "''") + "%'", filterJunction);
// }
// else
// queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " LIKE '%" + textbox.Value.Replace("'", "''") + "%'", filterJunction);// 2007-4-5, Tony, 将单引号替换成两个单引号，避免查询时报错
// }
// Desc
queryDesc.AppendFormat("{0}：{1}.", desc.Text, textbox.Value);
}
}
else if (itemType == ViewItemDisplayType.DateTime)
{
// Filter
HtmlInputText beginTime = queryTable.FindControl("__beginTime_" + i.ToString()) as HtmlInputText;
HtmlInputText endTime = queryTable.FindControl("__endTime_" + i.ToString()) as HtmlInputText;
BusinessFilter subFilter = new BusinessFilter(this.BusinessObjectView.BusinessObjectName);
if (queryItem.Attributes["isVirtual"] != "true")
{
if (beginTime.Value != string.Empty)
{
subFilter.AddFilterItem(queryItem.Attributes["fieldName"],
beginTime.Value, Operation.NotSmaller, FilterType.StringType, AndOr.AND);
}
if (endTime.Value != string.Empty)
{
subFilter.AddFilterItem(queryItem.Attributes["fieldName"],
endTime.Value, Operation.Smaller, FilterType.StringType, AndOr.AND);
}
//endTime.Value, Operation.NotLarger, FilterType.StringType, AndOr.AND);
}
else
{
if (beginTime.Value != string.Empty)
{
subFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + ">= '" + beginTime.Value + "'", AndOr.AND);
}
if (endTime.Value != string.Empty)
{
subFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + "< '" + endTime.Value + "'", AndOr.AND);
}
//subFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + "<= '" + endTime.Value + "'", AndOr.AND);
}
queryFilter.AddFilter(subFilter, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
if (beginTime.Value != string.Empty || endTime.Value != string.Empty)
{
// Desc
queryDesc.AppendFormat("{0}：从{1}至{2}.", desc.Text, beginTime.Value, endTime.Value);
}
}
else if (itemType == ViewItemDisplayType.SingleObject)
{
// Filter
GridPicker ucGridPicker = queryTable.FindControl("__ucGridPicker_" + i.ToString()) as GridPicker;
if (ucGridPicker.SelectedValue != string.Empty)
{
if (queryItem.Attributes["isVirtual"] != "true")
{
queryFilter.AddFilterItem(queryItem.Attributes["fieldName"], ucGridPicker.SelectedValue, Operation.Equal, FilterType.NumberType, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
else
{
queryFilter.AddCustomerFilter(queryItem.Attributes["fieldName"] + " = " + ucGridPicker.SelectedValue, queryFilter.Filter != string.Empty ? filterJunction : AndOr.AND);
}
// Desc
queryDesc.AppendFormat("{0}：{1}.", desc.Text, ucGridPicker.SelectedText);
}
}
}
}
if (queryDesc.Length != 0)
{
filterDescription = queryDesc.AppendFormat("（{0}）", (filterJunction == AndOr.AND) ? "满足全部条件" : "满足任一条件").ToString();
}
else
{
filterDescription = string.Empty;
}
BusinessFilter parentQueryFilter = new BusinessFilter(this.BusinessObjectView.BusinessObjectName);
parentQueryFilter.AddCustomerFilter("1=1", AndOr.AND);
parentQueryFilter.AddFilter(queryFilter, AndOr.AND);
this.SaveQueryStatus();
return(parentQueryFilter);
}
internal void SetFieldType(ViewItemDisplayType displayType)
{
this.displayType = displayType;
}
