Hidistro.SqlDal/VShop/ActivitiesDao.cs

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

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

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

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

        public int AddActivities(ActivitiesInfo activity)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("INSERT INTO Hishop_Activities(").Append("ActivitiesName,ActivitiesType,MeetMoney,ReductionMoney,StartTime,EndTIme,ActivitiesDescription,Type)").Append(" VALUES (").Append("@ActivitiesName,@ActivitiesType,@MeetMoney,@ReductionMoney,@StartTime,@EndTime,@ActivitiesDescription,@Type)");
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            this.database.AddInParameter(sqlStringCommand, "ActivitiesName", DbType.String, activity.ActivitiesName);
            this.database.AddInParameter(sqlStringCommand, "ActivitiesType", DbType.Int32, activity.ActivitiesType);
            this.database.AddInParameter(sqlStringCommand, "MeetMoney", DbType.Decimal, activity.MeetMoney);
            this.database.AddInParameter(sqlStringCommand, "ReductionMoney", DbType.Decimal, activity.ReductionMoney);
            this.database.AddInParameter(sqlStringCommand, "StartTime", DbType.DateTime, activity.StartTime);
            this.database.AddInParameter(sqlStringCommand, "EndTIme", DbType.DateTime, activity.EndTIme);
            this.database.AddInParameter(sqlStringCommand, "ActivitiesDescription", DbType.String, activity.ActivitiesDescription);
            this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, activity.Type);
            return this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public bool DeleteActivities(int ActivitiesId)
        {
            string query = "DELETE FROM Hishop_Activities WHERE ActivitiesId=@ActivitiesId";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            this.database.AddInParameter(sqlStringCommand, "ActivitiesId", DbType.Int32, ActivitiesId);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public IList<ActivitiesInfo> GetActivitiesInfo(string ActivitiesId)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("SELECT * FROM Hishop_Activities WHERE ActivitiesId={0}", ActivitiesId));
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                return ReaderConvert.ReaderToList<ActivitiesInfo>(reader);
            }
        }

        public DbQueryResult GetActivitiesList(ActivitiesQuery query)
        {
            StringBuilder builder = new StringBuilder();
            if (!string.IsNullOrEmpty(query.ActivitiesName))
            {
                if (builder.Length > 0)
                {
                    builder.Append(" AND ");
                }
                builder.AppendFormat(" ActivitiesName LIKE '%{0}%'", DataHelper.CleanSearchString(query.ActivitiesName));