12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697 |
- 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;
- }
- }
- }
|