public override SoaDataGridSelectResponse Select(SoaDataGridSelectRequest request)
{
SoaDataGridSelectResponse response = new SoaDataGridSelectResponse();
if (request.Tag == null || string.IsNullOrEmpty(request.Tag.ToString()))
{
return(response);
}
try
{
//WindowInfo windowInfo = ADInfoBll.Instance.GetWindowInfo(request.Tag.ToString());
//IList<WindowTabInfo> tabInfos = null;
//if (windowInfo != null)
//{
// tabInfos = ADInfoBll.Instance.GetWindowTabInfo(windowInfo.Id);
//}
Dictionary <string, string> dict = StringToDictionary(request.Tag.ToString());
if (!dict.ContainsKey("winTab") || string.IsNullOrEmpty(dict["winTab"]))
{
return(response);
}
WindowTabInfo tabInfo = ADInfoBll.Instance.GetWindowTabInfo(dict["winTab"]);
if (tabInfo != null)
{
ISearchManager sm = ServiceProvider.GetService <IManagerFactory>().GenerateSearchManager(tabInfo, null);
ManagerFactory.CreateSearchManagerEagerFetchs(sm, tabInfo.GridName);
ISearchExpression exp = null;
if (dict.ContainsKey("se") && !string.IsNullOrEmpty(dict["se"]))
{
//exp = HttpUtility.UrlDecode(exp, System.Text.Encoding.GetEncoding("gb2312"));
//exp = HttpContext.Current.Server.UrlDecode(exp);
exp = SearchExpression.Parse(dict["se"]);
}
//if (request.Filters != null)
//{
// //searchs.Add(SearchExpression.Parse(request.Tag.ToString()));
// foreach (SoaDataGridDataCondition i in request.Filters)
// {
// switch (i.Operand)
// {
// case SoaDataGridDataConditionOperand.Contains:
// searchExps.Add(SearchExpression.Like(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.Equals:
// searchExps.Add(SearchExpression.Eq(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.GreaterThan:
// searchExps.Add(SearchExpression.Gt(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.GreaterThanOrEqual:
// searchExps.Add(SearchExpression.Ge(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.In:
// searchExps.Add(SearchExpression.InG(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.LessThan:
// searchExps.Add(SearchExpression.Lt(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.LessThanOrEqual:
// searchExps.Add(SearchExpression.Le(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.NotEqualTo:
// searchExps.Add(SearchExpression.NotEq(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.NotIn:
// searchExps.Add(SearchExpression.NotInG(i.DataFieldName, i.DataFieldValue));
// break;
// case SoaDataGridDataConditionOperand.StartsWith:
// searchExps.Add(SearchExpression.Like(i.DataFieldName, i.DataFieldValue));
// break;
// }
// }
//}
IList <ISearchOrder> searchOrders = new List <ISearchOrder>();
if (request.Sortings != null)
{
foreach (SoaDataGridSorting i in request.Sortings)
{
searchOrders.Add(i.Direction == SoaSortDirection.Ascending ? SearchOrder.Asc(i.Column.Name) : SearchOrder.Desc(i.Column.Name));
}
}
sm.FirstResult = request.Offset;
sm.MaxResult = request.Count;
List <List <object> > arMessages;
arMessages = GenerateData(sm.GetData(exp, searchOrders), tabInfo.GridName, request.Columns);
//IList<Dictionary<string, object>> values = null;
//
//using (DataProcess dp = new DataProcess())
//{
// if (dt == null)
// {
// // should be IEnumerable because IList<T> not support IList
// IEnumerable data = ret as IEnumerable;
// values = dp.Process(data, tabInfo.GridName);
// }
// else
// {
// values = dp.Process(dt.Rows, tabInfo.GridName);
// }
//}
//foreach (Dictionary<string, object> obj in values)
//{
// List<object> msg = new List<object>();
// foreach (SoaDataGridColumn oColumn in request.Columns)
// {
// if (!obj.ContainsKey(oColumn.Name))
// {
// msg.Add(null);
// }
// else
// {
// msg.Add(obj[oColumn.Name]);
// }
// }
// arMessages.Add(msg);
//}
response.Data = arMessages;
if (sm.EnablePage)
{
response.ItemCount = sm.GetCount(exp);
}
else
{
response.ItemCount = arMessages.Count;
}
}
else
{
throw new ArgumentException("Invalide tabName of " + dict["winTab"]);
}
}
catch (Exception)
{
#if DEBUG
throw;
#endif
}
return(response);
}
public GridWebServiceSelectResponse SelectMethod(GridWebServiceSelectRequest request)
{
GridWebServiceSelectResponse response = new GridWebServiceSelectResponse();
try
{
request.CustomParameter = "进口_备案";
WindowTabInfo tabInfo = ADInfoBll.Instance.GetWindowTabInfo(request.CustomParameter);
if (tabInfo != null)
{
ISearchManager sm = Feng.Windows.Forms.ArchiveFormFactory.GenerateSearchManager(tabInfo, null);
IList <ISearchExpression> searchExps = new List <ISearchExpression>();
IList <ISearchOrder> searchOrders = new List <ISearchOrder>();
if (!string.IsNullOrEmpty(request.Filter))
{
searchExps.Add(SearchExpression.Parse(request.Filter));
}
if (!string.IsNullOrEmpty(request.SortField))
{
searchOrders.Add(request.SortOrder == "ASC" ? SearchOrder.Asc(request.SortField) : SearchOrder.Desc(request.SortField));
}
sm.FirstResult = request.CurrentPageIndex * request.PageSize;
sm.MaxResult = request.PageSize;
List <TestData> arMessages = new List <TestData>();
object ret = sm.FindData(searchExps, searchOrders);
System.Data.DataTable dt = ret as System.Data.DataTable;
if (dt == null)
{
IEnumerable data = ret as IEnumerable;
foreach (object obj in data)
{
arMessages.Add(new TestData(EntityHelper.GetPropertyValue(obj, "产地").ToString()));
}
}
else
{
foreach (System.Data.DataRow row in dt.Rows)
{
List <object> msg = new List <object>();
foreach (string oColumn in request.Columns)
{
msg.Add(row[oColumn]);
}
//arMessages.Add(msg);
}
}
response.RecordCount = sm.FindDataCount(searchExps);
response.Items = arMessages;
}
else
{
throw new ArgumentException("Invalide tabName");
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
return(response);
}
/// <summary>
///
/// </summary>
/// <param name="searchConditions"></param>
/// <param name="searchOrders"></param>
public virtual void FillSearchConditions(IList <ISearchExpression> searchConditions, IList <ISearchOrder> searchOrders)
{
if (Order.HasValue)
{
if (Order.Value)
{
searchOrders.Add(SearchOrder.Asc(PropertyNameToSearch));
}
else
{
searchOrders.Add(SearchOrder.Desc(PropertyNameToSearch));
}
}
if (IsNull)
{
if (!IsNot)
{
if (SearchNullUseFull)
{
searchConditions.Add(SearchExpression.IsNull(PropertyNameToSearch));
}
else
{
string[] ss = this.Navigator.Split(new char[] { '.', ':' }, StringSplitOptions.RemoveEmptyEntries);
searchConditions.Add(SearchExpression.IsNull(ss[0]));
}
}
else
{
searchConditions.Add(SearchExpression.IsNotNull(PropertyNameToSearch));
}
}
else
{
if (SelectedDataValue1 == null && SelectedDataValue2 == null)
{
return;
}
if (SelectedDataValue1 != null && SelectedDataValue2 == null)
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.Ge(PropertyNameToSearch, this.SelectedDataValue1));
}
else
{
searchConditions.Add(SearchExpression.Lt(PropertyNameToSearch, this.SelectedDataValue1));
}
}
else if (SelectedDataValue1 == null && SelectedDataValue2 != null)
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.Le(PropertyNameToSearch, this.SelectedDataValue2));
}
else
{
searchConditions.Add(SearchExpression.Gt(PropertyNameToSearch, this.SelectedDataValue2));
}
}
else
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.And(SearchExpression.Ge(PropertyNameToSearch, this.SelectedDataValue1),
SearchExpression.Le(PropertyNameToSearch, this.SelectedDataValue2)));
}
else
{
searchConditions.Add(SearchExpression.Or(SearchExpression.Lt(PropertyNameToSearch, this.SelectedDataValue1),
SearchExpression.Gt(PropertyNameToSearch, this.SelectedDataValue2)));
}
}
}
if (!string.IsNullOrEmpty(this.AdditionalSearchExpression))
{
searchConditions.Add(SearchExpression.Parse(this.AdditionalSearchExpression));
}
}
/// <summary>
///
/// </summary>
/// <param name="searchConditions"></param>
/// <param name="searchOrders"></param>
public virtual void FillSearchConditions(IList <ISearchExpression> searchConditions, IList <ISearchOrder> searchOrders)
{
if (Order.HasValue)
{
if (Order.Value)
{
searchOrders.Add(SearchOrder.Asc(PropertyNameToSearch));
}
else
{
searchOrders.Add(SearchOrder.Desc(PropertyNameToSearch));
}
}
if (IsNull)
{
if (!IsNot)
{
//// 对帐单.对账单号 为空，其实意义就是对帐单为空
//if (string.IsNullOrEmpty(this.Navigator))
//{
// searchConditions.Add(SearchExpression.IsNull(PropertyNameToSearch));
//}
//else
//{
// // 为空的话，只去最前面一个
// string[] ss = this.Navigator.Split(new char[] { '.', ':' }, StringSplitOptions.RemoveEmptyEntries);
// searchConditions.Add(SearchExpression.IsNull(ss[0]));
//}
if (SearchNullUseFull || string.IsNullOrEmpty(this.Navigator))
{
searchConditions.Add(SearchExpression.IsNull(PropertyNameToSearch));
}
else
{
if (string.IsNullOrEmpty(this.Navigator))
{
throw new ArgumentException("When SearchNullUseFull is false, it will use Navigator's first part, so navigator must not null!");
}
string[] ss = this.Navigator.Split(new char[] { '.', ':' }, StringSplitOptions.RemoveEmptyEntries);
searchConditions.Add(SearchExpression.IsNull(ss[0]));
}
}
else
{
searchConditions.Add(SearchExpression.IsNotNull(PropertyNameToSearch));
}
}
else
{
IMultiDataValueControl mdc = this.Control as IMultiDataValueControl;
if (mdc != null)
{
if (this.SelectedDataValues.Count == 0)
{
return;
}
if (!this.UseFuzzySearch.HasValue)
{
if (this.CanSelectFuzzySearch && mdc.SelectedDataValues.Count == 1)
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.Like(PropertyNameToSearch, mdc.SelectedDataValues[0]));
}
else
{
searchConditions.Add(SearchExpression.NotLike(PropertyNameToSearch, mdc.SelectedDataValues[0]));
}
}
else
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.InG(PropertyNameToSearch, mdc.SelectedDataValues));
}
else
{
searchConditions.Add(SearchExpression.NotInG(PropertyNameToSearch, mdc.SelectedDataValues));
}
}
}
else if (this.UseFuzzySearch.Value)
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.GInG(PropertyNameToSearch, mdc.SelectedDataValues));
}
else
{
searchConditions.Add(SearchExpression.NotGInG(PropertyNameToSearch, mdc.SelectedDataValues));
}
}
else
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.InG(PropertyNameToSearch, mdc.SelectedDataValues));
}
else
{
searchConditions.Add(SearchExpression.NotInG(PropertyNameToSearch, mdc.SelectedDataValues));
}
}
}
else
{
if (this.SelectedDataValue == null)
{
return;
}
if (this.CanSelectFuzzySearch && (!this.UseFuzzySearch.HasValue || this.UseFuzzySearch.Value))
{
string s = this.SelectedDataValue.ToString();
if (!IsNot)
{
searchConditions.Add(SearchExpression.Like(PropertyNameToSearch, s));
}
else
{
searchConditions.Add(SearchExpression.NotLike(PropertyNameToSearch, s));
}
}
else
{
if (!IsNot)
{
searchConditions.Add(SearchExpression.Eq(PropertyNameToSearch, this.SelectedDataValue));
}
else
{
searchConditions.Add(SearchExpression.NotEq(PropertyNameToSearch, this.SelectedDataValue));
}
}
}
}
if (!string.IsNullOrEmpty(this.AdditionalSearchExpression))
{
searchConditions.Add(SearchExpression.Parse(this.AdditionalSearchExpression));
}
}