public US_V_HT_CONTROL_IN_FORM(decimal i_dbID) { pm_objDS = new DS_V_HT_CONTROL_IN_FORM(); 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 void FillDatasetByIdChucNangAndFormName(DS_V_HT_CONTROL_IN_FORM op_ds, decimal ip_dc_id, string ip_form_name) { CStoredProc v_sp = new CStoredProc("pr_V_HT_CONTROL_IN_FORM_select_by_ID_CN"); v_sp.addDecimalInputParam("@ID_CHUC_NANG", ip_dc_id); v_sp.addNVarcharInputParam("@FORM_NAME",ip_form_name); v_sp.fillDataSetByCommand(this, op_ds); }
public US_V_HT_CONTROL_IN_FORM() { pm_objDS = new DS_V_HT_CONTROL_IN_FORM(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void m_cmd_save_Click(object sender, EventArgs e) { US_V_HT_CONTROL_IN_FORM v_us = new US_V_HT_CONTROL_IN_FORM(); DS_V_HT_CONTROL_IN_FORM v_ds = new DS_V_HT_CONTROL_IN_FORM(); v_us.FillDatasetByIdChucNangAndFormName(v_ds,CIPConvert.ToDecimal(m_cbo_chuc_nang.SelectedValue),m_txt_form.Text); US_HT_PHAN_QUYEN_DETAIL v_us_ht_pq_detail; for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++) { v_us_ht_pq_detail = new US_HT_PHAN_QUYEN_DETAIL(); DataRow v_dr = v_ds.Tables[0].Rows[i]; v_us_ht_pq_detail.dcID_PHAN_QUYEN_HT = CIPConvert.ToDecimal(m_cbo_nhom_quyen.SelectedValue); v_us_ht_pq_detail.strCONTROL_NAME = v_dr[V_HT_CONTROL_IN_FORM.CONTROL_NAME].ToString(); v_us_ht_pq_detail.strCONTROL_TYPE = v_dr[V_HT_CONTROL_IN_FORM.CONTROL_TYPE].ToString(); v_us_ht_pq_detail.strENABLED_YN = "Y"; v_us_ht_pq_detail.strFORM_NAME = v_dr[V_HT_CONTROL_IN_FORM.FORM_NAME].ToString(); v_us_ht_pq_detail.strVISIBLE_YN = "Y"; v_us_ht_pq_detail.Insert(); } BaseMessages.MsgBox_Infor("Dữ liệu đã được cập nhật"); // this.Close(); }