public object Get_ThongTinTuyen_TheoId(long idtuyen) { long TUYEN = Convert.ToInt64(idtuyen); QLVT_LuongTuyen ltt = qlvt.QLVT_LuongTuyen.Where(u => u.LT_IdLuongTuyen == TUYEN).FirstOrDefault(); if (ltt != null) { var ob = new { LT_IdLuongTuyen = ltt.LT_IdLuongTuyen, LT_MaTuyen = ltt.LT_MaTuyen, LT_DC_IdBen_01 = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01, LT_DC_IdBen_02 = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02, LT_DC_TenBen_01 = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01, LT_DC_TenBen_02 = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02, TuyenDuong = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01 + " - " + ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02, LT_DC_IdLuongTuyen = ltt.LT_DC_IdLuongTuyen, LT_HanhTrinhChay = ltt.LT_HanhTrinhChay, LT_LuuLuongQuyDinh = ltt.LT_LuuLuongQuyDinh, LT_PL_IdLuongTuyen = ltt.LT_PL_IdLuongTuyen, TT_IdTrangThaiTuyen = ltt.TT_IdTrangThaiTuyen }; return(ob); } return(null); }
public string TenTuyen_TheoId(long idtuyen) { long TUYEN = Convert.ToInt64(idtuyen); QLVT_LuongTuyen ltt = qlvt.QLVT_LuongTuyen.Where(u => u.LT_IdLuongTuyen == TUYEN).FirstOrDefault(); string st = ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01 + " - " + ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02; return(st); }
public string Get_DanhSachAll_TenTuyen_CuaBen_KhongTatCa(int idBen, long[] array) { QLVT_LuongTuyen ltt = new QLVT_LuongTuyen(); string string_return = ""; int IDBEN = Convert.ToInt32(idBen); var list = (from lt in qlvt.QLVT_LuongTuyen where lt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01 == IDBEN || lt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02 == IDBEN select new { LT_IdLuongTuyen = lt.LT_IdLuongTuyen, }).ToList(); if (array != null) { if (array.Length <= 3) { for (int i = 0; i < array.Length; i++) { long idtuyen = array[i]; ltt = qlvt.QLVT_LuongTuyen.Where(u => u.LT_IdLuongTuyen == idtuyen).FirstOrDefault(); string_return += ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01 + " - " + ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02; } string_return += "."; } else { int i = 3; for (int j = 0; j < i; j++) { ltt = qlvt.QLVT_LuongTuyen.Where(u => u.LT_IdLuongTuyen == array[j]).FirstOrDefault(); string_return += ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01 + " - " + ltt.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02; } ; string_return += ", ..."; } } return(string_return); }