private bool trung_ma_lop_mon() { try{ US_GD_LOP_MON v_us_dm_lop_mon = new US_GD_LOP_MON(); return(v_us_dm_lop_mon.check_trung_ma_lop_mon(m_txt_ma_lop_mon.Text)); }catch (Exception v_e) { throw v_e; } }
private decimal get_id_lop_mon_by_ma_lop_mon(string ip_str_ma_lop_mon) { DS_GD_LOP_MON v_ds_lop_mon = new DS_GD_LOP_MON(); US_GD_LOP_MON v_us_lop_mon = new US_GD_LOP_MON(); v_us_lop_mon.FillDataset(v_ds_lop_mon, " WHERE MA_LOP_MON = N'" + ip_str_ma_lop_mon + "'"); if (v_ds_lop_mon.GD_LOP_MON.Rows.Count == 0) { return(0); } return(CIPConvert.ToDecimal(v_ds_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.ID])); }
private void load_form_update() { try { m_us_gd_lop_mon = new US_GD_LOP_MON(m_dc_id_lop_mon); us_object_2_form(); } catch (Exception v_e) { throw v_e; } }
//private bool check_hop_ly_so_tien() //{ // if() // return false; // return true; //} private bool check_exist_ma_mon(string ip_str_ma_lop_mon) { US_GD_LOP_MON v_us_gd_lop_mon = new US_GD_LOP_MON(); DS_GD_LOP_MON v_ds_gd_lop_mon = new DS_GD_LOP_MON(); v_us_gd_lop_mon.FillDataset(v_ds_gd_lop_mon, " WHERE MA_LOP_MON='" + ip_str_ma_lop_mon + "'"); if (v_ds_gd_lop_mon.GD_LOP_MON.Rows.Count == 0) { return(false); // Nghĩa là không tồn tại lớp môn đó } return(true); // Nghĩa là tồn tại lớp môn đó }
private void m_cmd_delete_Click(object sender, EventArgs e) { var v_data_row = m_grv.GetDataRow(m_grv.FocusedRowHandle); US_GD_LOP_MON v_us = new US_GD_LOP_MON(CIPConvert.ToDecimal(v_data_row["ID"].ToString())); DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa bản ghi này không?", "Cảnh báo", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { v_us.Delete(); } load_data_2_grid(); }
private string get_ma_lop_mon(decimal i_dc_id_lop_mon) { try { US_GD_LOP_MON v_us = new US_GD_LOP_MON(i_dc_id_lop_mon); if (v_us.IsMA_LOP_MONNull()) { return(""); } else { return(v_us.strMA_LOP_MON); } } catch (Exception v_e) { throw v_e; } }
public string mapping_time_lop_mon(string ip_str_ma_lop_mon) { US_GD_LOP_MON v_us_gd_lop_mon = new US_GD_LOP_MON(); DS_GD_LOP_MON v_ds_gd_lop_mon = new DS_GD_LOP_MON(); v_us_gd_lop_mon.FillDataset(v_ds_gd_lop_mon, " WHERE MA_LOP_MON=N'" + ip_str_ma_lop_mon + "'"); if (v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_BAT_DAU].GetType() == typeof(DBNull)) { if (v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_KET_THUC].GetType() == typeof(DBNull)) { return(""); } else { return(CIPConvert.ToStr(v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_KET_THUC], "dd/MM/yyyy")); } } else if (v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_KET_THUC].GetType() == typeof(DBNull)) { return(CIPConvert.ToStr(v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_BAT_DAU], "dd/MM/yyyy")); } return(CIPConvert.ToStr(v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_BAT_DAU], "dd/MM/yyyy") + " - " + CIPConvert.ToStr(v_ds_gd_lop_mon.GD_LOP_MON.Rows[0][GD_LOP_MON.NGAY_KET_THUC], "dd/MM/yyyy")); }