public static object GetAll(filter filter) { using (DB db = new DB()) { var data = db.MKV7001.AsEnumerable().OrderByDescending(a => a.date).Select(p => new { p.ghiChu, p.date, p.MKV7000_ID, p.MKV7001_ID, p.MKV9999_ID, p.MKV9999_ID2, p.noiDung, p.tieuDe, count = db.MKV7001.Where(j => j.MKV9999_ID2 == filter.MKV9999_ID && j.MKV9999_ID == p.MKV9999_ID && j.trangthai == false).Count(), p.trangthai, MKV9999 = AccountGett.GetAccount(new AccountGett.filter() { id = p.MKV9999_ID }), MKV99992 = AccountGett.GetAccount(new AccountGett.filter() { id = p.MKV9999_ID2 }), }); if (filter.MKV7001_ID != null) { return(data.Where(p => p.MKV7001_ID == filter.MKV7001_ID).FirstOrDefault()); } if (filter.MKV9999_ID != null) { data = data.Where(p => p.MKV9999_ID == filter.MKV9999_ID || p.MKV9999_ID2 == filter.MKV9999_ID); } if (filter.trangthai != null) { data = data.Where(p => p.trangthai == filter.trangthai); } if (filter.mybox != null) { data = data.GroupBy(f => new { f.MKV9999_ID, f.MKV9999_ID2 }).Select(x => x.FirstOrDefault()); } if (filter.point != null) { data = data.Where(p => p.MKV9999_ID == filter.MKV9999_ID && p.MKV9999_ID2 == filter.MKV9999_ID2 || p.MKV9999_ID == filter.MKV9999_ID2 && p.MKV9999_ID2 == filter.MKV9999_ID); data = data.Where(a => a.date < filter.point).Take((int)filter.length); } return(data.ToList()); } }
public HttpResponseMessage getnguoiphongvan(string id) { using (DB db = new DB()) { var data = db.A0028E.AsEnumerable().Where(p => p.A0028_ID == id).Select(p => new { p.A0028E_ID, p.A0028_ID, p.MKV9999_ID, MKV9999 = AccountGett.GetAccount(new AccountGett.filter() { id = p.MKV9999_ID }) }); return(REST.GetHttpResponseMessFromObject(data)); } }