C# Class BKI_DichVuMatDat.US.US_GD_HOP_DONG

Inheritance: IP.Core.IPUserService.US_Object

Show file 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