public US_V_RPT_CHI_TIET_PHIEU_THU(decimal i_dbID)
{
pm_objDS = new DS_V_RPT_CHI_TIET_PHIEU_THU();
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 bool check_phieu_is_exist()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue), m_dat_tai_ngay.Value.Date);
if (v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count == 0)
{
return false;
}
else
{
return true;
}
}
public US_V_RPT_CHI_TIET_PHIEU_THU()
{
pm_objDS = new DS_V_RPT_CHI_TIET_PHIEU_THU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDataset_by_id_lm_id_hs(DS_V_RPT_CHI_TIET_PHIEU_THU op_rpt, decimal ip_dc_id_hoc_sinh, decimal ip_dc_id_lop_mon, DateTime ip_dat_ngay_thu)
{
CStoredProc v_obj = new CStoredProc("pr_lay_ds_phieu_pt_theo_hs_lop_thang");
v_obj.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh);
v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj.addDatetimeInputParam("@ip_dat_ngay_thu", ip_dat_ngay_thu);
v_obj.fillDataSetByCommand(this, op_rpt);
}
private void delete_phieu_cu()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue), m_dat_tai_ngay.Value.Date);
for (int i = 0; i < v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count; i++)
{
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu_detail = new US_V_RPT_CHI_TIET_PHIEU_THU(v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows[i]);
try
{
v_us_v_rpt_chi_tiet_phieu_thu_detail.BeginTransaction();
v_us_v_rpt_chi_tiet_phieu_thu_detail.DeleteByID(v_us_v_rpt_chi_tiet_phieu_thu_detail.dcID);
v_us_v_rpt_chi_tiet_phieu_thu_detail.CommitTransaction();
}
catch (Exception v_e)
{
v_us_v_rpt_chi_tiet_phieu_thu_detail.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
//BaseMessages.MsgBox_Infor("Không xóa được học sinh này do học sinh này đang học một lớp môn nào đó!");
}
}
}
private void delete_phieu_cu()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
US_V_F340_LOP_MON_CUA_HS v_us_lm_hs = new US_V_F340_LOP_MON_CUA_HS();
grid2us_object(v_us_lm_hs, v_i_cur_row);
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(v_us_lm_hs.dcID_LOP_MON), m_dat_ngay_thu.Value.Date);
for (int i = 0; i < v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count; i++)
{
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu_detail = new US_V_RPT_CHI_TIET_PHIEU_THU(v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows[i]);
v_us_v_rpt_chi_tiet_phieu_thu_detail.BeginTransaction();
v_us_v_rpt_chi_tiet_phieu_thu_detail.DeleteByID(v_us_v_rpt_chi_tiet_phieu_thu_detail.dcID);
v_us_v_rpt_chi_tiet_phieu_thu_detail.CommitTransaction();
}
}
}
private bool check_phieu_is_exist()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
int check_phieu_is_exist = 0;
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
US_V_F340_LOP_MON_CUA_HS v_us_lm_hs = new US_V_F340_LOP_MON_CUA_HS();
grid2us_object(v_us_lm_hs, v_i_cur_row);
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset_by_id_lm_id_hs(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(v_us_lm_hs.dcID_HOC_SINH), CIPConvert.ToDecimal(v_us_lm_hs.dcID_LOP_MON), m_dat_ngay_thu.Value.Date);
if (v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count != 0)
{
check_phieu_is_exist = check_phieu_is_exist + 1;
}
}
if (check_phieu_is_exist != 0)
{
return true;
}
else
{
return false;
}
}
private void delete_phieu_cu()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue), m_dat_tai_ngay.Value.Date);
for (int i = 0; i < v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count; i++)
{
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu_detail = new US_V_RPT_CHI_TIET_PHIEU_THU(v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows[i]);
v_us_v_rpt_chi_tiet_phieu_thu_detail.BeginTransaction();
v_us_v_rpt_chi_tiet_phieu_thu_detail.DeleteByID(v_us_v_rpt_chi_tiet_phieu_thu_detail.dcID);
v_us_v_rpt_chi_tiet_phieu_thu_detail.CommitTransaction();
}
}
