可以返回Null而不发出异常的DataReader
Inheritance: IDisposable
Example #1
0
        //查询
        private DbReader query(Command cmd, DbTran transaction)
        {
            if (false == buildCMD(cmd, (transaction == null ? null : transaction.connection), false))
            {
                return(null);
            }

            //3.执行
            DbReader rst = new DbReader(stmt.ExecuteReader()); //stmt.executeQuery();

            //*.监听
            WeedConfig.logExecuteAft(cmd);

            return(rst);
        }
Example #2
0
        public List <T> getList <T>(T model, Command cmd, DbTran transaction) where T : IBinder
        {
            List <T> list = new List <T>();

            try {
                reader = query(cmd, transaction);
                while (reader.Read())
                {
                    T item = (T)model.clone();

                    if (WeedConfig.isDebug)
                    {
                        if (item is T)
                        {
                            throw new WeedException(model.GetType() + " clone error(" + item.GetType() + ")");
                        }
                    }

                    item.bind((key) => {
                        try {
                            return(new Variate(key, reader[key]));
                        } catch (Exception ex) {
                            WeedConfig.logException(cmd, ex);
                            return(new Variate(key, null));
                        }
                    });

                    list.Add(item);
                }

                if (list.Count > 0)
                {
                    return(list);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception ex) {
                WeedConfig.logException(cmd, ex);
                throw ex;
            }
            finally {
                tryClose();
            }
        }
Example #3
0
 public Variate getVariate(Command cmd, DbTran transaction)
 {
     try {
         reader = query(cmd, transaction);
         if (reader.Read())
         {
             return(new Variate(null, reader[0])); //也可能从1开始
         }
         else
         {
             return(null);//new Variate(null, null);
         }
     }
     catch (Exception ex) {
         WeedConfig.logException(cmd, ex);
         throw ex;
     }
     finally {
         tryClose();
     }
 }
Example #4
0
        public DataList getTable(Command cmd, DbTran transaction)
        {
            DataList table = new DataList();

            try {
                reader = query(cmd, transaction);

                while (reader.Read())
                {
                    DataItem row = new DataItem();
                    int      len = reader.FieldCount;

                    for (int i = 0; i < len; i++)
                    {
                        row.set(reader.GetName(i), reader[i]);
                    }

                    table.addRow(row);
                }

                if (table.getRowCount() > 0)
                {
                    return(table);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception ex) {
                WeedConfig.logException(cmd, ex);
                throw ex;
            }
            finally {
                tryClose();
            }
        }