couponitem.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.Shop
{
    using PowerEasy.IDal.Shop;
    using PowerEasy.Model.Shop;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Data;

    public class CouponItem : ICouponItem
    {
        public bool Add(CouponItemInfo couponItemInfo)
        {
            Parameters cmdParams = GetParameters(couponItemInfo);
            return DBHelper.ExecuteSql("insert into PE_CouponItem (CouponID,CouponNum,UserID,OrderID)values(@CouponID,@CouponNum,@UserID,@OrderID)", cmdParams);
        }

        public bool AddUseTimes(string couponNum, int userId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@CouponNum", DbType.String, couponNum);
            cmdParams.AddInParameter("@UserID", DbType.Int32, userId);
            return DBHelper.ExecuteSql("update PE_CouponItem set Usetimes = Usetimes + 1 where CouponNum = @CouponNum and UserID = @UserID", cmdParams);
        }

        public bool Delete(string couponId)
        {
            return DBHelper.ExecuteSql("delete from PE_CouponItem where CouponID in (" + couponId + ")");
        }

        public CouponItemInfo GetCouponItemInfo(string couponNum, int userId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@CouponNum", DbType.String, couponNum);
            cmdParams.AddInParameter("@UserID", DbType.Int32, userId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select * from PE_CouponItem where CouponNum=@CouponNum and UserID = @UserID", cmdParams))
            {
                if (reader.Read())
                {
                    return GetItemInfoFromrdataReader(reader);
                }
                return new CouponItemInfo(true);
            }
        }

        public static CouponItemInfo GetItemInfoFromrdataReader(NullableDataReader dataReader)
        {
            CouponItemInfo info = new CouponItemInfo();
            info.Id = dataReader.GetInt32("ID");
            info.CouponId = dataReader.GetInt32("CouponID");
            info.CouponNum = dataReader.GetString("CouponNum");
            info.OrderId = dataReader.GetInt32("OrderID");
            info.UserId = dataReader.GetInt32("UserID");
            info.UseTimes = dataReader.GetInt32("UseTimes");
            return info;
        }

        private static Parameters GetParameters(CouponItemInfo couponItemInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@CouponID", DbType.Int32, couponItemInfo.CouponId);
            parameters.AddInParameter("@CouponNum", DbType.String, couponItemInfo.CouponNum);
            parameters.AddInParameter("@UserID", DbType.Int32, couponItemInfo.UserId);
            parameters.AddInParameter("@OrderID", DbType.Int32, couponItemInfo.OrderId);
            return parameters;
        }
    }
}