/// <summary> ///OrderTable字段值 /// </summary> /// <param name="field">OrderTable字段</param> /// <param name="fieldValue">字段值</param> public OrderTableWhereFields(OrderTableFields field,object fieldValue) { this.field = field; this.fieldValue = fieldValue; this.queryOperator = QueryOperator.And; this.queryCondition = QueryCondition.Equal; }
/// <summary> ///OrderTable字段值 /// </summary> /// <param name="field">OrderTable字段</param> /// <param name="fieldValue">字段值</param> /// <param name="queryOperator">条件操作类型</param> /// <param name="queryCondition">条件关系</param> public OrderTableWhereFields(OrderTableFields field,object fieldValue, QueryCondition queryCondition,QueryOperator queryOperator) { this.field = field; this.fieldValue = fieldValue; this.queryOperator = queryOperator; this.queryCondition = queryCondition; }
/// <summary> ///OrderTable排序字段 /// </summary> /// <param name="field">OrderTable字段</param> public OrderTableOrderFields(OrderTableFields field) { this.field = field; this.order = OrderType.Asc; }
/// <summary> ///OrderTable排序字段 /// </summary> /// <param name="field">OrderTable字段</param> /// <param name="order">排序类型</param> public OrderTableOrderFields(OrderTableFields field, OrderType order) { this.field = field; this.order = order; }
/// <summary> ///OrderTable字段值 /// </summary> /// <param name="field">OrderTable字段</param> /// <param name="fieldValue">字段值</param> public OrderTableFieldValuePair(OrderTableFields field,object fieldValue) { this.field = field; this.fieldValue = fieldValue; }
/// <summary> /// 获取对象 /// </summary> /// <param name="showField">字段</param> /// <param name="whereFields">条件字段</param> /// <returns>返回OrderTable表格</returns> public object GetObject(OrderTableFields showField, List<OrderTableWhereFields> whereFields) { return GetObject(DataBaseType.Read,showField,whereFields); }
/// <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); }
/// <summary> /// 设置SqlParameterWrapperCollection /// </summary> /// <param name="collection">SqlParameterWrapperCollection</param> /// <param name="field">字段</param> /// <param name="fieldVariable">字段变量</param> /// <param name="fieldValue">值</param> public static void SetSqlParameterWrapperCollection(SqlParameterWrapperCollection collection, OrderTableFields field, string fieldVariable, object fieldValue) { switch ( field ) { case OrderTableFields.OTId: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int)); break; case OrderTableFields.OTOrderSerialNo: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTOrderComfirmNo: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTOrderCreateTime: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime)); break; case OrderTableFields.OTTravelTime: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime)); break; case OrderTableFields.OTOrderPhone: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTOrderName: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTTicketPhone: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTTicketName: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTTicketNumber: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int)); break; case OrderTableFields.OTOrderState: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt)); break; case OrderTableFields.OTPayWay: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt)); break; case OrderTableFields.OTTicketPrice: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Decimal)); break; case OrderTableFields.OTIdentityCard: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTBrokerage: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Decimal)); break; case OrderTableFields.OTTicketTypeId: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTRowValid: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt)); break; case OrderTableFields.OTRemark: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTScenicId: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar)); break; case OrderTableFields.OTHaveTicketNumber: collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int)); break; } }
/// <summary> /// 判断字段是否存在 /// </summary> /// <param name="list">列表</param> /// <param name="field">字段</param> /// <returns>返回true存在,否则不存在</returns> public static bool IsExistField(List<OrderTableFields> list, OrderTableFields field) { foreach ( OrderTableFields f in list ) { if ( f == field ) { return true; } } return false; }