- DM_BangCap [ api/DM_BangCap/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_CapBac [ api/DM_CapBac/ ] + SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_ChucVu [ api/DM_ChucVu/ ] + SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_ChucVuDang [ api/DM_ChucVuDang/ ] + SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_CoSoYT [ api/DM_CoSoYT/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_DanToc [ api/DM_DanToc/ ] + SelectAll()
+ SelectOne(long _ID)
+ Insert(string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_DiaDanh [ api/DM_DiaDanh/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,long? _CapChaID, string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, long? _CapChaID, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_DonVi [ api/DM_DonVi/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,long? _MasterID,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, long? _MasterID, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy )
+ SelectByDonVi_ID(long _DonViID )
- DM_NhanVienBangCap [ api/DM_NhanVienBangCap/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(long _NhanVienID,long _BangCapID,string _CreatedBy)
+ Update(long _ID,long _NhanVienID, long _BangCapID,string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_NhanVienChucVu [ api/DM_NhanVienChucVu/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ SelectChucVuByNhanVienID(long _NhanVienID)
+ Insert(long _NhanVienID,long _ChucVuID,string _CreatedBy)
+ Update(long _ID,long _NhanVienID, long _ChucVuID,string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_NhanVien [ api/DM_NhanVien/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ SelectNhanVienByUser(string _UserName)
+ Insert(string _Ten,DateTime? _NamSinh,string _SDT,long? _DonViID,long? _DanTocID,long? _CapBacID,long? _ChucVuDangID,string _GhiChu, string _CreatedBy)
+ Update(long _ID, string _Ten, DateTime? _NamSinh, string _SDT,long? _DonViID, long? _DanTocID, long? _CapBacID, long? _ChucVuDangID, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_PhanMem [ api/DM_PhanMem/ ]
+ SelectAll()
+ SelectOne(long _ID)
(_isTrangPublic: 1 bắt buộc qua login,0 trang publuc) + Insert(string _TenTat,string _Ten,string _GhiChu,string _sUrl, string _sUrlQuanTri, int _isTrangPublic,string _sIcon,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu,string _sUrl, string _sUrlQuanTri, int _isTrangPublic,string _sIcon, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_QuocTich [ api/DM_QuocTich/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ Insert(string _TenTat,string _Ten,string _GhiChu,string _CreatedBy)
+ Update(long _ID,string _TenTat, string _Ten, string _GhiChu, string _UpdateBy)
+ Delete(long _ID, string _UpdateBy)
+ Lock(long _ID, string _UpdateBy)
- DM_Users [ api/Users/ ]
+ SelectAll()
+ SelectOne(string _UserName)
+ Insert(string _UserName, string _Password, long? _NhanVienID, string _CreatedBy)
+ Update(string _UserName, string _Password, long? _NhanVienID, string _UpdateBy)
+ Delete(string _UserName, string _UpdateBy)
+ Lock(string _UserName, string _UpdateBy)
+ Login(string _UserName, string _Password)
+ SelectDonViByUserName(string _UserName)
- DM_PhanMemLogin [ api/DM_PhanMemLogin/ ]
+ SelectAll()
+ SelectOne(long _ID)
+ SelectByPhanMemID(long _PhanMemID)
+ SelectByUserName(string _UserName)
+ SelectByUserNameAndPhanMemID(string _UserName,long _PhanMemID)
+ Insert(long _PhanMemID, string _UserName)
+ Update(long _ID, long _PhanMemID, string _UserName)
+ Delete(long _ID)
+ DeleteByUserName(string _UserName)
+ DeleteByPhanMemID(long _PhanMemID)
+ DeleteByUserNameAndPhanMemID(string _UserName,long _PhanMemID)