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