public virtual QueryResult GetProductShowByQuery(ProductShowQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductShowDA> .Instance.GetProductShowByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
public DataTable GetProductShowByQuery(ProductShowQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductShowList");
cmd.SetParameterValue("@FirstOnlineTimeFrom", query.FirstOnlineTimeFrom);
cmd.SetParameterValue("@FirstOnlineTimeTo", query.FirstOnlineTimeTo);
cmd.SetParameterValue("@EditDateFrom", query.EditDateFrom);
cmd.SetParameterValue("@EditDateTo", query.EditDateTo);
cmd.SetParameterValue("@Status", query.Status);
cmd.SetParameterValue("@C1SysNo", query.Category1SysNo);
cmd.SetParameterValue("@C2SysNo", query.Category2SysNo);
cmd.SetParameterValue("@C3SysNo", query.Category3SysNo);
cmd.SetParameterValue("@SortField", query.PageInfo.SortBy);
cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(3, typeof(ProductStatus));
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
