Hidistro.SqlDal/Promotions/ShareActDao.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.Data;
    using System.Data.Common;
    using System.Text;

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

        public bool AddRecord(ShareActivityRecordInfo record)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO [Hishop_ShareActivity_Record]([shareId],[shareUser],[attendUser]) VALUES (@shareId,@shareUser,@attendUser);");
            this.database.AddInParameter(sqlStringCommand, "shareId", DbType.Int32, record.shareId);
            this.database.AddInParameter(sqlStringCommand, "shareUser", DbType.Int32, record.shareUser);
            this.database.AddInParameter(sqlStringCommand, "attendUser", DbType.Int32, record.attendUser);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public int Create(ShareActivityInfo share, ref string msg)
        {
            msg = "未知错误";
            try
            {
                DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO [Hishop_ShareActivity]([CouponId],[BeginDate],[EndDate],[MeetValue],[CouponNumber],[CouponName],[ActivityName],[ImgUrl],[ShareTitle],[Description])VALUES (@CouponId,@BeginDate,@EndDate,@MeetValue,@CouponNumber,@CouponName,@ActivityName,@ImgUrl,@ShareTitle,@Description); SELECT CAST(scope_identity() AS int);");
                this.database.AddInParameter(sqlStringCommand, "CouponId", DbType.Int32, share.CouponId);
                this.database.AddInParameter(sqlStringCommand, "BeginDate", DbType.DateTime, share.BeginDate);
                this.database.AddInParameter(sqlStringCommand, "EndDate", DbType.DateTime, share.EndDate);
                this.database.AddInParameter(sqlStringCommand, "MeetValue", DbType.Decimal, share.MeetValue);
                this.database.AddInParameter(sqlStringCommand, "CouponNumber", DbType.Int32, share.CouponNumber);
                this.database.AddInParameter(sqlStringCommand, "CouponName", DbType.String, share.CouponName);
                this.database.AddInParameter(sqlStringCommand, "ActivityName", DbType.String, share.ActivityName);
                this.database.AddInParameter(sqlStringCommand, "ImgUrl", DbType.String, share.ImgUrl);
                this.database.AddInParameter(sqlStringCommand, "ShareTitle", DbType.String, share.ShareTitle);
                this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, share.Description);
                return (int) this.database.ExecuteScalar(sqlStringCommand);
            }
            catch (Exception exception)
            {
                msg = exception.Message;
                return 0;
            }
        }

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

        public ShareActivityInfo GetAct(int Id)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_ShareActivity WHERE id = @ID");