public DbQueryResult GetStoreStockLog(StoreStockLogQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1 ");
if (query.StoreId.HasValue)
{
stringBuilder.AppendFormat(" AND StoreId = {0} ", query.StoreId);
}
if (!string.IsNullOrEmpty(query.Operator))
{
stringBuilder.AppendFormat(" AND Operator = '{0}'", DataHelper.CleanSearchString(query.Operator));
}
if (query.ProductId.HasValue)
{
stringBuilder.AppendFormat(" AND ProductId = {0}", query.ProductId);
}
if (query.StartTime.HasValue)
{
stringBuilder.AppendFormat(" AND ChangeTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.StartTime.Value));
}
if (query.EndTime.HasValue)
{
stringBuilder.AppendFormat(" AND ChangeTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.EndTime.Value));
}
if (query.StoreId.HasValue)
{
stringBuilder.AppendFormat(" AND StoreId = {0}", query.StoreId.Value);
}
string selectFields = " * ";
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_StoreStockLog", "Id", stringBuilder.ToString(), selectFields));
}
private DataGridViewModel <StoreStockLogInfo> GetDataList(StoreStockLogQuery query)
{
DataGridViewModel <StoreStockLogInfo> dataGridViewModel = new DataGridViewModel <StoreStockLogInfo>();
if (query != null)
{
PageModel <StoreStockLogInfo> storeStockLog = StoresHelper.GetStoreStockLog(query);
dataGridViewModel.rows = storeStockLog.Models.ToList();
dataGridViewModel.total = storeStockLog.Total;
}
return(dataGridViewModel);
}
private void GetList(HttpContext context)
{
StoreStockLogQuery storeStockLogQuery = new StoreStockLogQuery();
storeStockLogQuery.StoreId = base.CurrentManager.StoreId;
storeStockLogQuery.ProductId = base.GetIntParam(context, "ProductId", true);
storeStockLogQuery.StartTime = base.GetDateTimeParam(context, "StartTime");
storeStockLogQuery.EndTime = base.GetDateTimeParam(context, "EndTime");
storeStockLogQuery.PageIndex = base.CurrentPageIndex;
storeStockLogQuery.PageSize = base.CurrentPageSize;
DataGridViewModel <StoreStockLogInfo> dataList = this.GetDataList(storeStockLogQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
