public virtual void DeleteRange(IList <T> datas)
{
using (messageEntities db = new messageEntities())
{
IList <T> list = new List <T>();
foreach (T data in datas)
{
Type type = data.GetType();
PropertyInfo[] members = type.GetProperties();
List <string> ids = new List <string>();
foreach (PropertyInfo m in members)
{
var temp = m.GetCustomAttribute <KeyAttribute>();
if (temp != null)
{
object obj = m.GetValue(data);
ids.Add(obj.ToString());
continue;
}
}
T entity = db.Set <T>().Find(ids.ToArray());
list.Add(entity);
}
if (list.Count > 0)
{
foreach (var l in list)
{
db.Set <T>().Remove(l);
}
db.SaveChanges();
}
}
}
public virtual IList <T> FindAll()
{
using (messageEntities entity = new messageEntities())
{
return(entity.Set <T>().ToList());
}
}
public virtual void Delete(T data)
{
using (messageEntities db = new messageEntities())
{
Type type = data.GetType();
PropertyInfo[] members = type.GetProperties();
List <string> ids = new List <string>();
foreach (PropertyInfo m in members)
{
var temp = m.GetCustomAttribute <KeyAttribute>();
if (temp != null)
{
object obj = m.GetValue(data);
ids.Add(obj.ToString());
continue;
}
}
T entity = db.Set <T>().Find(ids.ToArray());
if (entity != default(T))
{
db.Set <T>().Remove(entity);
db.SaveChanges();
}
}
}
public IList <mq_task> GetTaskList()
{
using (DataAccess.messageEntities entity = new messageEntities())
{
return(entity.mq_task.Where(p => p.enable == 1).ToList());
}
}
public void RemoveAll()
{
using (var entity = new messageEntities())
{
entity.Database.ExecuteSqlCommand("delete from mq_message");
}
}
public virtual T Find(string id)
{
using (messageEntities db = new messageEntities())
{
T entity = db.Set <T>().Find(id);
return(entity);
}
}
public virtual void Update(T data)
{
using (messageEntities db = new messageEntities())
{
db.Entry <T>(data).State = EntityState.Modified;
db.SaveChanges();
}
}
public IList <mq_message> GetUnHandleMessage(string task_code)
{
using (var entity = new messageEntities())
{
var code = task_code;
return(entity.mq_message
.Where(p => p.task_code == code && (p.status == (int)MessageStatus.UnHandle || p.status == (int)MessageStatus.Retry))
.ToList());
}
}
public void Update(string taskCode, int status)
{
using (DataAccess.messageEntities entity = new messageEntities())
{
var task = entity.mq_task.FirstOrDefault(p => p.enable == 1 && p.code == taskCode);
if (task != null)
{
task.status = status;
entity.SaveChanges();
}
}
}
private void updateMessageStatus(TaskMessage msg, MessageStatus status)
{
using (var entity = new messageEntities())
{
var m = entity.mq_message.FirstOrDefault(p => p.code == msg.code);
if (m != null)
{
m.status = (int)status;
entity.SaveChanges();
}
}
}
public void UpdateStatus(string msg_code, MessageStatus status)
{
using (var entity = new messageEntities())
{
var m = entity.mq_message.FirstOrDefault(p => p.code == msg_code);
if (m != null)
{
m.status = (int)status;
m.updatetime = DateTime.Now;
entity.SaveChanges();
}
}
}
public virtual T Add(T data)
{
using (messageEntities entity = new messageEntities())
{
entity.Set <T>().Add(data);
try
{
entity.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
return(data);
}
}
public virtual void AddRange(IList <T> datas)
{
using (messageEntities entity = new messageEntities())
{
foreach (var data in datas)
{
entity.Set <T>().Add(data);
}
try
{
entity.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
}
}
