public DataTable GetRmaPolicyLog(RmaPolicyLogQueryFilter filter, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("GetRmaPolicyLog"); cmd.SetParameterValue("@RmaPolicySysNo", filter.RmaPolicySysNO); cmd.SetParameterValue("@RmaPolicy", filter.RmaPolicy); cmd.SetParameterValue("@UpdateDateTo", filter.UpdateDateTo); cmd.SetParameterValue("@UpdateDateFrom", filter.UpdateDateFrom); cmd.SetParameterValue("@EditUserName", filter.EidtUserName); cmd.SetParameterValue("@pageIndex", filter.PagingInfo.PageIndex); cmd.SetParameterValue("@pageSize", filter.PagingInfo.PageSize); cmd.SetParameterValue("@sortField", filter.PagingInfo.SortBy); EnumColumnList enumList = new EnumColumnList { { "Status", typeof(RmaPolicyStatus) }, { "Type", typeof(RmaPolicyType) }, { "IsOnlineRequst", typeof(IsOnlineRequst) }, { "OperationType", typeof(RmaLogActionType) }, }; DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(enumList); totalCount = (int)cmd.GetParameterValue("@totalCount"); return(dt); }
public QueryResult QueryRmaPolicyLog(RmaPolicyLogQueryFilter query) { int totalCount; var data = ObjectFactory <IRmaPolicyLogQueryDA> .Instance.GetRmaPolicyLog(query, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }