public HttpResponseMessage Get([FromBody] searchkey value) { using (DB db = new DB()) { var result = timkiem.tim(value); return(result); } }
public static HttpResponseMessage tim(searchkey value) { using (var db = new DB()) { valuesearch result = new valuesearch(); result.KTX0020 = db.KTX0020.AsEnumerable().Where(temp => temp.hotenkhaisinh == value.key || temp.hotenkhac == value.key || temp.cmtnd_so == value.key || temp.didong == value.key || temp.MKV9999_ID == (db.MKV9999.Where(p => p.manhansu == value.key).Select(p => p.MKV9999_ID).FirstOrDefault()) || temp.khoaphong == value.key //|| //temp.sotu == value.key || //temp.sokhoatu == value.key || //temp.KTX0001_ID != null && temp.KTX0001_ID == (db.KTX0001.Where(p => p.ten == value.key).Select(p => p.KTX0001_ID).FirstOrDefault()) || //temp.KTX0002_ID != null && temp.KTX0002_ID == (db.KTX0002.Where(p => p.ten == value.key).Select(p => p.KTX0002_ID).FirstOrDefault()) || //temp.KTX0003_ID != null && temp.KTX0003_ID == (db.KTX0003.Where(p => p.SoTu == value.key).Select(p => p.KTX0003_ID).FirstOrDefault()) ).Select(temp => new { temp.KTX0020_ID, temp.MKV9999_ID, temp.ngaytaodon, temp.trangthai, temp.bengiao, temp.bennhan, temp.bietngoaingu, temp.biettiengdantocitnguoi, temp.bqlktx, temp.choohiennay, temp.chunhiemnoilamviec, temp.cmtnd_ngaycap, temp.cmtnd_noicap, temp.cmtnd_so, temp.dantoc, temp.didong, temp.ghichu, temp.gioitinh, temp.hotenkhac, temp.hotenkhaisinh, temp.khoaphong, temp.KTX0001_ID, temp.KTX0002_ID, temp.KTX0003_ID, temp.lamgiodautu14tuoi, temp.lydo, temp.lydodangkyoktx, temp.lydonguyenvong, temp.ngaycohieuluc, temp.ngayduyetdon, temp.ngayokitucxa, temp.ngayquaylaikytucxa, temp.ngaysinh, temp.nghenghiepchucvunoilam, temp.nguyenvongophongso, temp.nharieng, temp.noidung, temp.noisinh, temp.noithuongtru, temp.okitucxa, temp.quaylaikytucxa, temp.quequan, temp.sokhoatu, temp.somayle, temp.sotu, temp.thoigiantralantruoc, temp.tongiao, temp.trinhdchuyenmon, temp.trinhdohocvan, temp.truongphongGA, temp.truongphongnoilamviec, KTX0001 = db.Database.SqlQuery <KTX0001>("select * from ktx0001 where KTX0001_id=" + (temp.KTX0001_ID != null ? temp.KTX0001_ID : 0)).FirstOrDefault(), KTX0002 = db.Database.SqlQuery <KTX0002>("select * from ktx0002 where KTX0002_id=" + (temp.KTX0002_ID != null ? temp.KTX0002_ID : 0)).FirstOrDefault(), KTX0003 = db.Database.SqlQuery <KTX0003>("select * from ktx0003 where KTX0003_id=" + (temp.KTX0003_ID != null ? temp.KTX0003_ID : 0)).FirstOrDefault(), //KTX0021 = db.KTX0021.Where(p => p.KTX0020_ID == temp.KTX0020_ID).ToList(), KTX0031 = (from temp2 in db.KTX0031 where temp2.MKV9999_ID == temp.MKV9999_ID && temp.trangthai == true select new { temp2.ghichu, temp2.KTX0010_ID, temp2.KTX0031_ID, temp2.MKV9999_ID, temp2.ngaycap, temp2.ngaytra, temp2.soluongcap, temp2.soluongtra, temp2.thutu, temp2.trangthai, KTX0010 = (from l in db.KTX0010 where l.KTX0010_ID == temp2.KTX0010_ID select new { l.ghichu, l.giatien, l.donvi, l.KTX0010_ID, l.loai, l.maSanPham, l.soluongmacdinh, l.soLuongTonKho, l.ten, l.thutu, l.trangthai, l.WH0007_ID, }).FirstOrDefault() }), MKV9999 = (from f in db.MKV9999 where temp.MKV9999_ID == f.MKV9999_ID select new { f.MKV9999_ID, f.manhansu, f.matkhau, f.id, f.hodem, f.ten, f.ngaysinh, f.gioitinh, f.noisinh, f.quequan, f.diachithuongtru, f.diachitamtru, f.cmtnd_so, f.cmtnd_ngayhethan, f.cmtnd_noicap, f.hochieu_so, f.hochieu_ngaycap, f.hochieu_ngayhethan, f.ngayvaocongty, f.phong_id, f.ban_id, f.congdoan_id, f.chucvu_id, f.nganhang_stk, f.nganhang_id, f.sosobaohiem, f.honnhantinhtrang, f.datnuoc_id, f.phuongxa, f.suckhoetinhtrang, f.dienthoai_nharieng, f.dienthoai_didong, f.email, f.tinhtrangnhansu, f.thutu, f.chucvu, f.capbac, bophan = (from klj in db.MKV9998 where klj.phong_id == f.phong_id select klj).FirstOrDefault(), ban = (from klj in db.MKV9998 where klj.phong_id == f.ban_id select klj).FirstOrDefault(), thetu_id = (from t in db.MKV9998 where t.phong_id == f.phong_id select t.bophan_ten).FirstOrDefault(), }).FirstOrDefault(), }).ToList(); result.KTX0023 = (from temp in db.KTX0023 where temp.nldhoten == value.key || temp.MKV9999_ID == (db.MKV9999.FirstOrDefault(p => p.cmtnd_so == value.key).MKV9999_ID) || temp.MKV9999_ID == (db.MKV9999.FirstOrDefault(p => p.manhansu == value.key).MKV9999_ID) || temp.didong == value.key || temp.khoaphong == value.key || temp.sotu == value.key || temp.sokhoatu == value.key || temp.KTX0001_ID == (db.KTX0001.FirstOrDefault(p => p.ten == value.key).KTX0001_ID) || temp.KTX0002_ID == (db.KTX0002.FirstOrDefault(p => p.ten == value.key).KTX0002_ID) || temp.KTX0003_ID == (db.KTX0003.FirstOrDefault(p => p.MaKhoa == value.key).KTX0003_ID) select new { temp.banqlktx, temp.bqlhoten, temp.bqlkynhan, temp.chunhiemGA, temp.chunhiemnoilam, temp.didong, temp.khoaphong, temp.KTX0001_ID, temp.KTX0002_ID, temp.KTX0003_ID, temp.KTX0023_ID, temp.lydotra, temp.MKV9999_ID, temp.ngaycohieuluc, temp.ngaytrakytucxa, temp.nldhoten, temp.nhanxet, temp.nldkynhan, temp.sokhoatu, temp.somayle, temp.sotu, temp.tonggiatriboithuong, temp.trakytucxa, temp.truongphongnoilam, temp.trangthai, temp.ngaytaodon, KTX0001 = db.KTX0001.Where(p => p.KTX0001_ID == temp.KTX0001_ID).FirstOrDefault(), KTX0002 = db.KTX0002.Where(p => p.KTX0002_ID == temp.KTX0002_ID).FirstOrDefault(), MKV9999 = (from f in db.MKV9999 where temp.MKV9999_ID == f.MKV9999_ID select new { f.MKV9999_ID, f.manhansu, f.matkhau, f.id, f.hodem, f.ten, f.ngaysinh, f.gioitinh, f.noisinh, f.quequan, f.diachithuongtru, f.diachitamtru, f.cmtnd_so, f.cmtnd_ngayhethan, f.cmtnd_noicap, f.hochieu_so, f.hochieu_ngaycap, f.hochieu_ngayhethan, f.ngayvaocongty, f.phong_id, f.ban_id, f.congdoan_id, f.chucvu_id, f.nganhang_stk, f.nganhang_id, f.sosobaohiem, f.honnhantinhtrang, f.datnuoc_id, f.phuongxa, f.suckhoetinhtrang, f.dienthoai_nharieng, f.dienthoai_didong, f.email, f.tinhtrangnhansu, f.thutu, f.chucvu, f.capbac, bophan = (from klj in db.MKV9998 where klj.phong_id == f.phong_id select klj).FirstOrDefault(), ban = (from klj in db.MKV9998 where klj.phong_id == f.ban_id select klj).FirstOrDefault(), thetu_id = (from t in db.MKV9998 where t.phong_id == f.phong_id select t.bophan_ten).FirstOrDefault(), }).FirstOrDefault(), KTX0031 = (from temp2 in db.KTX0031 where temp2.MKV9999_ID == temp.MKV9999_ID && temp.trangthai == true select new { temp2.ghichu, temp2.KTX0010_ID, temp2.KTX0031_ID, temp2.MKV9999_ID, temp2.ngaycap, temp2.ngaytra, temp2.soluongcap, temp2.soluongtra, temp2.thutu, temp2.trangthai, KTX0010 = (from l in db.KTX0010 where l.KTX0010_ID == temp2.KTX0010_ID select new { l.ghichu, l.giatien, l.donvi, l.KTX0010_ID, l.loai, l.maSanPham, l.soluongmacdinh, l.soLuongTonKho, l.ten, l.thutu, l.trangthai, l.WH0007_ID, }).FirstOrDefault() }) }).ToList(); return(REST.GetHttpResponseMessFromObject(result)); } }