/// <summary>
/// 获取对象
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showField">字段</param>
/// <param name="whereFields">条件字段</param>
/// <returns>返回OrderTable表格</returns>
public object GetObject(DataBaseType dbType, OrderTableFields showField, List<OrderTableWhereFields> whereFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:OrderTable表查询操作/File:OrderTableAccess.cs/Fun:GetTopOrderTableTable*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("select "+ showField.ToString()+" from ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[OrderTable] with(nolock)");
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
sql.Append(" where ");
sql.Append(GetSqlString(null, whereFields));
}
GetSqlParameterWrapperCollection(collection, null, whereFields);
return SqlHelper.ExecuteScalar(DatabaseManager.GetDataBase(DatabaseManager.Db_JQEBookingConfig,dbType),sql.ToString(),collection);
}
