/// <summary> /// 查询奖品发放记录 /// </summary> /// <param name="filter">查询条件</param> /// <returns></returns> public static QueryResult <GiftsGrantRecord> QueryGiftsGrantRecord(GiftsGrantRecordQueryFilter filter) { QueryResult <GiftsGrantRecord> result = new QueryResult <GiftsGrantRecord>(); result.ServicePageIndex = filter.ServicePageIndex; result.PageSize = filter.PageSize; PagingInfoEntity page = DataAccessUtil.ToPagingInfo(filter); CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryGiftsGrantRecord"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, page, "M.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.GiftSysNo", DbType.Int32, "@GiftSysNo", QueryConditionOperatorType.Equal, filter.GiftSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.GrantCounts", DbType.Int64, "@GrantCounts", QueryConditionOperatorType.Like, filter.GrantCounts); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.GrantDate", DbType.DateTime, "@GrantDate", QueryConditionOperatorType.Like, filter.GrantDate); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.GrantPerson", DbType.String, "@GrantPerson", QueryConditionOperatorType.Like, filter.GrantPerson); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.GrantPlace", DbType.String, "@GrantPlace", QueryConditionOperatorType.Like, filter.GrantPlace); cmd.CommandText = sqlBuilder.BuildQuerySql(); result.ResultList = cmd.ExecuteEntityList <GiftsGrantRecord>(); result.TotalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(result); } }
public void TestMethodQueryGiftsGrantRecord() { GiftsGrantRecordQueryFilter filter = new GiftsGrantRecordQueryFilter() { PageIndex = 1, PageSize = 10 }; var data = GiftsMgtService.Instance.QueryGiftsGrantRecord(filter); }
/// <summary> /// 查询奖品发放记录 /// </summary> /// <param name="filter">查询条件</param> /// <returns></returns> public QueryResult <GiftsGrantRecord> QueryGiftsGrantRecord(GiftsGrantRecordQueryFilter filter) { var data = GiftsMgtDA.QueryGiftsGrantRecord(filter); data.ResultList.ForEach(m => { m.GrantDate = DateTime.Parse(m.GrantDate).ToShortDateString(); }); return(data); }