BKI_DichVuMatDat.US.US_GD_HOP_DONG.lay_danh_sach_nhan_su_giam_trong_ky C# (CSharp) Method

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
        public DataTable lay_danh_sach_nhan_su_giam_trong_ky(int month, int year)
        {
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add();
            CStoredProc v_cstore = new CStoredProc("pr_BC_nhan_su_giam_trong_ky");
            v_cstore.addDecimalInputParam("@thang", month);
            v_cstore.addDecimalInputParam("@nam", year);
            v_cstore.fillDataSetByCommand(this, v_ds);
            return v_ds.Tables[0];
        }

Usage Example

 private void load_data_to_data_table()
 {
     US_GD_HOP_DONG v_us = new US_GD_HOP_DONG();
     m_dt_dau_ki = v_us.lay_danh_sach_nhan_su_dau_ky(m_date.Month, m_date.Year);
     m_dt_cuoi_ky = v_us.lay_danh_sach_nhan_su_cuoi_ky(m_date.Month, m_date.Year);
     m_dt_ld_giam = v_us.lay_danh_sach_nhan_su_giam_trong_ky(m_date.Month, m_date.Year);
     m_dt_ld_tang = v_us.lay_danh_sach_nhan_su_tang_trong_ky(m_date.Month, m_date.Year);
     m_dt_chuyen_doi = v_us.lay_danh_sach_nhan_su_chuyen_doi(m_date.Month, m_date.Year);
     m_dt_hoc_viec = v_us.lay_danh_sach_hoc_viec_trong_ky(m_date.Month, m_date.Year);
 }