test/Member/CoreEntity/DAL/PushFeedBackDAL.cs

using Common.Model;
using Common.Wechat;
using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class PushFeedBackDAL
    {
        public static List<PushFeedbackExt> GetFeedbacks(string PushRecordId,string filterstr = "")
        {
            List<List<Object>> parametersSupp = new List<List<Object>>();
            parametersSupp.Add(new List<object>() { "PushRecordId", Guid.Parse(PushRecordId)  });
            
            return GetFeedbacks(DataAccess.ToParameters(parametersSupp), " and PushRecordId = @PushRecordId "+filterstr);
        }
        public static List<PushFeedbackExt> GetFeedbacksIn(string Id, string filterstr = "")
        {
            List<List<Object>> parametersSupp = new List<List<Object>>();
            parametersSupp.Add(new List<object>() { "Id", Id });

            return GetFeedbacks(DataAccess.ToParameters(parametersSupp), " and Id in (@Id) " + filterstr);
        }

        public static List<PushFeedbackExt> GetFeedbacks(List<SqlParameter> prams, string filterstr = "")
        {
            DataTable dt = new DataTable();
            string commandTextSupp = "Select * From " + Config.TablePrefix + "PushFeedback where 1=1 " +
                filterstr;
            string resultSupp;
            
            DataAccess.GetValues(commandTextSupp, ref dt, prams.ToArray(), out resultSupp);

            if (dt != null && dt.Rows.Count > 0)
            {
                List<PushFeedbackExt> suplist = (List<PushFeedbackExt>)ModelConvertHelper<PushFeedbackExt>.ConvertToModel(dt);
                return suplist;
            }
            return new List<PushFeedbackExt>(0);
        }

        public static PushFeedbackExt GetFeedback(string PushFeedbackId)
        {
            DataTable dt = new DataTable();
            string commandTextSupp = "Select * From " + Config.TablePrefix + "PushFeedback where Id = @PushFeedbackId ";
            string resultSupp;

            List<List<Object>> parametersSupp = new List<List<Object>>();
            parametersSupp.Add(new List<object>() { "PushFeedbackId", Guid.Parse(PushFeedbackId) });
            DataAccess.GetValues(commandTextSupp, ref dt, DataAccess.ToParameters(parametersSupp).ToArray(), out resultSupp);

            if (dt != null && dt.Rows.Count > 0)
            {
                List<PushFeedbackExt> suplist = (List<PushFeedbackExt>)ModelConvertHelper<PushFeedbackExt>.ConvertToModel(dt);
                return suplist.ToArray()[0];
            }
            return null;
        }

        public static int DeleteFeedback(String Id)
        {

            string commandText = "DELETE FROM " + Config.TablePrefix + "PushFeedback WHERE Id = @Id";

            //准备参数
            List<List<Object>> parameters = new List<List<Object>>();
            parameters.Add(new List<Object>() { "Id", Guid.Parse(Id) });

            string result = "";
            List<SqlParameter> parameters1 = DataAccess.ToParameters(parameters);
            int success = DataAccess.ExecuteCommand(commandText, parameters1, out result);
            return success;
        }

        public static int MarkCancelFeedback(String Id)
        {

            string commandText = "UPDATE " + Config.TablePrefix + "PushFeedback SET IsCancel = 1 WHERE Id = @Id AND IsCancel = 0 ";

            //准备参数
            List<List<Object>> parameters = new List<List<Object>>();
            parameters.Add(new List<Object>() { "Id", Guid.Parse(Id) });

            string result = "";
            List<SqlParameter> parameters1 = DataAccess.ToParameters(parameters);
            int success = DataAccess.ExecuteCommand(commandText, parameters1, out result);
            return success;
        }

    }
}