C# Class BKI_DichVuMatDat.US.US_GD_HOP_DONG

Inheritance: IP.Core.IPUserService.US_Object
显示文件 Open project: assassinadal/BKIProject-DichVuMatDat Class Usage Examples

Public Methods

Method Description
FillDataSetThongTinHopDong ( decimal ip_dc_id_nhan_vien ) : DataSet
FillDatasetBCTangGiamLD ( System.DateTime ip_tu_ngay, System.DateTime ip_den_ngay ) : DataSet
FillDatasetHDTheoNgayKy ( DataSet v_ds, System.DateTime ip_tu_ngay, System.DateTime ip_den_ngay ) : void
FillDatasetHopDong ( DataSet v_ds, decimal v_id_don_vi ) : void
GetHopDongHienTaiCuaNV ( string ip_id_nv ) : decimal
IsGHI_CHUNull ( ) : bool
IsIDNull ( ) : bool
IsID_CHUC_VUNull ( ) : bool
IsID_DON_VINull ( ) : bool
IsID_LOAI_HOP_DONGNull ( ) : bool
IsID_LOAI_LAO_DONGNull ( ) : bool
IsID_LUONG_CHE_DONull ( ) : bool
IsID_NHAN_VIENNull ( ) : bool
IsMA_HOP_DONGNull ( ) : bool
IsNGAY_BAT_DAUNull ( ) : bool
IsNGAY_KET_THUCNull ( ) : bool
IsNGAY_KY_HOP_DONGNull ( ) : bool
IsNGAY_LAPNull ( ) : bool
IsNGAY_SUANull ( ) : bool
IsNGUOI_LAPNull ( ) : bool
IsNGUOI_SUANull ( ) : bool
IsSO_TIEN_LCDNull ( ) : bool
KiemTraThoiGianHopDongHopLeForInsert ( decimal ip_dc_id_nhan_vien, System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : bool
KiemTraThoiGianHopDongHopLeForUpdate ( decimal ip_dc_id_gd_hop_dong, System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : bool
LayDanhSachHDHetHanTrongThang ( ) : DataSet
LayDanhSachHopDong ( string ip_str_filter, decimal ip_dc_thang, decimal ip_dc_nam ) : DataTable
LayDanhSachHopDongConHieuLuc ( ) : DataTable
LayDanhSachHopDongHetHan ( System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : DataSet
LayDanhSachHopDongHetHanSauNgay ( System.DateTime ip_dat_tu_ngay ) : DataSet
LayDanhSachHopDongHetHanTruocNgay ( System.DateTime ip_dat_den_ngay ) : DataSet
LayDanhSachHopDongHetHanV2 ( System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : DataSet
LayHopDongCuoiCungNhanVien ( decimal ip_dc_id_nhan_vien ) : DataRow
LayMaMucLNSCuaHopDong ( decimal ip_dc_id_hop_dong_con_hieu_luc, decimal &op_dc_he_so, string &op_str_ma, string &op_str_muc ) : void
SetGHI_CHUNull ( ) : void
SetIDNull ( ) : void
SetID_CHUC_VUNull ( ) : void
SetID_DON_VINull ( ) : void
SetID_LOAI_HOP_DONGNull ( ) : void
SetID_LOAI_LAO_DONGNull ( ) : void
SetID_LUONG_CHE_DONull ( ) : void
SetID_NHAN_VIENNull ( ) : void
SetMA_HOP_DONGNull ( ) : void
SetNGAY_BAT_DAUNull ( ) : void
SetNGAY_KET_THUCNull ( ) : void
SetNGAY_KY_HOP_DONGNull ( ) : void
SetNGAY_LAPNull ( ) : void
SetNGAY_SUANull ( ) : void
SetNGUOI_LAPNull ( ) : void
SetNGUOI_SUANull ( ) : void
SetSO_TIEN_LCDNull ( ) : void
ThongKeNhanVienTaiNgay ( System.DateTime ip_data_tai_ngay ) : DataSet
US_GD_HOP_DONG ( ) : System
US_GD_HOP_DONG ( DataRow i_objDR ) : System
US_GD_HOP_DONG ( decimal i_dbID ) : System
lap_hop_dong_moi_cho_nhan_vien ( decimal ID_NHAN_VIEN, decimal ID_LOAI_HOP_DONG, string MA_HOP_DONG, System.DateTime NGAY_BAT_DAU, System.DateTime NGAY_KET_THUC, System.DateTime NGAY_KY_HOP_DONG, System.DateTime NGAY_LAP, string NGUOI_LAP, string DA_XOA, decimal ID_CD_LCD, decimal ID_MUC_LCD, decimal ID_CD_LNS, decimal ID_MUC_LNS, string &op_str_mess ) : void
lay_danh_sach_hoc_viec_trong_ky ( int month, int year ) : DataTable
lay_danh_sach_nhan_su_chuyen_doi ( int month, int year ) : DataTable
lay_danh_sach_nhan_su_cuoi_ky ( int month, int year ) : DataTable
lay_danh_sach_nhan_su_dau_ky ( int month, int year ) : DataTable
lay_danh_sach_nhan_su_giam_trong_ky ( int month, int year ) : DataTable
lay_danh_sach_nhan_su_tang_trong_ky ( int month, int year ) : DataTable

Method Details

FillDataSetThongTinHopDong() public method

public FillDataSetThongTinHopDong ( decimal ip_dc_id_nhan_vien ) : DataSet
ip_dc_id_nhan_vien decimal
return System.Data.DataSet

FillDatasetBCTangGiamLD() public method

public FillDatasetBCTangGiamLD ( System.DateTime ip_tu_ngay, System.DateTime ip_den_ngay ) : DataSet
ip_tu_ngay System.DateTime
ip_den_ngay System.DateTime
return System.Data.DataSet

FillDatasetHDTheoNgayKy() public method

public FillDatasetHDTheoNgayKy ( DataSet v_ds, System.DateTime ip_tu_ngay, System.DateTime ip_den_ngay ) : void
v_ds System.Data.DataSet
ip_tu_ngay System.DateTime
ip_den_ngay System.DateTime
return void

FillDatasetHopDong() public method

public FillDatasetHopDong ( DataSet v_ds, decimal v_id_don_vi ) : void
v_ds System.Data.DataSet
v_id_don_vi decimal
return void

GetHopDongHienTaiCuaNV() public method

public GetHopDongHienTaiCuaNV ( string ip_id_nv ) : decimal
ip_id_nv string
return decimal

IsGHI_CHUNull() public method

public IsGHI_CHUNull ( ) : bool
return bool

IsIDNull() public method

public IsIDNull ( ) : bool
return bool

IsID_CHUC_VUNull() public method

public IsID_CHUC_VUNull ( ) : bool
return bool

IsID_DON_VINull() public method

public IsID_DON_VINull ( ) : bool
return bool

IsID_LOAI_HOP_DONGNull() public method

public IsID_LOAI_HOP_DONGNull ( ) : bool
return bool

IsID_LOAI_LAO_DONGNull() public method

public IsID_LOAI_LAO_DONGNull ( ) : bool
return bool

IsID_LUONG_CHE_DONull() public method

public IsID_LUONG_CHE_DONull ( ) : bool
return bool

IsID_NHAN_VIENNull() public method

public IsID_NHAN_VIENNull ( ) : bool
return bool

IsMA_HOP_DONGNull() public method

public IsMA_HOP_DONGNull ( ) : bool
return bool

IsNGAY_BAT_DAUNull() public method

public IsNGAY_BAT_DAUNull ( ) : bool
return bool

IsNGAY_KET_THUCNull() public method

public IsNGAY_KET_THUCNull ( ) : bool
return bool

IsNGAY_KY_HOP_DONGNull() public method

public IsNGAY_KY_HOP_DONGNull ( ) : bool
return bool

IsNGAY_LAPNull() public method

public IsNGAY_LAPNull ( ) : bool
return bool

IsNGAY_SUANull() public method

public IsNGAY_SUANull ( ) : bool
return bool

IsNGUOI_LAPNull() public method

public IsNGUOI_LAPNull ( ) : bool
return bool

IsNGUOI_SUANull() public method

public IsNGUOI_SUANull ( ) : bool
return bool

IsSO_TIEN_LCDNull() public method

public IsSO_TIEN_LCDNull ( ) : bool
return bool

KiemTraThoiGianHopDongHopLeForInsert() public method

public KiemTraThoiGianHopDongHopLeForInsert ( decimal ip_dc_id_nhan_vien, System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : bool
ip_dc_id_nhan_vien decimal
ip_dat_tu_ngay System.DateTime
ip_dat_den_ngay System.DateTime
return bool

KiemTraThoiGianHopDongHopLeForUpdate() public method

public KiemTraThoiGianHopDongHopLeForUpdate ( decimal ip_dc_id_gd_hop_dong, System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : bool
ip_dc_id_gd_hop_dong decimal
ip_dat_tu_ngay System.DateTime
ip_dat_den_ngay System.DateTime
return bool

LayDanhSachHDHetHanTrongThang() public method

public LayDanhSachHDHetHanTrongThang ( ) : DataSet
return System.Data.DataSet

LayDanhSachHopDong() public method

public LayDanhSachHopDong ( string ip_str_filter, decimal ip_dc_thang, decimal ip_dc_nam ) : DataTable
ip_str_filter string
ip_dc_thang decimal
ip_dc_nam decimal
return System.Data.DataTable

LayDanhSachHopDongConHieuLuc() public method

public LayDanhSachHopDongConHieuLuc ( ) : DataTable
return System.Data.DataTable

LayDanhSachHopDongHetHan() public method

public LayDanhSachHopDongHetHan ( System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : DataSet
ip_dat_tu_ngay System.DateTime
ip_dat_den_ngay System.DateTime
return System.Data.DataSet

LayDanhSachHopDongHetHanSauNgay() public method

public LayDanhSachHopDongHetHanSauNgay ( System.DateTime ip_dat_tu_ngay ) : DataSet
ip_dat_tu_ngay System.DateTime
return System.Data.DataSet

LayDanhSachHopDongHetHanTruocNgay() public method

public LayDanhSachHopDongHetHanTruocNgay ( System.DateTime ip_dat_den_ngay ) : DataSet
ip_dat_den_ngay System.DateTime
return System.Data.DataSet

LayDanhSachHopDongHetHanV2() public method

public LayDanhSachHopDongHetHanV2 ( System.DateTime ip_dat_tu_ngay, System.DateTime ip_dat_den_ngay ) : DataSet
ip_dat_tu_ngay System.DateTime
ip_dat_den_ngay System.DateTime
return System.Data.DataSet

LayHopDongCuoiCungNhanVien() public method

public LayHopDongCuoiCungNhanVien ( decimal ip_dc_id_nhan_vien ) : DataRow
ip_dc_id_nhan_vien decimal
return System.Data.DataRow

LayMaMucLNSCuaHopDong() public method

public LayMaMucLNSCuaHopDong ( decimal ip_dc_id_hop_dong_con_hieu_luc, decimal &op_dc_he_so, string &op_str_ma, string &op_str_muc ) : void
ip_dc_id_hop_dong_con_hieu_luc decimal
op_dc_he_so decimal
op_str_ma string
op_str_muc string
return void

SetGHI_CHUNull() public method

public SetGHI_CHUNull ( ) : void
return void

SetIDNull() public method

public SetIDNull ( ) : void
return void

SetID_CHUC_VUNull() public method

public SetID_CHUC_VUNull ( ) : void
return void

SetID_DON_VINull() public method

public SetID_DON_VINull ( ) : void
return void

SetID_LOAI_HOP_DONGNull() public method

public SetID_LOAI_HOP_DONGNull ( ) : void
return void

SetID_LOAI_LAO_DONGNull() public method

public SetID_LOAI_LAO_DONGNull ( ) : void
return void

SetID_LUONG_CHE_DONull() public method

public SetID_LUONG_CHE_DONull ( ) : void
return void

SetID_NHAN_VIENNull() public method

public SetID_NHAN_VIENNull ( ) : void
return void

SetMA_HOP_DONGNull() public method

public SetMA_HOP_DONGNull ( ) : void
return void

SetNGAY_BAT_DAUNull() public method

public SetNGAY_BAT_DAUNull ( ) : void
return void

SetNGAY_KET_THUCNull() public method

public SetNGAY_KET_THUCNull ( ) : void
return void

SetNGAY_KY_HOP_DONGNull() public method

public SetNGAY_KY_HOP_DONGNull ( ) : void
return void

SetNGAY_LAPNull() public method

public SetNGAY_LAPNull ( ) : void
return void

SetNGAY_SUANull() public method

public SetNGAY_SUANull ( ) : void
return void

SetNGUOI_LAPNull() public method

public SetNGUOI_LAPNull ( ) : void
return void

SetNGUOI_SUANull() public method

public SetNGUOI_SUANull ( ) : void
return void

SetSO_TIEN_LCDNull() public method

public SetSO_TIEN_LCDNull ( ) : void
return void

ThongKeNhanVienTaiNgay() public method

public ThongKeNhanVienTaiNgay ( System.DateTime ip_data_tai_ngay ) : DataSet
ip_data_tai_ngay System.DateTime
return System.Data.DataSet

US_GD_HOP_DONG() public method

public US_GD_HOP_DONG ( ) : System
return System

US_GD_HOP_DONG() public method

public US_GD_HOP_DONG ( DataRow i_objDR ) : System
i_objDR System.Data.DataRow
return System

US_GD_HOP_DONG() public method

public US_GD_HOP_DONG ( decimal i_dbID ) : System
i_dbID decimal
return System

lap_hop_dong_moi_cho_nhan_vien() public method

public lap_hop_dong_moi_cho_nhan_vien ( decimal ID_NHAN_VIEN, decimal ID_LOAI_HOP_DONG, string MA_HOP_DONG, System.DateTime NGAY_BAT_DAU, System.DateTime NGAY_KET_THUC, System.DateTime NGAY_KY_HOP_DONG, System.DateTime NGAY_LAP, string NGUOI_LAP, string DA_XOA, decimal ID_CD_LCD, decimal ID_MUC_LCD, decimal ID_CD_LNS, decimal ID_MUC_LNS, string &op_str_mess ) : void
ID_NHAN_VIEN decimal
ID_LOAI_HOP_DONG decimal
MA_HOP_DONG string
NGAY_BAT_DAU System.DateTime
NGAY_KET_THUC System.DateTime
NGAY_KY_HOP_DONG System.DateTime
NGAY_LAP System.DateTime
NGUOI_LAP string
DA_XOA string
ID_CD_LCD decimal
ID_MUC_LCD decimal
ID_CD_LNS decimal
ID_MUC_LNS decimal
op_str_mess string
return void

lay_danh_sach_hoc_viec_trong_ky() public method

public lay_danh_sach_hoc_viec_trong_ky ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable

lay_danh_sach_nhan_su_chuyen_doi() public method

public lay_danh_sach_nhan_su_chuyen_doi ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable

lay_danh_sach_nhan_su_cuoi_ky() public method

public lay_danh_sach_nhan_su_cuoi_ky ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable

lay_danh_sach_nhan_su_dau_ky() public method

public lay_danh_sach_nhan_su_dau_ky ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable

lay_danh_sach_nhan_su_giam_trong_ky() public method

public lay_danh_sach_nhan_su_giam_trong_ky ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable

lay_danh_sach_nhan_su_tang_trong_ky() public method

public lay_danh_sach_nhan_su_tang_trong_ky ( int month, int year ) : DataTable
month int
year int
return System.Data.DataTable