private void delete_v_gd_cau_hoi_yeu_cau()
{
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_GD_CAU_HOI_YEU_CAU v_us = new US_V_GD_CAU_HOI_YEU_CAU();
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 load_data_2_grid()
{
DateTime v_dat_tu_ngay, v_dat_den_ngay;
if (m_dat_tu_ngay.SelectedDate != CIPConvert.ToDatetime("01/01/0001"))
{
v_dat_tu_ngay = Convert.ToDateTime(m_dat_tu_ngay.SelectedDate);
}
else
{
v_dat_tu_ngay = Convert.ToDateTime("01/01/1900");
}
if (m_dat_den_ngay.SelectedDate != CIPConvert.ToDatetime("01/01/0001"))
{
v_dat_den_ngay = Convert.ToDateTime(m_dat_den_ngay.SelectedDate);
}
else
{
v_dat_den_ngay = Convert.ToDateTime("01/01/1900");
}
US_V_GD_CAU_HOI_YEU_CAU v_us = new US_V_GD_CAU_HOI_YEU_CAU();
DataSet v_ds = new DataSet();
v_ds = v_us.tong_hop_so_luong_cau_hoi_theo_ngay(v_dat_tu_ngay, v_dat_den_ngay);
m_grv_tong_hop_so_lieu.DataSource = v_ds.Tables[0];
m_grv_tong_hop_so_lieu.DataBind();
}
public DialogResult display(US_V_GD_CAU_HOI_YEU_CAU i_us)
{
load_data_2_cbo_truong();
m_us_cau_hoi_yeu_cau = i_us;
m_e_form_load = e_form_load.SEARCH_ON_LOAD_NO;
this.ShowDialog();
return(m_dlg_result);
}
private void us_object2grid(US_V_GD_CAU_HOI_YEU_CAU 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_GD_CAU_HOI_YEU_CAU 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);
}
public DialogResult display_search(string i_str_key_search, string i_str_ma_truong, US_V_GD_CAU_HOI_YEU_CAU i_us)
{
load_data_2_cbo_truong();
m_cbo_truong.SelectedValue = i_str_ma_truong;
m_txt_key_search.Text = i_str_key_search;
m_us_cau_hoi_yeu_cau = i_us;
m_e_form_load = e_form_load.SEARCH_ON_LOAD_YES;
m_e_co_lich_su_yn = e_tim_so_trong_lich_su_goi.CO_HOAC_KO_TRONG_LICH_SU_GOI;
this.ShowDialog();
return(m_dlg_result);
}
public void display_xu_ly_cau_hoi(US_V_GD_CAU_HOI_YEU_CAU i_us)
{
m_us_v_cau_hoi_yeu_cau = i_us;
load_data_2_cbo_truong();
m_txt_dien_thoai.Text = m_us_v_cau_hoi_yeu_cau.strSO_DIEN_THOAI;
m_txt_ho_ten.Text = m_us_v_cau_hoi_yeu_cau.strHO_TEN_SINH_VIEN;
m_txt_ma_hoc_vien.Text = m_us_v_cau_hoi_yeu_cau.strMA_SINH_VIEN;
m_txt_ma_lop.Text = m_us_v_cau_hoi_yeu_cau.strLOP;
if (!m_us_v_cau_hoi_yeu_cau.IsNGAY_SINHNull() &&
m_us_v_cau_hoi_yeu_cau.datNGAY_SINH != Convert.ToDateTime("01/01/1900"))
{
m_dtp_ngay_sinh.Value = m_us_v_cau_hoi_yeu_cau.datNGAY_SINH;
}
m_cbo_truong.SelectedValue = m_us_v_cau_hoi_yeu_cau.strTRUONG;
m_txt_ho_ten_qlht.Text = m_us_v_cau_hoi_yeu_cau.strHO_TEN_QLHT;
this.ShowDialog();
}
private void load_thong_tin_cau_hoi()
{
m_gd_cau_hoi_yeu_cau_hoc_vien = new US_V_GD_CAU_HOI_YEU_CAU();
m_gd_cau_hoi_yeu_cau_hoc_vien.dcID_CAU_HOI = m_dc_id_cau_hoi_xu_ly;
m_gd_cau_hoi_yeu_cau_hoc_vien.load_gd_cau_hoi_by_id_cau_hoi();
//Tab 1
m_txt_sv_ho_ten.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strHO_TEN_SINH_VIEN;
m_txt_sv_ma_lop.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strLOP;
m_txt_sv_dien_thoai.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strSO_DIEN_THOAI;
m_txt_ma_hoc_vien.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strMA_SINH_VIEN;
m_txt_sv_noi_sinh.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strNOI_SINH;
m_dat_sv_ngay_sinh.Value = m_gd_cau_hoi_yeu_cau_hoc_vien.datNGAY_SINH;
m_cbo_sv_truong.SelectedValue = m_gd_cau_hoi_yeu_cau_hoc_vien.strTRUONG; // trường sinh viên
m_tab1_txt_noi_dung_cau_hoi.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strNOI_DUNG_CAU_HOI;
load_thong_tin_qlht(m_gd_cau_hoi_yeu_cau_hoc_vien.strMA_SINH_VIEN);
// Tab 2
m_tab2_txt_noi_dung_cau_hoi.Text = m_gd_cau_hoi_yeu_cau_hoc_vien.strNOI_DUNG_CAU_HOI;
}
private void m_cmd_goi_lai_hoc_vien_Click(object sender, EventArgs e)
{
try{
if (!HelpUtils.is_validated_edit_grid_row(m_fg.Row, m_fg))
{
return;
}
f210_goi_lai_sinh_vien v_frm = new f210_goi_lai_sinh_vien();
US_V_GD_CAU_HOI_YEU_CAU v_us_v_cau_hoi = new US_V_GD_CAU_HOI_YEU_CAU();
DS_V_GD_CAU_HOI_YEU_CAU v_ds_v_cau_hoi = new DS_V_GD_CAU_HOI_YEU_CAU();
v_us_v_cau_hoi.FillDataset(v_ds_v_cau_hoi, "where id = " + CIPConvert.ToDecimal(m_fg[m_fg.Row, (int)e_col_Number.ID]));
if (v_ds_v_cau_hoi.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
v_us_v_cau_hoi.DataRow2Me(v_ds_v_cau_hoi.V_GD_CAU_HOI_YEU_CAU.Rows[0]);
v_frm.display_xu_ly_cau_hoi(v_us_v_cau_hoi);
}
}
catch (Exception v_e) {
CSystemLog_100.ExceptionHandle(v_e);
}
}
