public US_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG(decimal i_dbID) { pm_objDS = new DS_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
// load data to grid private void load_data_2_grid_theo_trang_thai(decimal id_trang_thai, DateTime dau_thang, DateTime cuoi_thang) { CHRMCommon.make_stt(m_grv_trang_thai_lao_dong); DS_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG v_ds_468 = new DS_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG(); US_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG v_us_468 = new US_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG(); v_us_468.FillDataset_by_thang_nam_and_id_trang_thai_ld(v_ds_468, dau_thang, cuoi_thang, id_trang_thai); m_grc_trang_thai_lao_dong.DataSource = v_ds_468.Tables[0]; }
public US_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG() { pm_objDS = new DS_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void FillDataset_by_thang_nam_and_id_trang_thai_ld(DS_V_F468_BAO_CAO_TRANG_THAI_LAO_DONG_THEO_THANG v_ds_468, DateTime dau_thang, DateTime cuoi_thang, decimal id_trang_thai) { CStoredProc v_sp = new CStoredProc("Pr_f468_by_thang_nam_and_id_trang_thai_ld"); v_sp.addDecimalInputParam("@ip_dc_id_ttld", id_trang_thai); v_sp.addDatetimeInputParam("@ip_dat_ngay_dau_thang", dau_thang); v_sp.addDatetimeInputParam("@ip_dat_ngay_cuoi_thang", cuoi_thang); v_sp.fillDataSetByCommand(this, v_ds_468); }