Hidistro.SqlDal/Promotions/PrizeResultDao.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace Hidistro.SqlDal.Promotions
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    using Hidistro.Core.Enums;
    using Hidistro.Entities.Promotions;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class PrizeResultDao
    {
        private Database _db = null;

        public PrizeResultDao()
        {
            this._db = DatabaseFactory.CreateDatabase();
        }

        public bool AddPrizeLog(PrizeResultInfo model)
        {
            DbCommand storedProcCommand = this._db.GetStoredProcCommand("cp_GamePrize");
            this._db.AddInParameter(storedProcCommand, "@GameId", DbType.Int32, model.GameId);
            this._db.AddInParameter(storedProcCommand, "@PrizeId", DbType.Int32, model.PrizeId);
            this._db.AddInParameter(storedProcCommand, "@UserId", DbType.Int32, model.UserId);
            this._db.AddOutParameter(storedProcCommand, "@Result", DbType.Int32, 4);
            this._db.ExecuteNonQuery(storedProcCommand);
            object obj2 = storedProcCommand.Parameters["@Result"].Value;
            return (!((obj2 == null) || string.IsNullOrEmpty(obj2.ToString())) && (int.Parse(obj2.ToString()) > 0));
        }

        public DbQueryResult GetPrizeLogLists(PrizesDeliveQuery query)
        {
            string selectFields = "LogId, PlayTime, UserId, UserName, PrizeGrade, PrizeType, GivePoint, GiveCouponId, GiveShopBookId ";
            StringBuilder builder = new StringBuilder(" 1=1 ");
            if (query.GameId.HasValue)
            {
                builder.AppendFormat(" and GameId={0}", query.GameId);
            }
            if (query.IsUsed.HasValue)
            {
                builder.AppendFormat(" and IsUsed={0}", query.IsUsed);
            }
            if (!string.IsNullOrEmpty(query.StartDate))
            {
                builder.AppendFormat(" and PlayTime>='{0}'", query.StartDate);
            }
            if (!string.IsNullOrEmpty(query.EndDate))
            {
                builder.AppendFormat(" and PlayTime<'{0}'", query.EndDate);
            }
            return DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_PrizesRecord", "LogId", builder.ToString(), selectFields);
        }

        public IList<PrizeResultViewInfo> GetPrizeLogLists(int gameId, int pageIndex, int pageSize)
        {
            List<PrizeResultViewInfo> list = new List<PrizeResultViewInfo>();