public StoredProcedure getQuestion_hot(int startRowIndex,int endRowIndex,int toalCount) { StoredProcedure sp=new StoredProcedure("getQuestion_hot",this.Provider); sp.Command.AddParameter("startRowIndex",startRowIndex,DbType.Int32); sp.Command.AddParameter("endRowIndex",endRowIndex,DbType.Int32); sp.Command.AddParameter("toalCount",toalCount,DbType.Int32); return sp; }
//执行sql命令,返回数据在DataTable对象 public int run(DataTable table, string sqlText) { Debug.Assert(sproc == null); sproc = new StoredProcedure(sqlText); int flag = sproc.Run(table); this.ErrorMessage = sproc.ErrorMessage; sproc.Dispose(); sproc = null; return flag; }