public void testOject()
{
Wilson.ORMapper.ObjectQuery oq = new Wilson.ORMapper.ObjectQuery(typeof(C2.CtmJob), "", "");
Wilson.ORMapper.ObjectSet os = C2.Manager.ORManager.GetObjectSet(oq);
string context = Common.ObjectToJson(os);
Common.WriteJsonP(true, context);
}
internal ObjectReader(Internals.Context context, ObjectQuery objectQuery, bool firstLevel) {
this.context = context;
this.firstLevel = firstLevel;
this.objectType = objectQuery.ObjectType;
this.pageIndex = objectQuery.PageIndex;
this.hasEvents = context.Mappings[this.objectType.ToString()].HasEvents;
Internals.Commands commands = context.Mappings.Commands(this.objectType.ToString());
if (objectQuery.PageSize > 0 && !objectQuery.SkipCounts) {
string selectCount = commands.RecordCount(objectQuery.WhereClause);
this.totalCount = int.Parse(context.Connection.GetScalarValue(this.objectType, CommandInfo.GetCount, selectCount).ToString());
double pages = (double) (1 + (this.totalCount - 1) / objectQuery.PageSize);
this.pageCount = int.Parse(Math.Floor(pages).ToString());
}
this.data = context.Connection.GetDataReader(this.objectType, CommandInfo.Select, commands.Select(objectQuery));
this.firstRead = true;
if (this.data != null) this.hasObjects = this.data.Read();
if (!this.hasObjects) this.Close();
}
/// <summary>
/// Get a Raw DataSet with custom Fields
/// </summary>
/// <param name="dataSet">
/// The typed dataset to populate with the resultset
/// </param>
/// <param name="objectQuery" type="Wilson.ORMapper.ObjectQuery">
/// The ObjectQuery instance used to generate the SQL where clause
/// </param>
/// <param name="selectFields" type="string[]">
/// An array of fields to select
/// </param>
/// <returns>
/// A System.Data.DataSet object instance
/// </returns>
public DataSet GetDataSet(DataSet dataSet, ObjectQuery objectQuery, string[] selectFields)
{
string sortClause = (objectQuery.SortClause.Length > 0 ? objectQuery.SortClause
: this.context.Mappings[objectQuery.ObjectType.ToString()].SortOrder);
ObjectQuery query = new ObjectQuery(objectQuery.ObjectType, objectQuery.WhereClause,
sortClause, objectQuery.PageSize, objectQuery.PageIndex);
Commands commands = this.context.Mappings.Commands(query.ObjectType.ToString());
return this.context.Connection.TransactionDataSet(this.id, objectQuery.ObjectType, CommandInfo.DataSet, this.transaction, dataSet, commands.Select(query, selectFields));
}
/// <summary>
/// Get a Raw DataSet with custom Fields
/// </summary>
/// <param name="dataSet">
/// The typed dataset to populate with the resultset
/// </param>
/// <param name="objectType" type="System.Type">
/// The type of object to retrieve
/// </param>
/// <param name="whereClause" type="string">
/// The SQL where clause to use when retrieving data
/// </param>
/// <param name="selectFields" type="string[]">
/// An array of fields to select
/// </param>
/// <returns>
/// A System.Data.DataSet object instance
/// </returns>
public DataSet GetDataSet(DataSet dataSet, Type objectType, string whereClause, string[] selectFields)
{
ObjectQuery query = new ObjectQuery(objectType, whereClause, String.Empty);
return this.GetDataSet(dataSet, query, selectFields);
}
/// <summary>
/// Get a Raw DataSet with custom Fields
/// </summary>
/// <param name="objectQuery" type="Wilson.ORMapper.ObjectQuery">
/// The ObjectQuery instance used to generate the SQL where clause
/// </param>
/// <param name="selectFields" type="string[]">
/// An array of fields to select
/// </param>
/// <returns>
/// A System.Data.DataSet object instance
/// </returns>
public DataSet GetDataSet(ObjectQuery objectQuery, string[] selectFields)
{
string sortClause = (objectQuery.SortClause.Length > 0 ? objectQuery.SortClause
: this.context.Mappings[objectQuery.ObjectType.ToString()].SortOrder);
ObjectQuery query = new ObjectQuery(objectQuery.ObjectType, objectQuery.WhereClause,
sortClause, objectQuery.PageSize, objectQuery.PageIndex);
return this.GetDataSet(null, query, selectFields);
}
/// <summary>
/// Get a Raw DataSet where may be Needed
/// </summary>
/// <param name="objectType" type="System.Type">
/// The type of object to retrieve
/// </param>
/// <param name="whereClause" type="string">
/// The SQL where clause to use when retrieving data
/// </param>
/// <returns>
/// A System.Data.DataSet object instance
/// </returns>
public DataSet GetDataSet(Type objectType, string whereClause)
{
ObjectQuery query = new ObjectQuery(objectType, whereClause, String.Empty);
return this.GetDataSet(query);
}
internal ObjectList(Internals.Context context, ObjectQuery objectQuery)
{
this.context = context;
this.type = objectQuery.ObjectType;
this.query = objectQuery;
}