Hidistro.SqlDal/Promotions/ActivityDao.cs

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

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

namespace Hidistro.SqlDal.Promotions
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    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;
    using System.Runtime.InteropServices;
    using System.Text;

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

        public bool AddActivitiesMember(int ActivitiesId, int Userid, DbTransaction dbTran = null)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_ActivitiesMember  (ActivitiesId,Userid)VALUES(@ActivitiesId,@Userid)");
            this.database.AddInParameter(sqlStringCommand, "ActivitiesId", DbType.Int32, ActivitiesId);
            this.database.AddInParameter(sqlStringCommand, "Userid", DbType.Int32, Userid);
            if (dbTran != null)
            {
                return (this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
            }
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public bool AddProducts(int actId, int productID)
        {
            try
            {
                ActivityInfo act = this.GetAct(actId);
                if (act != null)
                {
                    StringBuilder builder = new StringBuilder();
                    builder.AppendFormat(" insert into Hishop_Activities_Product(ActivitiesId , ProductId) values({0} , {1}) ", act.ActivitiesId, productID);
                    DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
                    this.database.ExecuteNonQuery(sqlStringCommand);
                    sqlStringCommand = this.database.GetSqlStringCommand("update Hishop_Activities set IsAllProduct=0  WHERE ActivitiesId = @ActivitiesId");
                    this.database.AddInParameter(sqlStringCommand, "ActivitiesId", DbType.Int32, actId);
                    this.database.ExecuteNonQuery(sqlStringCommand);
                    return true;
                }
                return false;
            }
            catch (Exception)
            {
                return false;
            }
        }

        public bool AddProducts(int actId, bool IsAllProduct, IList<string> productIDs)
        {
            try
            {
                ActivityInfo act = this.GetAct(actId);
                if (act != null)