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); }