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();
}
private string get_id_mix_from_id_gd(decimal ip_dc_id_giao_von)
{
US_GD_CHI_TIET_GIAI_NGAN v_us = new US_GD_CHI_TIET_GIAI_NGAN(ip_dc_id_giao_von);
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(v_us.dcID_KHOAN);
string v_str_id_mix = "";
v_str_id_mix += v_us.dcID_CHUONG + "|";//chuong
v_str_id_mix += v_us_khoan.dcID_CHA + "|";//loai
v_str_id_mix += v_us.dcID_KHOAN + "|";//khoan
v_str_id_mix += v_us.dcID_MUC + "|";//muc
if (!v_us.IsID_TIEU_MUCNull())
{
v_str_id_mix += v_us.dcID_TIEU_MUC;//tieu muc
}
return v_str_id_mix;
}
private void us_object_to_form()
{
m_us = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value));
//US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an_cong_trinh = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(m_us.dcID_DU_AN_CONG_TRINH);
m_ddl_chuong.SelectedValue = m_us.dcID_CHUONG.ToString();
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(m_us.dcID_KHOAN);
m_ddl_loai.SelectedValue = v_us_khoan.dcID_CHA.ToString();
load_data_to_ddl_khoan();
m_ddl_khoan.SelectedValue = m_us.dcID_KHOAN.ToString();
m_ddl_muc.SelectedValue = m_us.dcID_MUC.ToString();
load_data_to_ddl_tieu_muc();
if (!m_us.IsID_TIEU_MUCNull())
{
m_ddl_tieu_muc.SelectedValue = m_us.dcID_TIEU_MUC.ToString();
}
m_txt_so_tien.Text = m_us.dcSO_TIEN_NS.ToString();
m_txt_ghi_chu.Text = m_us.strGHI_CHU;
//if (m_us.dcID_LOAI_GIAO_DICH == ID_LOAI_GIAO_DICH.KH_DAU_NAM)
//{
// m_rdb_kh_dau_nam.Checked = true;
// m_rdb_dieu_chinh.Checked = false;
// m_rdb_bo_sung.Checked = false;
//}
//else if (m_us.dcID_LOAI_GIAO_DICH == ID_LOAI_GIAO_DICH.BO_SUNG)
//{
// m_rdb_kh_dau_nam.Checked = false;
// m_rdb_dieu_chinh.Checked = false;
// m_rdb_bo_sung.Checked = true;
//}
//else
//{
// m_rdb_kh_dau_nam.Checked = false;
// m_rdb_dieu_chinh.Checked = true;
// m_rdb_bo_sung.Checked = false;
//}
//set quyet dinh
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH);
m_txt_so_qd.Text = v_us_quyet_dinh.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us_quyet_dinh.strNOI_DUNG;
m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_hdf_id_quyet_dinh.Value = v_us_quyet_dinh.dcID.ToString();
disable_edit_quyet_dinh();
}
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;
}
private void us_object_to_form()
{
m_us = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value));
if (!m_us.IsTU_CHU_YNNull())
{
if (m_us.strTU_CHU_YN == "Y")
{
m_rdb_chi_thuong_xuyen.Checked = true;
m_rdb_chi_khong_thuong_xuyen.Checked = false;
}
else
{
m_rdb_chi_thuong_xuyen.Checked = false;
m_rdb_chi_khong_thuong_xuyen.Checked = true;
}
}
m_txt_so_km.Text = m_us.strGHI_CHU_2;
if (Request.QueryString["ip_nguon_ns"] == "N")
{
m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_QUY_BT);
}
else
{
m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NS);
}
m_txt_so_tien_nam_truoc_chuyen_sang.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NAM_TRUOC_CHUYEN_SANG);
m_txt_ghi_chu.Text = m_us.strGHI_CHU;
//m_txt_ten_quoc_lo.Text = v_us_du_an_cong_trinh.strTEN_DU_AN_CONG_TRINH.Replace("Quốc lộ ","");
if (!m_us.IsID_CONG_TRINHNull())
{
m_rdb_theo_quoc_lo.Checked = true;
m_rdb_theo_chuong_loai_khoan_muc.Checked = false;
m_rdb_theo_quoc_lo_CheckedChanged(null, null);
US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(m_us.dcID_DU_AN);
US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_cong_trinh = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(v_us_du_an.dcID_CHA);
//set cong trinh
m_ddl_cong_trinh.SelectedValue = v_us_du_an.dcID_CHA.ToString();
m_ddl_cong_trinh_SelectedIndexChanged(null, null);
m_txt_quoc_lo.Text = v_us_cong_trinh.strTEN;
m_ddl_cong_trinh.Visible = true;
m_txt_quoc_lo.Visible = false;
m_cmd_chon_quoc_lo.Visible = false;
m_cmd_them_quoc_lo.Visible = true;
//set du an
m_txt_du_an.Text = v_us_du_an.strTEN;
m_txt_du_an.Visible = false;
m_ddl_du_an.Visible = true;
m_cmd_chon_du_an.Visible = false;
m_cmd_them_du_an.Visible = true;
m_ddl_du_an.SelectedValue = v_us_du_an.dcID.ToString();
m_rdb_theo_chuong_loai_khoan_muc.Checked = false;
m_rdb_theo_quoc_lo.Checked = true;
}
else
{
m_rdb_theo_quoc_lo.Checked = false;
m_rdb_theo_chuong_loai_khoan_muc.Checked = true;
m_rdb_theo_chuong_loai_khoan_muc_CheckedChanged(null, null);
m_ddl_chuong.SelectedValue = m_us.dcID_CHUONG.ToString();
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(m_us.dcID_KHOAN);
m_ddl_loai.SelectedValue = v_us_khoan.dcID_CHA.ToString();
m_ddl_loai_SelectedIndexChanged(null, null);
m_ddl_khoan.SelectedValue = m_us.dcID_KHOAN.ToString();
m_ddl_muc.SelectedValue = m_us.dcID_MUC.ToString();
m_ddl_muc_SelectedIndexChanged(null, null);
if (!m_us.IsID_TIEU_MUCNull())
{
m_ddl_tieu_muc.SelectedValue = m_us.dcID_TIEU_MUC.ToString();
}
m_rdb_theo_chuong_loai_khoan_muc.Checked = true;
m_rdb_theo_quoc_lo.Checked = false;
}
m_ddl_loai_nhiem_vu.Focus();
m_ddl_loai_nhiem_vu.SelectedValue = m_us.dcID_LOAI_NHIEM_VU.ToString();
load_panel_loai_chi();
m_txt_noi_dung_du_toan.Text = m_us.strGHI_CHU_1;
//set quyet dinh
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH);
m_txt_so_qd.Text = v_us_quyet_dinh.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us_quyet_dinh.strNOI_DUNG;
//m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_lbl_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_hdf_id_quyet_dinh.Value = v_us_quyet_dinh.dcID.ToString();
disable_edit_quyet_dinh();
}
