public US_DM_CHUONG_LOAI_KHOAN_MUC(decimal i_dbID)
{
pm_objDS = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
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 static void load_data_to_ddl_chuong_loai_khoan_muc(
DropDownList op_ddl)
{
US_DM_CHUONG_LOAI_KHOAN_MUC v_us = new US_DM_CHUONG_LOAI_KHOAN_MUC();
DS_DM_CHUONG_LOAI_KHOAN_MUC v_ds = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
v_us.FillDataset(v_ds);
op_ddl.DataTextField = DM_CHUONG_LOAI_KHOAN_MUC.TEN;
op_ddl.DataValueField = DM_CHUONG_LOAI_KHOAN_MUC.ID;
op_ddl.DataSource = v_ds.DM_CHUONG_LOAI_KHOAN_MUC;
op_ddl.DataBind();
}
public US_DM_CHUONG_LOAI_KHOAN_MUC()
{
pm_objDS = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void load_data_to_ddl_tieu_muc()
{
m_ddl_tieu_muc.ClearSelection();
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_dm_chuong_loai_khoan_muc = new US_DM_CHUONG_LOAI_KHOAN_MUC();
DS_DM_CHUONG_LOAI_KHOAN_MUC v_ds_dm_chuong_loai_khoan_muc = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
v_us_dm_chuong_loai_khoan_muc.FillDataset(v_ds_dm_chuong_loai_khoan_muc, "where id_loai=" + ID_CHUONG_LOAI_KHOAN_MUC.TIEU_MUC
+ " and id_cha = " + m_ddl_muc.SelectedValue
+ " order by ma_so");
for (int i = 0; i < v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC.Count; i++)
{
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN] =
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.MA_SO] + " " +
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN];
v_ds_dm_chuong_loai_khoan_muc.AcceptChanges();
}
m_ddl_tieu_muc.DataValueField = DM_CHUONG_LOAI_KHOAN_MUC.ID;
m_ddl_tieu_muc.DataTextField = DM_CHUONG_LOAI_KHOAN_MUC.TEN;
m_ddl_tieu_muc.DataSource = v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC;
m_ddl_tieu_muc.DataBind();
m_ddl_tieu_muc.Items.Insert(0, new ListItem("---Chọn Tiểu mục---", "-1"));
}
private void load_data_to_ddl_loai()
{
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_dm_chuong_loai_khoan_muc = new US_DM_CHUONG_LOAI_KHOAN_MUC();
DS_DM_CHUONG_LOAI_KHOAN_MUC v_ds_dm_chuong_loai_khoan_muc = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
v_us_dm_chuong_loai_khoan_muc.FillDataset(v_ds_dm_chuong_loai_khoan_muc, "where id_loai=" + ID_CHUONG_LOAI_KHOAN_MUC.LOAI + " order by ma_so");
for (int i = 0; i < v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC.Count; i++)
{
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN] =
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.MA_SO] + " " +
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN];
v_ds_dm_chuong_loai_khoan_muc.AcceptChanges();
}
m_ddl_loai.DataValueField = DM_CHUONG_LOAI_KHOAN_MUC.ID;
m_ddl_loai.DataTextField = DM_CHUONG_LOAI_KHOAN_MUC.TEN;
m_ddl_loai.DataSource = v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC;
m_ddl_loai.DataBind();
m_ddl_loai.Items.Insert(0, new ListItem("---Chọn Loại---", "-1"));
}
private void load_data_to_ddl_chuong()
{
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_dm_chuong_loai_khoan_muc = new US_DM_CHUONG_LOAI_KHOAN_MUC();
DS_DM_CHUONG_LOAI_KHOAN_MUC v_ds_dm_chuong_loai_khoan_muc = new DS_DM_CHUONG_LOAI_KHOAN_MUC();
v_us_dm_chuong_loai_khoan_muc.FillDataset(v_ds_dm_chuong_loai_khoan_muc, "where id_loai=" + ID_CHUONG_LOAI_KHOAN_MUC.CHUONG + " order by ma_so");
for (int i = 0; i < v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC.Count; i++)
{
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN] =
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.MA_SO] + " " +
v_ds_dm_chuong_loai_khoan_muc.Tables[0].Rows[i][DM_CHUONG_LOAI_KHOAN_MUC.TEN];
v_ds_dm_chuong_loai_khoan_muc.AcceptChanges();
}
m_ddl_chuong.DataValueField = DM_CHUONG_LOAI_KHOAN_MUC.ID;
m_ddl_chuong.DataTextField = DM_CHUONG_LOAI_KHOAN_MUC.TEN;
m_ddl_chuong.DataSource = v_ds_dm_chuong_loai_khoan_muc.DM_CHUONG_LOAI_KHOAN_MUC;
m_ddl_chuong.DataBind();
//m_ddl_chuong.Items.Insert(0, new ListItem("---Chọn Chương---", "-1"));
m_ddl_chuong.SelectedValue = ID_CHUONG.BO_GIAO_THONG_VAN_TAI.ToString() ;
m_ddl_chuong.Enabled = false;
}
