private void cho_lop_cu_nghi_hoat_dong()
{
US_GD_HOC v_us = new US_GD_HOC();
DS_GD_HOC v_ds = new DS_GD_HOC();
v_us.FillDataset(v_ds, "WHERE ID_LOP_MON = " + CIPConvert.ToDecimal(m_cbo_lop_mon_cu.SelectedValue) + " and TRANG_THAI_YN = 'Y'");
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
DataRow v_dr = v_ds.Tables[0].Rows[i];
US_GD_HOC v_us_gd_hoc = new US_GD_HOC(CIPConvert.ToDecimal(v_dr[GD_HOC.ID]));
v_us_gd_hoc.BeginTransaction();
v_us_gd_hoc.strTRANG_THAI_YN = "N";
v_us_gd_hoc.datNGAY_KET_THUC = DateTime.Now.Date;
v_us_gd_hoc.Update();
v_us_gd_hoc.CommitTransaction();
}
US_DM_LOP_MON v_us_dm_lop_mon = new US_DM_LOP_MON(CIPConvert.ToDecimal(m_cbo_lop_mon_cu.SelectedValue));
v_us_dm_lop_mon.BeginTransaction();
v_us_dm_lop_mon.dcTRANG_THAI_LOP_MON = 89;
v_us_dm_lop_mon.Update();
v_us_dm_lop_mon.CommitTransaction();
}
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_GD_HOC v_us = new US_GD_HOC();
grid2us_object(v_us, m_fg.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
//v_us.DeleteByID(v_us.dcID);
//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();
}
}