public QueryResult QueryWarehouseOwner(WarehouseOwnerQueryFilter request)
{
int totalCount;
var dataTable = ObjectFactory <IWarehouseOwnerQueryDA> .Instance.QueryWarehouseOwner(request, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public void QueryWarehouseOwner(WarehouseOwnerQueryVM model, EventHandler <RestClientEventArgs <dynamic> > callback)
{
WarehouseOwnerQueryFilter filter = model.ConvertVM <WarehouseOwnerQueryVM, WarehouseOwnerQueryFilter>();
string relativeUrl = "/InventoryService/Stock/QueryWarehouseOwner";
restClient.QueryDynamicData(relativeUrl, filter,
(obj, args) =>
{
if (!args.FaultsHandle())
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
}
callback(obj, args);
}
});
}
/// <summary>
/// 查询仓库所有者
/// </summary>
/// <returns></returns>
public virtual DataTable QueryWarehouseOwner(WarehouseOwnerQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = SortFieldMapping(filter.PagingInfo.SortBy);
pagingEntity.MaximumRows = filter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryWarehouseOwner");
using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "a.SysNo DESC"))
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.OwnerName", DbType.String, "@OwnerName",
QueryConditionOperatorType.Like, filter.OwnerName);
if (filter.OwnerStatus.HasValue)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.[Status]", DbType.Int32, "@OwnerStatus",
QueryConditionOperatorType.Equal, filter.OwnerStatus);
}
if (filter.OwnerType.HasValue)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.[OwnerType]", DbType.Int32, "@OwnerType",
QueryConditionOperatorType.Equal, filter.OwnerType);
}
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode",
QueryConditionOperatorType.Equal, filter.CompanyCode);
cmd.CommandText = sb.BuildQuerySql();
EnumColumnList enumColumnList = new EnumColumnList();
enumColumnList.Add("OwnerStatus", typeof(ValidStatus));
enumColumnList.Add("OwnerType", typeof(WarehouseOwnerType));
var resultData = cmd.ExecuteDataTable(enumColumnList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(resultData);
}
}
