public US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG(decimal i_dbID) { pm_objDS = new DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_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]); }
public void FillDataset_by_thang_nam_id_nhan_vien( DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG op_ds_bc_lcd_nv_theo_thang, decimal ip_dc_thang, decimal ip_dc_nam, decimal ip_dc_id_nhan_vien, decimal ip_co_xem_lich_su_giao_dich) { CStoredProc v_cstore = new CStoredProc("pr_f419_bao_cao_lcd_1_nhan_vien_theo_thang_nam"); v_cstore.addDecimalInputParam("@ip_dc_thang", ip_dc_thang); v_cstore.addDecimalInputParam("@ip_dc_nam", ip_dc_nam); v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); v_cstore.addDecimalInputParam("@ip_co_xem_lich_su_giao_dich", ip_co_xem_lich_su_giao_dich); v_cstore.fillDataSetByCommand(this, op_ds_bc_lcd_nv_theo_thang); }
public US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG() { pm_objDS = new DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void load_data_2_grid_lcd(decimal ip_dc_id_nhan_vien, decimal ip_co_xem_lich_su_giao_dich) { CHRMCommon.make_stt(m_grv_bao_cao_lcd_nhan_vien); US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG v_us_bc_lcd_nv_theo_thang = new US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG(); DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG v_ds_bc_lcd_nv_theo_thang = new DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG(); v_us_bc_lcd_nv_theo_thang.FillDataset_by_thang_nam_id_nhan_vien(v_ds_bc_lcd_nv_theo_thang , CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()) , CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()) , ip_dc_id_nhan_vien , ip_co_xem_lich_su_giao_dich); m_grc_bao_cao_lcd_nhan_vien.DataSource = v_ds_bc_lcd_nv_theo_thang.Tables[0]; }