public ActionResult QueryProductStockAdjustList()
{
ProductStockAdjustListQueryFilter queryFilter = BuildQueryFilterEntity <ProductStockAdjustListQueryFilter>((s) =>
{
s.VendorSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
});
var result = ProductPurchaseService.QueryProductStockAdjustmentList(queryFilter);
return(AjaxGridJson(result));
}
/// <summary>
/// 查询商品库存调整单列表
/// </summary>
/// <param name="queryCriteria"></param>
/// <returns></returns>
public static QueryResult <ProductStockAdjustViewInfo> QueryProductStockAdjustmentList(ProductStockAdjustListQueryFilter queryCriteria)
{
return(ProductDA.QueryProductStockAdjustmentList(queryCriteria));
}
/// <summary>
/// 查询商品库存调整单列表
/// </summary>
/// <param name="queryCriteria"></param>
/// <returns></returns>
public static QueryResult <ProductStockAdjustViewInfo> QueryProductStockAdjustmentList(ProductStockAdjustListQueryFilter queryFilter)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductStockAdjustmentList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "ps.SysNo DESC" : queryFilter.SortFields))
{
//Set SQL WHERE Condition:
#region Build Condition:
if (queryFilter.VendorSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.VendorSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo.Value);
}
var sysno = 0;
if (!string.IsNullOrEmpty(queryFilter.SysNo) && int.TryParse(queryFilter.SysNo, out sysno))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, sysno);
}
if (queryFilter.Status.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.Status", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, (int)queryFilter.Status.Value);
}
if (queryFilter.StockSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.StockSysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.StockSysNo.Value);
}
int productSysNo = 0;
if (!string.IsNullOrEmpty(queryFilter.ProductSysNo) && int.TryParse(queryFilter.ProductSysNo, out productSysNo))
{
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, string.Format(" Exists(SELECT TOP 1 1 FROM ECStore.dbo.Product_StockAdjustDetail (NOLOCK) WHERE ProductSysNo = {0} AND AdjustSysNo = ps.SysNo)", productSysNo));
}
if (!string.IsNullOrEmpty(queryFilter.CreateDateFrom))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.InDate", DbType.DateTime, "@DateTimeFrom", QueryConditionOperatorType.MoreThanOrEqual, Convert.ToDateTime(queryFilter.CreateDateFrom));
}
if (!string.IsNullOrEmpty(queryFilter.CreateDateTo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.InDate", DbType.DateTime, "@DateTimeTo", QueryConditionOperatorType.LessThan, Convert.ToDateTime(queryFilter.CreateDateTo).AddDays(1));
}
if (!string.IsNullOrEmpty(queryFilter.AuditDateFrom))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.AuditDate", DbType.DateTime, "@AuditTimeFrom", QueryConditionOperatorType.MoreThanOrEqual, Convert.ToDateTime(queryFilter.AuditDateFrom));
}
if (!string.IsNullOrEmpty(queryFilter.AuditDateTo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ps.AuditDate", DbType.DateTime, "@AuditTimeTo", QueryConditionOperatorType.LessThan, Convert.ToDateTime(queryFilter.AuditDateTo).AddDays(1));
}
#endregion
command.CommandText = sqlBuilder.BuildQuerySql();
List <ProductStockAdjustViewInfo> resultList = command.ExecuteEntityList <ProductStockAdjustViewInfo>();
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(new QueryResult <ProductStockAdjustViewInfo>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields
}, ResultList = resultList
});
}
}
