Example #1
0
        public void FillDatasetByIdQuyetDinh(DS_GD_QUYET_DINH_PHAP_NHAN op_ds, decimal ip_dc_id_phap_nhan)
        {
            CStoredProc v_sp = new CStoredProc("pr_GD_QUYET_DINH_PHAP_NHAN_Select_by_ID_QUYET_DINH");

            v_sp.addDecimalInputParam("@ID_QUYET_DINH", ip_dc_id_phap_nhan);
            v_sp.fillDataSetByCommand(this, op_ds);
        }
Example #2
0
        public US_GD_QUYET_DINH_PHAP_NHAN(decimal i_dbID)
        {
            pm_objDS        = new DS_GD_QUYET_DINH_PHAP_NHAN();
            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 delete_v_gd_quyet_dinh()
        {
            if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg))
            {
                return;
            }
            if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row))
            {
                return;
            }
            if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted)
            {
                return;
            }
            US_V_GD_QUYET_DINH         v_us       = new US_V_GD_QUYET_DINH();
            US_GD_QUYET_DINH_PHAP_NHAN v_us_qd_pn = new US_GD_QUYET_DINH_PHAP_NHAN();
            DS_GD_QUYET_DINH_PHAP_NHAN v_ds_qd_pn = new DS_GD_QUYET_DINH_PHAP_NHAN();

            grid2us_object(v_us, m_fg.Row);
            try
            {
                v_us.BeginTransaction();
                // Xoá Quyết định - Pháp nhân
                v_us_qd_pn.FillDatasetByIdQuyetDinh(v_ds_qd_pn, v_us.dcID);
                v_us_qd_pn.DeleteByID(v_us.dcID);

                // Xoá Pháp nhân
                v_us.delete_by_id(v_us.dcID);
                v_us.CommitTransaction();
                m_fg.Rows.Remove(m_fg.Row);
            }
            catch (Exception v_e)
            {
                v_us.Rollback();
                CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
                                                                              new CDBClientDBExceptionInterpret());
                v_objErrHandler.showErrorMessage();
            }
        }
Example #4
0
 public US_GD_QUYET_DINH_PHAP_NHAN()
 {
     pm_objDS        = new DS_GD_QUYET_DINH_PHAP_NHAN();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }