예제 #1
0
        //returns the all  "rows" found in database
        public Dictionary <string, MetaAdmRow> GetMetaAdmAllRows()
        {
            string sqlString = GetMetaAdm_SQLString_NoWhere();
            Dictionary <string, MetaAdmRow> myOut = new Dictionary <string, MetaAdmRow>();

            DataSet           ds     = mSqlCommand.ExecuteSelect(sqlString, null);
            DataRowCollection myRows = ds.Tables[0].Rows;

            if (myRows.Count < 1)
            {
                throw new PCAxis.Sql.Exceptions.DbException(44, "MetaAdm", "METAADM");
            }

            foreach (DataRow sqlRow in myRows)
            {
                MetaAdmRow outRow = new MetaAdmRow(sqlRow, DB);
                myOut.Add(outRow.Property, outRow);
            }
            return(myOut);
        }
예제 #2
0
        //returns the single "row" found when all PKs are spesified
        public MetaAdmRow GetMetaAdmRow(string aProperty)
        {
            //SqlDbConfig dbconf = DB;
            string sqlString = GetMetaAdm_SQLString_NoWhere();

            sqlString += " WHERE " + DB.MetaAdm.PropertyCol.IsUppered(mSqlCommand.GetParameterRef("aProperty"));

            // creating the parameters
            System.Data.Common.DbParameter[] parameters = new System.Data.Common.DbParameter[1];
            parameters[0] = mSqlCommand.GetStringParameter("aProperty", aProperty);

            DataSet           ds     = mSqlCommand.ExecuteSelect(sqlString, parameters);
            DataRowCollection myRows = ds.Tables[0].Rows;

            if (myRows.Count != 1)
            {
                throw new PCAxis.Sql.Exceptions.DbException(36, " Property = " + aProperty);
            }

            MetaAdmRow myOut = new MetaAdmRow(myRows[0], DB);

            return(myOut);
        }