Hidistro.SqlDal/Promotions/GameActDao.cs

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

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

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

    public class GameActDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public int Create(GameActInfo game, ref string msg)
        {
            msg = "未知错误";
            try
            {
                DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO [Hishop_Game]([GameType],[GameName],[BeginDate],[EndDate],[Decription],[MemberGrades], [usePoint],[GivePoint],[bOnlyNotWinner],[attendTimes],[ImgUrl],[status],[unWinDecrip],[CreateStep]) VALUES (@GameType,@GameName,@BeginDate,@EndDate,@Decription,@MemberGrades,@usePoint,@GivePoint,@bOnlyNotWinner, @attendTimes,@ImgUrl,@status,@unWinDecrip,@CreateStep) SELECT CAST(scope_identity() AS int)");
                this.database.AddInParameter(sqlStringCommand, "GameType", DbType.Int32, (int) game.GameType);
                this.database.AddInParameter(sqlStringCommand, "GameName", DbType.String, game.GameName);
                this.database.AddInParameter(sqlStringCommand, "BeginDate", DbType.DateTime, game.BeginDate);
                this.database.AddInParameter(sqlStringCommand, "EndDate", DbType.DateTime, game.EndDate);
                this.database.AddInParameter(sqlStringCommand, "Decription", DbType.String, game.Decription);
                this.database.AddInParameter(sqlStringCommand, "MemberGrades", DbType.String, game.MemberGrades);
                this.database.AddInParameter(sqlStringCommand, "usePoint", DbType.Int32, game.usePoint);
                this.database.AddInParameter(sqlStringCommand, "GivePoint", DbType.Int32, game.GivePoint);
                this.database.AddInParameter(sqlStringCommand, "bOnlyNotWinner", DbType.Boolean, game.bOnlyNotWinner);
                this.database.AddInParameter(sqlStringCommand, "attendTimes", DbType.Int32, game.attendTimes);
                this.database.AddInParameter(sqlStringCommand, "ImgUrl", DbType.String, game.ImgUrl);
                this.database.AddInParameter(sqlStringCommand, "status", DbType.Int32, game.status);
                this.database.AddInParameter(sqlStringCommand, "unWinDecrip", DbType.String, game.unWinDecrip);
                this.database.AddInParameter(sqlStringCommand, "CreateStep", DbType.Int32, game.CreateStep);
                int num = (int) this.database.ExecuteScalar(sqlStringCommand);
                msg = "";
                return num;
            }
            catch (Exception exception)
            {
                msg = exception.Message;
                return 0;
            }
        }

        public bool Delete(int Id)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM  Hishop_Game WHERE GameId = @ID");
            this.database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, Id);
            sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_Game_Prize WHERE GameId = @ID");
            this.database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, Id);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public bool DeletePrize(int gameid)
        {
            try
            {
                DbCommand sqlStringCommand = this.database.GetSqlStringCommand("delete from Hishop_Game_Prize where [GameId]= @GameId ");