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(); }