Hidistro.SqlDal/Comments/ProductConsultationDao.cs

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

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

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

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

        public int DeleteProductConsultation(int consultationId)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_ProductConsultations WHERE consultationId = @consultationId");
            this.database.AddInParameter(sqlStringCommand, "ConsultationId", DbType.Int64, consultationId);
            return this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public DbQueryResult GetConsultationProducts(ProductConsultationAndReplyQuery consultationQuery)
        {
            StringBuilder builder = new StringBuilder();

            int roleId = 0;
            bool isDefault = false;
            int userid = Globals.GetCurrentManagerUserId(out roleId, out isDefault);
            builder.Append("  1=1 ");
            if (roleId == 3)
            {
                builder.Append("  AND  ShopManageUserId='" + userid + "'");
            }
            if (roleId == 4)
            {
                builder.Append("  AND (ShopManageUserId='0' OR ShopManageUserId IS NULL )");
            }

            builder.AppendFormat(" AND ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(consultationQuery.Keywords));
            if (consultationQuery.Type == ConsultationReplyType.NoReply)
            {
                builder.Append(" AND ReplyUserId IS NULL ");
            }
            else if (consultationQuery.Type == ConsultationReplyType.Replyed)
            {
                builder.Append(" AND ReplyUserId IS NOT NULL");
            }
            if (consultationQuery.ProductId > 0)
            {
                builder.AppendFormat(" AND ProductId = {0}", consultationQuery.ProductId);
            }
            if (consultationQuery.UserId > 0)
            {
                builder.AppendFormat(" AND UserId = {0}", consultationQuery.UserId);
            }
            if (!string.IsNullOrEmpty(consultationQuery.ProductCode))
            {
                builder.AppendFormat(" AND ProductCode LIKE '%{0}%'", DataHelper.CleanSearchString(consultationQuery.ProductCode));