public PagingDataSet <GoodsSkuInout> GetGoodsSkuInout(GoodsSkuInoutQuery goodsSkuInoutQuery, int pageIndex, int pageSize)
{
int totalCount = 0;
int totalPage = 0;
string whereSql = string.Empty;
string orderBy = string.Empty;
HandleOrderByEunm(goodsSkuInoutQuery.GoodsSkuInoutSortBy, out orderBy);
object pars = new object();
whereSql = HandleQueryBySqlable(goodsSkuInoutQuery, out pars);
return(GetPageListByCache(pageIndex, pageSize, out totalCount, out totalPage, whereSql, pars, orderBy, i => i.Id));
}
private string HandleQueryBySqlable(GoodsSkuInoutQuery goodsSkuInoutQuery, out object pars)
{
Dictionary <string, object> paramsDictionary = new Dictionary <string, object>();
var sqlTable = new Sqlable();
sqlTable.Sql = new StringBuilder();
if (!string.IsNullOrWhiteSpace(goodsSkuInoutQuery.GoodsName))
{
sqlTable = sqlTable.Where("goodsid in (select goodsid from sc_goods_info where goods_name LIKE @GoodsName)");
paramsDictionary.Add("GoodsName", $"%{goodsSkuInoutQuery.GoodsName}%");
}
if (!string.IsNullOrWhiteSpace(goodsSkuInoutQuery.SkuName))
{
sqlTable = sqlTable.Where("skuid in (select skuid from sc_goods_sku_info where sku_name LIKE @SkuName)");
paramsDictionary.Add("SkuName", $"%{goodsSkuInoutQuery.SkuName}%");
}
if (goodsSkuInoutQuery.InoutNumberMin.HasValue)
{
sqlTable = sqlTable.Where("inout_number >= @InoutNumberMin");
paramsDictionary.Add("InoutNumberMin", goodsSkuInoutQuery.InoutNumberMin);
}
if (goodsSkuInoutQuery.InoutNumberMax.HasValue)
{
sqlTable = sqlTable.Where("inout_number <= @InoutNumberMax");
paramsDictionary.Add("InoutNumberMax", goodsSkuInoutQuery.InoutNumberMax);
}
if (goodsSkuInoutQuery.IsOut.HasValue)
{
sqlTable = sqlTable.Where("is_out = @IsOut");
paramsDictionary.Add("IsOut", goodsSkuInoutQuery.IsOut);
}
pars = paramsDictionary;
foreach (var item in sqlTable.Where)
{
sqlTable.Sql.Append(item);
}
return(sqlTable.Sql.ToString().TrimStart(" AND".ToCharArray()));
}
public PagingDataSet <GoodsSkuInout> GetGoodsSkuInout(GoodsSkuInoutQuery goodsSkuInoutQuery, int pageIndex, int pageSize)
{
return(goodsSkuInoutRepository.GetGoodsSkuInout(goodsSkuInoutQuery, pageIndex, pageSize));
}