/// <summary>
/// 获取实体列表
/// </summary>
/// <param name="showFields">显示字段</param>
/// <param name="reader">IDataReader</param>
/// <returns>返回TicketType实体列表</returns>
public static List<TicketTypeModel> GetList(List<TicketTypeFields> showFields, IDataReader reader)
{
List< TicketTypeModel> list = new List< TicketTypeModel>();
while ( reader.Read() )
{
TicketTypeModel tickettype= new TicketTypeModel();
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTId)) && reader["TTId"] !=DBNull.Value)
{
tickettype.TTId = Convert.ToInt32(reader["TTId"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTTypeId)) && reader["TTTypeId"] !=DBNull.Value)
{
tickettype.TTTypeId = reader["TTTypeId"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTTypeName)) && reader["TTTypeName"] !=DBNull.Value)
{
tickettype.TTTypeName = reader["TTTypeName"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTScenicId)) && reader["TTScenicId"] !=DBNull.Value)
{
tickettype.TTScenicId = reader["TTScenicId"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTStartTime)) && reader["TTStartTime"] !=DBNull.Value)
{
tickettype.TTStartTime = Convert.ToDateTime(reader["TTStartTime"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTDeadline)) && reader["TTDeadline"] !=DBNull.Value)
{
tickettype.TTDeadline = Convert.ToDateTime(reader["TTDeadline"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTRowValid)) && reader["TTRowValid"] !=DBNull.Value)
{
tickettype.TTRowValid = Convert.ToByte(reader["TTRowValid"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, TicketTypeFields.TTCreateTime)) && reader["TTCreateTime"] !=DBNull.Value)
{
tickettype.TTCreateTime = Convert.ToDateTime(reader["TTCreateTime"]);
}
list.Add(tickettype);
}
reader.Close();
return list;
}
/// <summary>
/// TicketType 添加操作
/// </summary>
/// <param name="tickettype">TicketType实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(TicketTypeModel tickettype,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:TicketType表增加操作/File:TicketTypeAccess.cs/Fun:Add*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[TicketType] (TTTypeId,TTTypeName,TTScenicId,TTStartTime,TTDeadline,TTRowValid,TTCreateTime) values(@TTTypeId,@TTTypeName,@TTScenicId,@TTStartTime,@TTDeadline,@TTRowValid,@TTCreateTime)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@TTTypeId", tickettype.TTTypeId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@TTTypeName", tickettype.TTTypeName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@TTScenicId", tickettype.TTScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@TTStartTime", tickettype.TTStartTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@TTDeadline", tickettype.TTDeadline,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@TTRowValid", tickettype.TTRowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@TTCreateTime", tickettype.TTCreateTime,SqlDbType.DateTime));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
///TicketType 添加操作
/// </summary>
/// <param name="tickettype">TicketType实体类</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(TicketTypeModel tickettype)
{
return dataAccess.Add(tickettype);
}
