public void load_gd_cau_hoi_by_id_cau_hoi()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_Load_Cau_Hoi_By_Id_Cau_Hoi_Hoc_Vien");
DS_V_GD_CAU_HOI_YEU_CAU v_ds = new DS_V_GD_CAU_HOI_YEU_CAU();
v_cstore.addDecimalInputParam("@ID_CAU_HOI", this.dcID_CAU_HOI);
v_cstore.fillDataSetByCommand(this, v_ds);
if (v_ds.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
DataRow2Me(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0]);
//this.strNOI_DUNG_CAU_HOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_CAU_HOI]);
//this.strNOI_DUNG_TRA_LOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_TRA_LOI]);
//this.strHO_TEN_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_SINH_VIEN]);
//this.strMA_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.MA_SINH_VIEN]);
//this.strLOP = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.LOP]);
//this.strNOI_SINH = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_SINH]);
//this.datNGAY_SINH = CIPConvert.ToDatetime(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString());
//this.strTRUONG = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.TRUONG]);
//this.strSO_DIEN_THOAI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.SO_DIEN_THOAI]);
//this.dcID_TRANG_THAI = CIPConvert.ToDecimal(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.ID_TRANG_THAI]);
}
}
private void load_data_2_grid()
{
string v_str_co_assign_qlht_yn = "";
if (m_rdb_assign_qlht_all.Checked)
{
v_str_co_assign_qlht_yn = "A";
}
else if (m_rdb_assign_qlht_y.Checked)
{
v_str_co_assign_qlht_yn = "Y";
}
else
{
v_str_co_assign_qlht_yn = "N";
}
m_ds = new DS_V_GD_CAU_HOI_YEU_CAU();
m_ds.EnforceConstraints = false;
m_us.fill_danh_sach_yeu_cau_hoc_vien(m_ds
, m_txt_dien_thoai.Text.Trim()
, m_txt_ho_ten.Text.Trim()
, m_dat_tu_ngay.Value
, m_dat_den_ngay.Value
, CIPConvert.ToDecimal(m_cbo_trang_thai_cau_hoi.SelectedValue)
, v_str_co_assign_qlht_yn);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
set_tree_on_grid();
make_stt();
}
public void load_call_history_hoc_vien_goi_lai(DS_V_GD_CAU_HOI_YEU_CAU i_ds
, string dien_thoai)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_load_call_history_hoc_vien_goi_lai");
v_cstore.addNVarcharInputParam("@DIEN_THOAI", dien_thoai);
v_cstore.fillDataSetByCommand(this, i_ds);
}
private void load_call_history_hoc_vien(string i_str_dien_thoai)
{
m_ds_v_cau_hoi_yeu_cau = new DS_V_GD_CAU_HOI_YEU_CAU();
m_us_v_cau_hoi_yeu_cau.load_call_history_hoc_vien_goi_lai(m_ds_v_cau_hoi_yeu_cau, i_str_dien_thoai);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_v_cau_hoi_yeu_cau, m_fg, m_trans_obj);
m_fg.Redraw = true;
make_stt();
}
public US_V_GD_CAU_HOI_YEU_CAU(decimal i_dbID)
{
pm_objDS = new DS_V_GD_CAU_HOI_YEU_CAU();
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]);
}
public US_V_GD_CAU_HOI_YEU_CAU(decimal i_dbID)
{
pm_objDS = new DS_V_GD_CAU_HOI_YEU_CAU();
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]);
}
public void fill_danh_sach_yeu_cau_hoc_vien(DS_V_GD_CAU_HOI_YEU_CAU i_ds
, string dien_thoai
, string i_str_ho_ten
, DateTime i_dt_tu_ngay
, DateTime i_dt_den_ngay
, decimal i_dc_id_trang_thai
, string i_str_co_assign_qlht_yn
)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_fill_danh_sach_yeu_cau_hoc_vien");
v_cstore.addNVarcharInputParam("@DIEN_THOAI", dien_thoai);
v_cstore.addNVarcharInputParam("@HO_TEN", i_str_ho_ten);
v_cstore.addDatetimeInputParam("@TU_NGAY", i_dt_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", i_dt_den_ngay);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", i_dc_id_trang_thai);
v_cstore.addNVarcharInputParam("@ASSIGN_QLHT_YN", i_str_co_assign_qlht_yn);
v_cstore.fillDataSetByCommand(this, i_ds);
}
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);
}
}
private void load_call_history_hoc_vien(string i_str_dien_thoai)
{
m_ds_v_cau_hoi_yeu_cau = new DS_V_GD_CAU_HOI_YEU_CAU();
m_us_v_cau_hoi_yeu_cau.load_call_history_hoc_vien(m_ds_v_cau_hoi_yeu_cau, i_str_dien_thoai);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_v_cau_hoi_yeu_cau, m_fg, m_trans_obj);
m_fg.Redraw = true;
make_stt();
//
// Trường hợp nếu học viên không tìm được trên SCM mà lại tìm được sdt trong lịch sử cuộc gọi
// thì sẽ tự động điền họ tên học viên lên form.
//
if (m_txt_ho_ten.Text.Trim() == "" &&
m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
m_txt_ho_ten.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_SINH_VIEN].ToString();
m_txt_ma_hoc_vien.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.MA_SINH_VIEN].ToString();
m_txt_ma_lop.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.LOP].ToString();
m_txt_noi_sinh.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NOI_SINH].ToString();
if (m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString() != "")
{
m_dtp_ngay_sinh.Value = CIPConvert.ToDatetime(m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString(), "dd/MM/yyyy hh:mi:ss");
}
m_cbo_truong.SelectedValue = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.TRUONG].ToString();
if (m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_QLHT].ToString() != "")
{
m_txt_ho_ten_qlht.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_QLHT].ToString();
}
if (m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.DIEN_THOAI_QLHT].ToString() != "")
{
m_txt_dien_thoai_qlht.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.DIEN_THOAI_QLHT].ToString();
}
}
}
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);
}
}
private void load_data_2_grid()
{
string v_str_co_assign_qlht_yn = "";
if (m_rdb_assign_qlht_all.Checked) v_str_co_assign_qlht_yn = "A";
else if (m_rdb_assign_qlht_y.Checked) v_str_co_assign_qlht_yn = "Y";
else v_str_co_assign_qlht_yn = "N";
m_ds = new DS_V_GD_CAU_HOI_YEU_CAU();
m_ds.EnforceConstraints = false;
m_us.fill_danh_sach_yeu_cau_hoc_vien(m_ds
, m_txt_dien_thoai.Text.Trim()
, m_txt_ho_ten.Text.Trim()
, m_dat_tu_ngay.Value
, m_dat_den_ngay.Value
, CIPConvert.ToDecimal(m_cbo_trang_thai_cau_hoi.SelectedValue)
, v_str_co_assign_qlht_yn);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
set_tree_on_grid();
make_stt();
}
private void load_call_history_hoc_vien(string i_str_dien_thoai)
{
m_ds_v_cau_hoi_yeu_cau = new DS_V_GD_CAU_HOI_YEU_CAU();
m_us_v_cau_hoi_yeu_cau.load_call_history_hoc_vien_goi_lai(m_ds_v_cau_hoi_yeu_cau,i_str_dien_thoai);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_v_cau_hoi_yeu_cau, m_fg, m_trans_obj);
m_fg.Redraw = true;
make_stt();
}
public US_V_GD_CAU_HOI_YEU_CAU()
{
pm_objDS = new DS_V_GD_CAU_HOI_YEU_CAU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public US_V_GD_CAU_HOI_YEU_CAU()
{
pm_objDS = new DS_V_GD_CAU_HOI_YEU_CAU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void load_call_history_hoc_vien(string i_str_dien_thoai)
{
m_ds_v_cau_hoi_yeu_cau = new DS_V_GD_CAU_HOI_YEU_CAU();
m_us_v_cau_hoi_yeu_cau.load_call_history_hoc_vien(m_ds_v_cau_hoi_yeu_cau,i_str_dien_thoai);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_v_cau_hoi_yeu_cau, m_fg, m_trans_obj);
m_fg.Redraw = true;
make_stt();
//
// Trường hợp nếu học viên không tìm được trên SCM mà lại tìm được sdt trong lịch sử cuộc gọi
// thì sẽ tự động điền họ tên học viên lên form.
//
if(m_txt_ho_ten.Text.Trim() == ""
&& m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
m_txt_ho_ten.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_SINH_VIEN].ToString();
m_txt_ma_hoc_vien.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][ V_GD_CAU_HOI_YEU_CAU.MA_SINH_VIEN].ToString();
m_txt_ma_lop.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.LOP].ToString();
m_txt_noi_sinh.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NOI_SINH].ToString();
if(m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString() != "")
m_dtp_ngay_sinh.Value = CIPConvert.ToDatetime(m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString(),"dd/MM/yyyy hh:mi:ss");
m_cbo_truong.SelectedValue = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.TRUONG].ToString();
if(m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_QLHT].ToString() != "")
m_txt_ho_ten_qlht.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_QLHT].ToString();
if (m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.DIEN_THOAI_QLHT].ToString() != "")
m_txt_dien_thoai_qlht.Text = m_ds_v_cau_hoi_yeu_cau.V_GD_CAU_HOI_YEU_CAU[0][V_GD_CAU_HOI_YEU_CAU.DIEN_THOAI_QLHT].ToString();
}
}
public void load_gd_cau_hoi_by_id_cau_hoi()
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_Load_Cau_Hoi_By_Id_Cau_Hoi_Hoc_Vien");
DS_V_GD_CAU_HOI_YEU_CAU v_ds = new DS_V_GD_CAU_HOI_YEU_CAU();
v_cstore.addDecimalInputParam("@ID_CAU_HOI", this.dcID_CAU_HOI);
v_cstore.fillDataSetByCommand(this, v_ds);
if (v_ds.V_GD_CAU_HOI_YEU_CAU.Rows.Count > 0)
{
DataRow2Me(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0]);
//this.strNOI_DUNG_CAU_HOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_CAU_HOI]);
//this.strNOI_DUNG_TRA_LOI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_DUNG_TRA_LOI]);
//this.strHO_TEN_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.HO_TEN_SINH_VIEN]);
//this.strMA_SINH_VIEN = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.MA_SINH_VIEN]);
//this.strLOP = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.LOP]);
//this.strNOI_SINH = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NOI_SINH]);
//this.datNGAY_SINH = CIPConvert.ToDatetime(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.NGAY_SINH].ToString());
//this.strTRUONG = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.TRUONG]);
//this.strSO_DIEN_THOAI = CIPConvert.ToStr(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.SO_DIEN_THOAI]);
//this.dcID_TRANG_THAI = CIPConvert.ToDecimal(v_ds.V_GD_CAU_HOI_YEU_CAU.Rows[0][V_GD_CAU_HOI_YEU_CAU.ID_TRANG_THAI]);
}
}
public void load_call_history_hoc_vien_goi_lai(DS_V_GD_CAU_HOI_YEU_CAU i_ds
, string dien_thoai)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_load_call_history_hoc_vien_goi_lai");
v_cstore.addNVarcharInputParam("@DIEN_THOAI", dien_thoai);
v_cstore.fillDataSetByCommand(this, i_ds);
}
public void fill_danh_sach_yeu_cau_hoc_vien(DS_V_GD_CAU_HOI_YEU_CAU i_ds
, string dien_thoai
, string i_str_ho_ten
, DateTime i_dt_tu_ngay
, DateTime i_dt_den_ngay
, decimal i_dc_id_trang_thai
, string i_str_co_assign_qlht_yn
)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_fill_danh_sach_yeu_cau_hoc_vien");
v_cstore.addNVarcharInputParam("@DIEN_THOAI", dien_thoai);
v_cstore.addNVarcharInputParam("@HO_TEN", i_str_ho_ten);
v_cstore.addDatetimeInputParam("@TU_NGAY", i_dt_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", i_dt_den_ngay);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", i_dc_id_trang_thai);
v_cstore.addNVarcharInputParam("@ASSIGN_QLHT_YN", i_str_co_assign_qlht_yn);
v_cstore.fillDataSetByCommand(this, i_ds);
}
