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]);
 }
コード例 #2
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();
        }
コード例 #3
0
        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;
        }
コード例 #4
0
        //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();
 }