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

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

        public int AddNineImgses(NineImgsesItem info)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("INSERT INTO Vshop_ShareMaterial_NineImages(").Append("ShareDesc,CreatTime,image1,image2,image3,image4,image5,image6,image7,image8,image9)").Append(" VALUES (").Append("@ShareDesc,@CreatTime,@image1,@image2,@image3,@image4,@image5,@image6,@image7,@image8,@image9)");
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            this.database.AddInParameter(sqlStringCommand, "ShareDesc", DbType.String, info.ShareDesc);
            this.database.AddInParameter(sqlStringCommand, "CreatTime", DbType.DateTime, DateTime.Now);
            this.database.AddInParameter(sqlStringCommand, "image1", DbType.String, info.image1);
            this.database.AddInParameter(sqlStringCommand, "image2", DbType.String, info.image2);
            this.database.AddInParameter(sqlStringCommand, "image3", DbType.String, info.image3);
            this.database.AddInParameter(sqlStringCommand, "image4", DbType.String, info.image4);
            this.database.AddInParameter(sqlStringCommand, "image5", DbType.String, info.image5);
            this.database.AddInParameter(sqlStringCommand, "image6", DbType.String, info.image6);
            this.database.AddInParameter(sqlStringCommand, "image7", DbType.String, info.image7);
            this.database.AddInParameter(sqlStringCommand, "image8", DbType.String, info.image8);
            this.database.AddInParameter(sqlStringCommand, "image9", DbType.String, info.image9);
            return this.database.ExecuteNonQuery(sqlStringCommand);
        }

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

        public NineImgsesItem GetNineImgse(int id)
        {
            NineImgsesItem item = null;
            if (id <= 0)
            {
                return item;
            }
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("SELECT * FROM Vshop_ShareMaterial_NineImages WHERE id={0}", id));
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                return ReaderConvert.ReaderToModel<NineImgsesItem>(reader);
            }
        }

        public DbQueryResult GetNineImgsesList(NineImgsesQuery query)
        {
            StringBuilder builder = new StringBuilder();