private void diem_danh_lop_mon() { for (int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; i++) { DS_GD_DIEM_DANH v_ds_diem_danh = new DS_GD_DIEM_DANH(); US_GD_DIEM_DANH v_us_diem_danh = new US_GD_DIEM_DANH(); US_V_DM_HOC_SINH v_us_dm_hs = new US_V_DM_HOC_SINH(); decimal op_dc_id_gd_diem_danh = 0; if ((m_fg.GetCellCheck(i, 5) == CheckEnum.Checked) && (v_us_diem_danh.check_diem_danh_hs( CIPConvert.ToDecimal(m_fg.Rows[i][(int)e_col_Number.ID_HOC_SINH]) , CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue) , CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue) , m_dat_tai_ngay.Value.Date , ref op_dc_id_gd_diem_danh))) { continue; } else if ((m_fg.GetCellCheck(i, 5) == CheckEnum.Checked) && (!v_us_diem_danh.check_diem_danh_hs( CIPConvert.ToDecimal(m_fg.Rows[i][(int)e_col_Number.ID_HOC_SINH]) , CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue) , CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue) , m_dat_tai_ngay.Value.Date , ref op_dc_id_gd_diem_danh))) { v_us_diem_danh.dcID_HOC_SINH = CIPConvert.ToDecimal(m_fg.Rows[i][(int)e_col_Number.ID_HOC_SINH]); v_us_diem_danh.dcID_LOP_MON = CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue); v_us_diem_danh.dcID_NGUOI_NHAP = CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue); v_us_diem_danh.dcID_NGUOI_DIEM_DANH = CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue); v_us_diem_danh.datNGAY_HOC = m_dat_tai_ngay.Value.Date; v_us_diem_danh.dcID_CA_HOC = CIPConvert.ToDecimal(m_cbo_ca_hoc.SelectedValue); v_us_diem_danh.Insert(); } else if ((m_fg.GetCellCheck(i, 5) == CheckEnum.Unchecked) && (v_us_diem_danh.check_diem_danh_hs( CIPConvert.ToDecimal(m_fg.Rows[i][(int)e_col_Number.ID_HOC_SINH]) , CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue) , CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue) , m_dat_tai_ngay.Value.Date , ref op_dc_id_gd_diem_danh))) { v_us_diem_danh.dcID = op_dc_id_gd_diem_danh; v_us_diem_danh.Delete(); } else { continue; } } BaseMessages.MsgBox_Infor("Bạn đã điểm danh thành công!!!"); }
private void us_object2grid(US_V_DM_HOC_SINH i_us , int i_grid_row) { DataRow v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData; i_us.Me2DataRow(v_dr); m_obj_trans.DataRow2GridRow(v_dr, i_grid_row); }
private void grid2us_object(US_V_DM_HOC_SINH i_us , int i_grid_row) { DataRow v_dr; v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData; m_obj_trans.GridRow2DataRow(i_grid_row, v_dr); i_us.DataRow2Me(v_dr); }
private void delete_v_dm_hoc_sinh() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return; if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return; US_V_DM_HOC_SINH v_us = new US_V_DM_HOC_SINH(); grid2us_object(v_us, m_fg.Row); try { v_us.BeginTransaction(); v_us.Delete(); v_us.CommitTransaction(); m_fg.Rows.Remove(m_fg.Row); } catch (Exception v_e) { v_us.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage(); } }
private void cho_hoc_sinh_hoc_lop_moi() { for (int i = 0; i < m_ds.Tables[0].Rows.Count; i++) { DataRow v_dr = m_ds.Tables[0].Rows[i]; US_V_DM_HOC_SINH v_us_v_dm_hs = new US_V_DM_HOC_SINH(CIPConvert.ToDecimal(v_dr[V_DM_HOC_SINH.ID])); US_GD_HOC v_us_gd_hoc = new US_GD_HOC(); v_us_gd_hoc.BeginTransaction(); v_us_gd_hoc.dcID_HOC_SINH = v_us_v_dm_hs.dcID; v_us_gd_hoc.dcID_LOP_MON = CIPConvert.ToDecimal(m_cbo_lop_mon_moi.SelectedValue); v_us_gd_hoc.strTRANG_THAI_YN = "Y"; v_us_gd_hoc.datNGAY_BAT_DAU = DateTime.Now.Date; v_us_gd_hoc.datNGAY_KET_THUC = CIPConvert.ToDatetime("01/01/3000", "dd/MM/yyyy"); v_us_gd_hoc.Insert(); v_us_gd_hoc.CommitTransaction(); } }
private void update_di_hoc() { for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++) { US_V_DM_HOC_SINH v_us_dm_hs = new US_V_DM_HOC_SINH(); grid2us_object(v_us_dm_hs, v_i_cur_row); decimal op_dc_id_gd_diem_danh = 0; if (!v_us_dm_hs.check_diem_danh_hs( CIPConvert.ToDecimal(m_fg.Rows[v_i_cur_row][(int)e_col_Number.ID_HOC_SINH]) , CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue) , CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue) , m_dat_tai_ngay.Value.Date , ref op_dc_id_gd_diem_danh)) { m_fg.SetCellCheck(v_i_cur_row, 5, CheckEnum.None); } else { m_fg.SetCellCheck(v_i_cur_row, 5, CheckEnum.Checked); } } }