DOI CHIEU XML 3 Quay lai man hinh chon

_tumlumtala / XML 3

Doi chieu noi bo file XML 3 theo ma_lk

Tai 1 file XML 3 de he thong doi chieu noi bo theo ma_lk va xuat workbook canh bao rieng. Ket qua gom 2 sheet: sheet du lieu goc co cot CANH_BAO va sheet tong hop tat ca dong loi.

Tai file XML 3

Phan he nay doi chieu rieng, khong anh huong cac man doi chieu khac. He thong can cac cot: ma_lk, ma_nhom, ma_bac_si, nguoi_thuc_hien, ma_may, ngay_th_yl, ngay_kq, pp_vo_cam, ten_dich_vu.

San sang.

Cac dieu kien dang kiem tra

  • ma_nhom 1, 2, 3, 8, 18 co thieu ma_bac_si, nguoi_thuc_hien, ma_may hay khong; rieng cac dich vu thu cong nhu Lam thuoc tai, Lay nut bieu bi ong tai ngoai thi duoc phep khong co ma_may.
  • Trung gio ngay_th_yl khi cung ten_dich_vu, cung nguoi_thuc_hien, cung ma_may giua cac ma_lk khac nhau; neu khong co ma_may thi doi chieu theo ten_dich_vu va nguoi_thuc_hien.
  • pp_vo_cam 2, 4 thieu ma_may thi canh bao, tru cac dich vu thu cong da duoc cau hinh bo qua nhu xoa bop, Lam thuoc tai, Lay nut bieu bi ong tai ngoai.
  • Bo sung ghi chu neu trong cung ma_lk bi trung ma_nhom ngoai tru ma_nhom = 1.