public virtual QueryResult QueryShipTypeAreaUnList(ShipTypeAreaUnQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IShipTypeAreaUnQueryDA> .Instance.QueryShipTypeAreaUnList(filter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 查询配送方式-产品
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryShipTypeAreaUnList(ShipTypeAreaUnQueryFilter filter, out int TotalCount)
{
MapSortField(filter);
TotalCount = 0;
PagingInfoEntity pagingInfo = ToPagingInfo(filter.PageInfo);
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeAreaUn_QueryShipTypeAreaUn");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "STA.SysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "STA.ShipTypeSysNo", DbType.Int32, "@ShipTypeSysNo", QueryConditionOperatorType.Equal, filter.ShipTypeSysNo);
if (!string.IsNullOrEmpty(filter.AreaName))
{
using (GroupCondition g = new GroupCondition(sqlBuilder, QueryConditionRelationType.AND))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ProvinceName", DbType.String, "@ProvinceName", QueryConditionOperatorType.Equal, filter.AreaName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "A.CityName", DbType.String, "@CityName", QueryConditionOperatorType.Equal, filter.AreaName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "A.DistrictName", DbType.String, "@DistrictName", QueryConditionOperatorType.Equal, filter.AreaName);
}
}
if (filter.AreaSysNo.HasValue)
{
using (GroupCondition g = new GroupCondition(sqlBuilder, QueryConditionRelationType.AND))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNO", DbType.String, "@SysNO", QueryConditionOperatorType.Equal, filter.AreaSysNo);
}
}
else if (filter.CitySysNo.HasValue)
{
using (GroupCondition g = new GroupCondition(sqlBuilder, QueryConditionRelationType.AND))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, filter.CitySysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "A.CitySysNo", DbType.String, "@CitySysNo", QueryConditionOperatorType.Equal, filter.CitySysNo);
}
}
else if (filter.ProvinceSysNo.HasValue)
{
using (GroupCondition g = new GroupCondition(sqlBuilder, QueryConditionRelationType.AND))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, filter.ProvinceSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "A.ProvinceSysNo", DbType.String, "@ProvinceSysNo", QueryConditionOperatorType.Equal, filter.ProvinceSysNo);
}
}
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = cmd.ExecuteDataTable();
TotalCount = int.Parse(cmd.GetParameterValue("@TotalCount").ToString());
return(dt);
}
}
private static void MapSortField(ShipTypeAreaUnQueryFilter filter)
{
if (filter.PageInfo != null && !string.IsNullOrEmpty(filter.PageInfo.SortBy))
{
var index = 0;
index = filter.PageInfo.SortBy.Contains("asc") ? 4 : 5;
var sort = filter.PageInfo.SortBy.Substring(0, filter.PageInfo.SortBy.Length - index);
var sortFiled = filter.PageInfo.SortBy;
switch (sort)
{
case "SysNo":
filter.PageInfo.SortBy = sortFiled.Replace("SysNo", "STA.SysNo");
break;
case "AreaName":
filter.PageInfo.SortBy = sortFiled.Replace("AreaName", "A.ProvinceName");
break;
case "ShipTypeName":
filter.PageInfo.SortBy = sortFiled.Replace("ShipTypeName", "STA.ShipTypeSysNo");
break;
}
}
}
