public US_V_F330_LEN_LUONG_CHO_NV(decimal i_dbID) { pm_objDS = new DS_V_F330_LEN_LUONG_CHO_NV(); 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]); }
private void load_data_2_grid(decimal ip_dc_id_nv) { CHRMCommon.make_stt(m_grv_tang_giam_luong_cho_nv); US_V_F330_LEN_LUONG_CHO_NV v_us = new US_V_F330_LEN_LUONG_CHO_NV(); DS_V_F330_LEN_LUONG_CHO_NV v_ds = new DS_V_F330_LEN_LUONG_CHO_NV(); v_us.FillDataset(v_ds, "WHERE ID = " + ip_dc_id_nv); m_grc_tang_giam_luong_cho_nv.DataSource = v_ds.Tables[0]; m_grv_tang_giam_luong_cho_nv.BestFitColumns(); }
private void focus_new_row_created() { int v_row_index = 0; decimal v_id_hs_lns_hien_tai_f330 = 0; decimal v_id_lcd_hien_tai_f330 = 0; US_V_F330_LEN_LUONG_CHO_NV v_us = new US_V_F330_LEN_LUONG_CHO_NV(); DS_V_F330_LEN_LUONG_CHO_NV v_ds = new DS_V_F330_LEN_LUONG_CHO_NV(); v_id_hs_lns_hien_tai_f330 = find_id_hs_lns(CIPConvert.ToDecimal(m_sle_chuc_danh_lns.EditValue), CIPConvert.ToDecimal(m_sle_muc_lns.EditValue)); v_id_lcd_hien_tai_f330 = find_id_lcd(CIPConvert.ToDecimal(m_sle_chuc_danh_lcd.EditValue), CIPConvert.ToDecimal(m_sle_muc_lcd.EditValue)); v_us.FillDataset(v_ds); for (v_row_index = 0; v_row_index < v_ds.Tables[0].Rows.Count; v_row_index++) { var v_gd_hs_lns_grv = CIPConvert.ToDecimal(m_grv_tang_giam_luong_cho_nv.GetDataRow(v_row_index)["ID_HS_LNS"].ToString()); var v_gd_lcd_grv = CIPConvert.ToDecimal(m_grv_tang_giam_luong_cho_nv.GetDataRow(v_row_index)["ID_LCD"].ToString()); var v_gd_hd_grv = CIPConvert.ToDecimal(m_grv_tang_giam_luong_cho_nv.GetDataRow(v_row_index)["ID_HOP_DONG"].ToString()); if (v_gd_hs_lns_grv == v_id_hs_lns_hien_tai_f330 && v_gd_lcd_grv == v_id_lcd_hien_tai_f330 && v_gd_hd_grv == m_id_gd_hd) { break; } } m_grv_tang_giam_luong_cho_nv.FocusedRowHandle = v_row_index; }
//clear data in form private void clear_data_in_form() { m_sle_chon_nhan_vien.EditValue = null; m_sle_chon_quyet_dinh.EditValue = null; m_lbl_hs_lns.Text = "..."; m_lbl_so_tien_lcd.Text = "..."; m_sle_chuc_danh_lns.EditValue = null; m_sle_muc_lns.EditValue = null; m_sle_chuc_danh_lcd.EditValue = null; m_sle_muc_lcd.EditValue = null; m_lbl_hs_lns.Text = "..."; m_lbl_so_tien_lcd.Text = "..."; DS_V_F330_LEN_LUONG_CHO_NV v_ds = new DS_V_F330_LEN_LUONG_CHO_NV(); m_grc_tang_giam_luong_cho_nv.DataSource = v_ds.Tables[0]; }
public US_V_F330_LEN_LUONG_CHO_NV() { pm_objDS = new DS_V_F330_LEN_LUONG_CHO_NV(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }