/// <summary>
/// 加入查询
/// </summary>
/// <param name="fieldItem">blockfielditem</param>
/// <param name="queryFields">Navigator的查询集合</param>
/// <param name="queryColumns">ClientQuery的查询集合</param>
/// <param name="tableName">tablename</param>
private void GenQuery(TBlockFieldItem fieldItem, WebQueryFiledsCollection queryFields, WebQueryColumnsCollection queryColumns
, string tableName)
{
if (string.Compare(fieldItem.QueryMode, "normal", true) == 0
|| string.Compare(fieldItem.QueryMode, "range", true) == 0)
{
if (queryFields != null)
{
WebQueryField field = new WebQueryField();
field.FieldName = fieldItem.DataField;
field.Caption = string.IsNullOrEmpty(fieldItem.Description) ? fieldItem.DataField : fieldItem.Description;
if (string.Compare(fieldItem.QueryMode, "normal", true) == 0)
{
field.Condition = (fieldItem.DataType == typeof(string)) ? "%" : "=";
}
else
{
WebQueryField fieldrev = new WebQueryField();
fieldrev.FieldName = field.FieldName;
fieldrev.Caption = field.Caption;
fieldrev.RefVal = field.RefVal;
fieldrev.Condition = ">=";
fieldrev.Mode = InitQueryField(fieldItem, fieldrev);
queryFields.Add(fieldrev);
field.Condition = "<=";
}
field.Mode = InitQueryField(fieldItem, field);
queryFields.Add(field);
}
if (queryColumns != null)
{
WebQueryColumns column = new WebQueryColumns();
column.Column = fieldItem.DataField;
column.Caption = string.IsNullOrEmpty(fieldItem.Description) ? fieldItem.DataField : fieldItem.Description;
if (string.Compare(fieldItem.ControlType, "textbox", true) == 0)
{
column.ColumnType = "ClientQueryTextBoxColumn";
}
else if (string.Compare(fieldItem.ControlType, "combobox", true) == 0)
{
column.ColumnType = "ClientQueryComboBoxColumn";
column.WebRefVal = string.Format("wrv{0}{1}QF", tableName, fieldItem.DataField);
}
else if (string.Compare(fieldItem.ControlType, "refvalbox", true) == 0)
{
if (fieldItem.RefValNo == String.Empty)
column.ColumnType = "ClientQueryTextBoxColumn";
else
{
column.ColumnType = "ClientQueryRefValColumn";
column.WebRefVal = string.Format("wrv{0}{1}QF", tableName, fieldItem.DataField);
}
}
else if (string.Compare(fieldItem.ControlType, "datetimebox", true) == 0)
{
column.ColumnType = "ClientQueryCalendarColumn";
}
if (string.Compare(fieldItem.QueryMode, "normal", true) == 0)
{
column.Operator = (fieldItem.DataType == typeof(string)) ? "%" : "=";
}
else
{
WebQueryColumns columnrev = new WebQueryColumns();
columnrev.Column = column.Column;
columnrev.Caption = column.Caption;
columnrev.ColumnType = column.ColumnType;
columnrev.WebRefVal = column.WebRefVal;
columnrev.Operator = ">=";
queryColumns.Add(columnrev);
column.Operator = "<=";
}
queryColumns.Add(column);
}
}
}
