private void load_data_2_cbo_noi_dung_tt_by_hd()
{
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_gd_hop_dong_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_gd_hop_dong_noi_dung_tt = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
// Lấy tất cả các nội dung thanh toán từ phụ lục hợp đồng
v_us_gd_hop_dong_noi_dung_tt.FillDataset(v_ds_gd_hop_dong_noi_dung_tt, " WHERE ID_HOP_DONG_KHUNG = " + CIPConvert.ToDecimal(m_cbo_so_hop_dong.SelectedValue));
m_cbo_noi_dung_thanh_toan.DataTextField = V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN;
m_cbo_noi_dung_thanh_toan.DataValueField = V_GD_HOP_DONG_NOI_DUNG_TT.ID;
m_cbo_noi_dung_thanh_toan.DataSource = v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT;
m_cbo_noi_dung_thanh_toan.DataBind();
if (m_cbo_noi_dung_thanh_toan.Items.Count > 0)
{
if (m_cbo_noi_dung_thanh_toan.SelectedIndex != 0)
{
decimal v_dc_id_noi_dung_tt = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_dm_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT(v_dc_id_noi_dung_tt);
m_txt_so_luong.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcSO_LUONG_HE_SO, "#,#");
m_txt_don_gia.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcDON_GIA_HD);
m_lbl_don_vi.Text = v_us_dm_noi_dung_tt.strDON_VI_TINH;
m_lbl_mess.Text = "";
}
}
}
private void load_data_2_cbo_noi_dung_tt()
{
m_lbl_mess.Text = "";
m_cbo_noi_dung_thanh_toan.Items.Clear();
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_gd_hop_dong_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_gd_hop_dong_noi_dung_tt = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
// Lấy tất cả các nội dung thanh toán từ phụ lục hợp đồng
v_us_gd_hop_dong_noi_dung_tt.FillDataset(v_ds_gd_hop_dong_noi_dung_tt, " WHERE ID_HOP_DONG_KHUNG = " + CIPConvert.ToDecimal(m_cbo_so_hop_dong.SelectedValue));
m_cbo_noi_dung_thanh_toan.Items.Add(new ListItem("------ Chọn công việc ------", "0"));
for (int v_i = 0; v_i < v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows.Count; v_i++)
{
m_cbo_noi_dung_thanh_toan.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN]), CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.ID])));
}
if (m_cbo_noi_dung_thanh_toan.Items.Count > 0)
{
if (!m_cbo_noi_dung_thanh_toan.SelectedValue.Equals("0"))
{
decimal v_dc_id_noi_dung_tt = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_dm_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT(v_dc_id_noi_dung_tt);
m_lbl_don_vi.Text = v_us_dm_noi_dung_tt.strDON_VI_TINH;
}
}
else
{
m_lbl_mess.Text = "Hợp đồng này không có phụ lục hợp đồng!";
}
}
private void load_data_2_cbo_noi_dung_tt()
{
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_gd_hop_dong_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_gd_hop_dong_noi_dung_tt = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
// Lấy tất cả các nội dung thanh toán từ phụ lục hợp đồng
v_us_gd_hop_dong_noi_dung_tt.FillDataset(v_ds_gd_hop_dong_noi_dung_tt, " WHERE ID_HOP_DONG_KHUNG = " + CIPConvert.ToDecimal(m_cbo_so_hop_dong.SelectedValue));
m_cbo_noi_dung_thanh_toan.DataTextField = V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN;
m_cbo_noi_dung_thanh_toan.DataValueField = V_GD_HOP_DONG_NOI_DUNG_TT.ID;
m_cbo_noi_dung_thanh_toan.DataSource = v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT;
m_cbo_noi_dung_thanh_toan.DataBind();
}
public US_V_GD_HOP_DONG_NOI_DUNG_TT(decimal i_dbID)
{
pm_objDS = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
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_cbo_noi_dung_tt()
{
m_cbo_noi_dung_thanh_toan.Items.Clear();
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_gd_hop_dong_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_gd_hop_dong_noi_dung_tt = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
// Lấy tất cả các nội dung thanh toán từ phụ lục hợp đồng
v_us_gd_hop_dong_noi_dung_tt.load_noi_dung_at_phu_luc_hop_dong(CIPConvert.ToDecimal(m_cbo_so_hop_dong_loc.SelectedValue), v_ds_gd_hop_dong_noi_dung_tt);
m_cbo_noi_dung_thanh_toan_loc.DataTextField = V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN;
m_cbo_noi_dung_thanh_toan_loc.DataValueField = V_GD_HOP_DONG_NOI_DUNG_TT.ID;
m_cbo_noi_dung_thanh_toan_loc.Items.Add(new ListItem("---- Hãy chọn công việc -----", "0"));
for (int v_i = 0; v_i < v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows.Count; v_i++)
{
m_cbo_noi_dung_thanh_toan_loc.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN]), CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.ID])));
}
}
// Cái này chỉ cho load các nội dung phụ lục có trong hợp đồng
private void load_2_cbo_noi_dung_tt(decimal ip_dc_id_hd)
{
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_phu_luc = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_phu_luc = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
try
{
v_us_phu_luc.FillDataset(v_ds_phu_luc, " WHERE ID_HOP_DONG_KHUNG = " + ip_dc_id_hd);
m_cbo_noi_dung_tt.DataSource = v_ds_phu_luc.V_GD_HOP_DONG_NOI_DUNG_TT;
m_cbo_noi_dung_tt.DataValueField = V_GD_HOP_DONG_NOI_DUNG_TT.ID;
m_cbo_noi_dung_tt.DataTextField = V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN;
m_cbo_noi_dung_tt.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_2_cbo_noi_dung_tt()
{
m_cbo_noi_dung_thanh_toan.Items.Clear();
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_gd_hop_dong_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT();
DS_V_GD_HOP_DONG_NOI_DUNG_TT v_ds_gd_hop_dong_noi_dung_tt = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
// Lấy tất cả các nội dung thanh toán từ phụ lục hợp đồng
v_us_gd_hop_dong_noi_dung_tt.load_noi_dung_at_phu_luc_hop_dong(CIPConvert.ToDecimal(m_cbo_so_hop_dong_loc.SelectedValue), v_ds_gd_hop_dong_noi_dung_tt);
m_cbo_noi_dung_thanh_toan.DataTextField = V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN;
m_cbo_noi_dung_thanh_toan.DataValueField = V_GD_HOP_DONG_NOI_DUNG_TT.ID;
m_cbo_noi_dung_thanh_toan.Items.Add(new ListItem("---- Hãy chọn công việc -----", "0"));
for (int v_i = 0; v_i < v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows.Count; v_i++)
{
m_cbo_noi_dung_thanh_toan.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.NOI_DUNG_THANH_TOAN]), CIPConvert.ToStr(v_ds_gd_hop_dong_noi_dung_tt.V_GD_HOP_DONG_NOI_DUNG_TT.Rows[v_i][V_GD_HOP_DONG_NOI_DUNG_TT.ID])));
}
if (m_cbo_noi_dung_thanh_toan.Items.Count > 0)
{
if (m_cbo_noi_dung_thanh_toan.SelectedIndex != 0)
{
decimal v_dc_id_noi_dung_tt = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
US_V_GD_HOP_DONG_NOI_DUNG_TT v_us_dm_noi_dung_tt = new US_V_GD_HOP_DONG_NOI_DUNG_TT(v_dc_id_noi_dung_tt);
m_txt_so_luong.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcSO_LUONG_HE_SO, "#,#");
m_lbl_don_gia.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcDON_GIA_HD);
m_lbl_don_vi.Text = v_us_dm_noi_dung_tt.strDON_VI_TINH;
m_lbl_mess.Text = "";
m_cmd_tao_moi.Enabled = true;
}
}
else
{
m_lbl_mess.Text = "Hợp đồng này không có phụ lục hợp đồng!";
m_cmd_tao_moi.Enabled = false;
}
}
public void load_noi_dung_at_phu_luc_hop_dong(decimal ip_dc_id_hop_dong_khung, DS_V_GD_HOP_DONG_NOI_DUNG_TT op_ds_v_gd_hd_noi_dung_tt)
{
CStoredProc v_cstore = new CStoredProc("pr_GD_HOP_DONG_NOI_DUNG_TT_Load_Phu_Luc_HD");
v_cstore.addDecimalInputParam("@ID_HOP_DONG_KHUNG", ip_dc_id_hop_dong_khung);
v_cstore.fillDataSetByCommand(this, op_ds_v_gd_hd_noi_dung_tt);
}
public US_V_GD_HOP_DONG_NOI_DUNG_TT()
{
pm_objDS = new DS_V_GD_HOP_DONG_NOI_DUNG_TT();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
