public US_V_DM_HOC_SINH(decimal i_dbID)
{
pm_objDS = new DS_V_DM_HOC_SINH();
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]);
}
private void load_data_2_grid()
{
m_ds = new DS_V_DM_HOC_SINH();
m_ds.Clear();
m_ds.EnforceConstraints = false;
if(m_cbo_trang_thai_hv.Text == "Đang học") {
m_us.FillDataset(m_ds
, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue)
, m_txt_search.Text.Trim()
, "Y");
}
else {
m_us.FillDataset(m_ds
, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue)
, m_txt_search.Text.Trim()
, "N");
}
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Subtotal(AggregateEnum.Count
, 0
, 0
, (int)e_col_Number.HO_TEN
, "Tổng");
wrap_text_cell();
CGridUtils.MakeSoTTofRowNotIsNode(0, m_fg, false);
m_fg.Redraw = true;
}
private void load_data_2_grid()
{
m_ds = new DS_V_DM_HOC_SINH();
m_us.FillDataset(m_ds
, CIPConvert.ToDecimal(m_cbo_lop_mon_cu.SelectedValue)
, ""
, "Y");
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Subtotal(AggregateEnum.Count
, 0
, 0
, (int)e_col_Number.HO_TEN
, "Tổng");
wrap_text_cell();
CGridUtils.MakeSoTTofRowNotIsNode(0, m_fg, false);
m_fg.Redraw = true;
}
//private void insert_gd_diem_danh()
//{
// for (int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; i++)
// {
// if (m_fg.GetCellCheck(i, 5) == CheckEnum.Checked)
// {
// 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();
// 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();
// }
// }
// BaseMessages.MsgBox_Infor("Bạn đã điểm danh thành công!!!");
//}
private void load_data_2_grid()
{
DS_V_DM_HOC_SINH m_ds = new DS_V_DM_HOC_SINH();
m_ds.Clear();
m_ds.EnforceConstraints = false;
m_us.FillDataset_danh_sach_hoc_sinh_theo_lop_mon(m_ds
, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_nguoi_diem_danh.SelectedValue)
, m_dat_tai_ngay.Value.Date
);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
update_di_hoc();
CGridUtils.MakeSoTT(0, m_fg);
m_fg.Redraw = true;
}
//public void FillDataset_danh_sach_hoc_sinh_theo_lop_mon(DS_V_DM_HOC_SINH op_ds
// , decimal ip_dc_id_lop_mon)
//{
// CStoredProc v_obj_spr = new CStoredProc("f320_danh_sach_hoc_sinh_theo_lop_mon");
// v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
// v_obj_spr.fillDataSetByCommand(this, op_ds);
//}
public void FillDataset_danh_sach_hoc_sinh_theo_lop_mon(
DS_V_DM_HOC_SINH op_ds
, decimal ip_dc_id_lop_mon
, decimal ip_dc_id_nguoi_diem_danh
, DateTime ip_dat_tai_ngay)
{
CStoredProc v_obj_spr = new CStoredProc("f320_danh_sach_hoc_sinh_theo_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj_spr.addDecimalInputParam("@ip_dc_id_nguoi_diem_danh", ip_dc_id_nguoi_diem_danh);
v_obj_spr.addDatetimeInputParam("@ip_dat_tai_ngay", ip_dat_tai_ngay);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public void FillDataset(DS_V_DM_HOC_SINH op_ds
, decimal ip_dc_id_lop_mon
, string ip_str_search
, string ip_str_trang_thai_hoc)
{
CStoredProc v_obj_spr = new CStoredProc("f230_danh_muc_hoc_sinh_theo_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj_spr.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_obj_spr.addNVarcharInputParam("@ip_str_trang_thai_hoc", ip_str_trang_thai_hoc);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public US_V_DM_HOC_SINH()
{
pm_objDS = new DS_V_DM_HOC_SINH();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
