BKI_DichVuMatDat.US.US_V_F419_BAO_CAO_HS_LNS_NHAN_VIEN_THEO_THANG.LayDanhSachNhanVienHetHanHeSoLuongNangSuat C# (CSharp) Method

        public DataSet LayDanhSachNhanVienHetHanHeSoLuongNangSuat(
            DateTime ip_dat_ngay_hien_tai)
        {
            CStoredProc v_sp = new CStoredProc("pr_lay_danh_sach_nv_het_han_hs_lns");
            v_sp.addDatetimeInputParam("@ip_dat_ngay_hien_tai", ip_dat_ngay_hien_tai);
            DataSet v_op_ds = new DataSet();
            v_op_ds.Tables.Add();

            //v_sp.fillDataSetByCommand(this, v_op_ds);
            return v_op_ds;
        }

        private DataSet get_nv_het_han_hs_lns()
        {
            try
            {
                DateTime v_ngay_hien_tai = DateTime.Now.Date;
                //DateTime v_ngay_hien_tai = Convert.ToDateTime("2045 - 06 - 01 00:00:00.000");
                US_V_F419_BAO_CAO_HS_LNS_NHAN_VIEN_THEO_THANG v_us_f419_hs_lns = new US_V_F419_BAO_CAO_HS_LNS_NHAN_VIEN_THEO_THANG();
                DataSet v_ds = v_us_f419_hs_lns.LayDanhSachNhanVienHetHanHeSoLuongNangSuat(v_ngay_hien_tai);

                return v_ds;
            }
            catch(Exception v_e)
            {
                CSystemLog_301.ExceptionHandle(v_e);
                return null;
            }
        }