BKI_DichVuMatDat.US.US_GD_LUONG_CHE_DO.GetLCDTheoHopDong C# (CSharp) Method

GetLCDTheoHopDong() public method

public GetLCDTheoHopDong ( decimal ip_id_hop_dong ) : DataTable
ip_id_hop_dong decimal
return System.Data.DataTable
        public DataTable GetLCDTheoHopDong(decimal ip_id_hop_dong)
        {
            CStoredProc v_cstore = new CStoredProc("pr_LCD_get_theo_hop_dong");
            v_cstore.addDecimalInputParam("@ip_id_hop_dong", ip_id_hop_dong);
            DS_GD_LUONG_CHE_DO v_ds = new DS_GD_LUONG_CHE_DO();
            v_cstore.fillDataSetByCommand(this, v_ds);
            return v_ds.Tables[0];
        }

Usage Example

 private bool check_gd_lcd()
 {
     US_GD_LUONG_CHE_DO v_us = new US_GD_LUONG_CHE_DO();
     DataTable v_dt = v_us.GetLCDTheoHopDong(m_us_gd_hd.dcID);
     if (v_dt.Rows.Count != 0)
     {
         DateTime v_ngay_ket_thuc_lns = Convert.ToDateTime(v_dt.Rows[0]["NGAY_KET_THUC"]);
         if (m_dat_ngay_ket_thuc.DateTime < v_ngay_ket_thuc_lns)
             return true;
     }
     return false;
 }