BKI_DichVuMatDat.US.US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG.LayDanhSachNhanVienHetHanLuongCheDo C# (CSharp) Method

LayDanhSachNhanVienHetHanLuongCheDo() public method

public LayDanhSachNhanVienHetHanLuongCheDo ( System.DateTime ip_dat_ngay_hien_tai ) : DataSet
ip_dat_ngay_hien_tai System.DateTime
return System.Data.DataSet
        public DataSet LayDanhSachNhanVienHetHanLuongCheDo(
            DateTime ip_dat_ngay_hien_tai)
        {
            CStoredProc v_sp = new CStoredProc("pr_lay_danh_sach_nv_het_han_lcd");
            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;
        }

Usage Example

 private DataSet get_nv_het_han_lcd()
 {
     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_LCD_NHAN_VIEN_THEO_THANG v_us_f419_lcd = new US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG();
         DataSet v_ds = v_us_f419_lcd.LayDanhSachNhanVienHetHanLuongCheDo(v_ngay_hien_tai);
         return v_ds;
     }
     catch(Exception v_e)
     {
         CSystemLog_301.ExceptionHandle(v_e);
         return null;
     }
 }