public DataTable GetOrderTableExtend(DataBaseType dbType, List<OrderTableFields> orderTableShowFields, List<TicketTypeFields> ticketTypeShowFields, List<OrderTableWhereFields> whereFields, List<OrderTableOrderFields> orderFields, int pageSize, int pageIndex)
{
StringBuilder sql = new StringBuilder();
string orderTableShowFieldsSql = GetOrderShowFields("OrderTable", orderTableShowFields);
string ticketTypeShowFieldsSql = GetTicketShowFields("TicketType", ticketTypeShowFields);
int start = (pageIndex - 1) * pageSize + 1;
int end = start + pageSize - 1;
sql.Append("SELECT * FROM (SELECT ROW_NUMBER() OVER (");
if (string.IsNullOrEmpty(GetOrderFields(orderFields)))
{
sql.Append(" order by ");
sql.AppendFormat("[{0}].[dbo].[OrderTable].OTId", DatabaseManager.Db_JQEBookingDataBase);
}
else
{
sql.Append(GetOrderFields(orderFields));
}
sql.Append(") AS rowNumber,");
sql.Append(orderTableShowFieldsSql);
sql.Append(",");
sql.Append(ticketTypeShowFieldsSql);
sql.Append(" from ");
sql.AppendFormat("[{0}].[dbo].[OrderTable]", DatabaseManager.Db_JQEBookingDataBase);
sql.Append(" with(nolock) ");
sql.Append("left join ");
sql.AppendFormat("[{0}].[dbo].[TicketType]", DatabaseManager.Db_JQEBookingDataBase);
sql.Append(" on ");
sql.AppendFormat("[{0}].[dbo].[OrderTable].OTTicketTypeId=[{0}].[dbo].[TicketType].TTTypeId", DatabaseManager.Db_JQEBookingDataBase);
sql.Append(" where ");
sql.Append(GetSqlString(null, whereFields));
sql.Append(") AS sp WHERE rowNumber BETWEEN ");
sql.Append(start.ToString());
sql.Append(" AND ");
sql.Append(end.ToString());
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if (whereFields != null && whereFields.Count > 0)
{
GetSqlParameterWrapperCollection(collection, null, whereFields);
}
DataTable datatable = SqlHelper.ExecuteDataTable(DatabaseManager.GetDataBase(DatabaseManager.Db_JQEBookingConfig, dbType), sql.ToString(), collection);
return datatable;
}
/// <summary>
/// Comments 自定义查询操作
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showFields">显示字段</param>
/// <param name="whereFields">条件字段</param>
/// <param name="orderFields">排序字段</param>
/// <returns>返回Comments实体列表</returns>
public static List<CommentsModel> GetCommentsListBySql(string sql, List<CommentsWhereFields> whereFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表查询操作/File:CommentsAccess.cs/Fun:GetCommentsList*/";
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append(sqlDescription);
sqlStr.Append(sql);
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
sqlStr.Append(" where ");
sqlStr.Append(GetSqlString(null, whereFields));
}
GetSqlParameterWrapperCollection(collection, null, whereFields);
IDataReader reader = SqlHelper.ExecuteReader(DatabaseManager.GetDataBase(DatabaseManager.Db_JQEBookingConfig,DataBaseType.Read),sqlStr.ToString(), collection);
return GetList(null,reader);
}
/// <summary>
/// 获取某个景区的评论数
/// </summary>
/// <param name="scenicId"></param>
/// <returns></returns>
public int GetCommentsCount(List<CommentsWhereFields> whereFields, string scenicId)
{
StringBuilder sqlsb = new StringBuilder();
sqlsb.Append("select count(Comments.COrderSerialNo) from ");
sqlsb.AppendFormat("[{0}].[dbo].[Comments]", DatabaseManager.Db_JQEBookingDataBase);
sqlsb.Append(" with(nolock) left join ");
sqlsb.AppendFormat("[{0}].[dbo].[OrderTable]", DatabaseManager.Db_JQEBookingDataBase);
sqlsb.Append(" on Comments.COrderSerialNo=OrderTable.OTOrderSerialNo");
sqlsb.AppendFormat(" where OrderTable.OTScenicId={0}", scenicId);
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if (whereFields != null && whereFields.Count > 0)
{
GetSqlParameterWrapperCollection(collection, null, whereFields);
sqlsb.Append(" and ");
}
sqlsb.Append(GetSqlString(null, whereFields));
sqlsb.Append(" --Flat:Asp.net小组/Author:谢超/For:获取订单统计列表/File :CommentsAccess.Extensibility.cs/Fun:GetCommentsExtend");
return SqlHelper.ExecuteScalarByInt(sqlsb.ToString(), collection);
}
/// <summary>
/// 获取所有评论列表
/// </summary>
/// <returns></returns>
public DataTable GetCommentsExtend(List<CommentsWhereFields> whereFields, string scenicId, int pageSize, int pageIndex)
{
int start = (pageIndex - 1) * pageSize + 1;
int end = start + pageSize - 1;
StringBuilder sqlsb = new StringBuilder();
sqlsb.AppendFormat(@"SELECT * FROM
(SELECT ROW_NUMBER() OVER
( order by [{0}].[dbo].[OrderTable].OTId)
AS rowNumber
,Comments.COrderSerialNo
,Comments.CCommentsType
,Comments.CCommentsContent
,Comments.CCommentsTime
,Comments.CCommentsReply
,Comments.CCommentsState
,OrderTable.OTOrderName from ", DatabaseManager.Db_JQEBookingDataBase);
sqlsb.AppendFormat("[{0}].[dbo].[Comments]", DatabaseManager.Db_JQEBookingDataBase);
sqlsb.Append(" with(nolock) left join ");
sqlsb.AppendFormat("[{0}].[dbo].[OrderTable]", DatabaseManager.Db_JQEBookingDataBase);
sqlsb.Append(" on Comments.COrderSerialNo=OrderTable.OTOrderSerialNo");
sqlsb.AppendFormat(" where OrderTable.OTScenicId={0} ", scenicId);
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if (whereFields != null && whereFields.Count > 0)
{
GetSqlParameterWrapperCollection(collection, null, whereFields);
sqlsb.Append(" and ");
}
sqlsb.Append(GetSqlString(null, whereFields));
sqlsb.Append(") AS sp WHERE rowNumber BETWEEN ");
sqlsb.Append(start.ToString());
sqlsb.Append(" AND ");
sqlsb.Append(end.ToString());
sqlsb.Append(" --Flat:Asp.net小组/Author:谢超/For:获取订单统计列表/File :CommentsAccess.Extensibility.cs/Fun:GetCommentsExtend");
DataTable datatable = SqlHelper.ExecuteDataTable(sqlsb.ToString(), collection);
return datatable;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showFields">显示字段</param>
/// <param name="whereFields">条件字段</param>
/// <param name="orderFields">排序字段</param>
/// <param name="pageSize">页面数量</param>
/// <param name="pageIndex">页面索引</param>
/// <returns>返回Admin实体列表</returns>
public List<AdminModel> GetAdminList(DataBaseType dbType,List<AdminFields> showFields, List<AdminWhereFields> whereFields, List<AdminOrderFields> orderFields, int pageSize, int pageIndex)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表分页查询操作/File:AdminAccess.cs/Fun:GetAdminList*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append(PageSplitQuery.GetPageSplitSql2005("Admin", "AId", GetShowFields(showFields), string.Empty, GetSqlString(null, whereFields), GetOrderFields(orderFields), pageSize, pageIndex));
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
GetSqlParameterWrapperCollection(collection, null, whereFields);
}
IDataReader reader = SqlHelper.ExecuteReader(DatabaseManager.GetDataBase(DatabaseManager.Db_JQEBookingConfig,dbType),sql.ToString(), collection);
return GetList(showFields,reader);
}
/// <summary>
/// 自定义添加操作
/// </summary>
/// <param name="list">字段值对</param>
/// <returns>返回主键值</returns>
public int AddByIdentity(List<AdminFieldValuePair> list)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表增加操作/File:AdminAccess.cs/Fun:AddByIdentity*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append(GetInsertSql(list));
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
GetSqlParameterWrapperCollection(collection, list, null);
return SqlHelper.ExecuteIdentity(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),collection);
}
/// <summary>
/// OrderTable 添加操作返回主键的编号
/// </summary>
/// <param name="ordertable">OrderTable实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public int AddByIdentity(OrderTableModel ordertable,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:OrderTable表增加操作/File:OrderTableAccess.cs/Fun:AddByIdentity*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[OrderTable] (OTOrderSerialNo,OTOrderComfirmNo,OTOrderCreateTime,OTTravelTime,OTOrderPhone,OTOrderName,OTTicketPhone,OTTicketName,OTTicketNumber,OTOrderState,OTPayWay,OTTicketPrice,OTIdentityCard,OTBrokerage,OTTicketTypeId,OTRowValid,OTRemark,OTScenicId,OTHaveTicketNumber) values(@OTOrderSerialNo,@OTOrderComfirmNo,@OTOrderCreateTime,@OTTravelTime,@OTOrderPhone,@OTOrderName,@OTTicketPhone,@OTTicketName,@OTTicketNumber,@OTOrderState,@OTPayWay,@OTTicketPrice,@OTIdentityCard,@OTBrokerage,@OTTicketTypeId,@OTRowValid,@OTRemark,@OTScenicId,@OTHaveTicketNumber)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@OTOrderSerialNo", ordertable.OTOrderSerialNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTOrderComfirmNo", ordertable.OTOrderComfirmNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTOrderCreateTime", ordertable.OTOrderCreateTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@OTTravelTime", ordertable.OTTravelTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@OTOrderPhone", ordertable.OTOrderPhone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTOrderName", ordertable.OTOrderName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketPhone", ordertable.OTTicketPhone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketName", ordertable.OTTicketName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketNumber", ordertable.OTTicketNumber,SqlDbType.Int));
Collection.Add(new SqlParameterWrapper("@OTOrderState", ordertable.OTOrderState,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTPayWay", ordertable.OTPayWay,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTTicketPrice", ordertable.OTTicketPrice,SqlDbType.Decimal));
Collection.Add(new SqlParameterWrapper("@OTIdentityCard", ordertable.OTIdentityCard,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTBrokerage", ordertable.OTBrokerage,SqlDbType.Decimal));
Collection.Add(new SqlParameterWrapper("@OTTicketTypeId", ordertable.OTTicketTypeId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTRowValid", ordertable.OTRowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTRemark", ordertable.OTRemark,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTScenicId", ordertable.OTScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTHaveTicketNumber", ordertable.OTHaveTicketNumber,SqlDbType.Int));
return SqlHelper.ExecuteIdentity(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction);
}
/// <summary>
/// 自定义删除
/// </summary>
/// <param name="where">删除条件</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Delete(List<CommentsWhereFields> where,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表删除操作/File:CommentsAccess.cs/Fun:Delete*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("delete ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Comments] where ");
sql.Append(GetSqlString(null, where));
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
GetSqlParameterWrapperCollection(collection, null, where);
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig), sql.ToString(), collection,transaction) > 0;
}
/// <summary>
/// Comments 添加操作
/// </summary>
/// <param name="comments">Comments实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(CommentsModel comments,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表增加操作/File:CommentsAccess.cs/Fun:Add*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Comments] (COrderSerialNo,CCommentsType,CCommentsContent,CCommentsTime,CCommentsReply,CReplyTime,CCommentsState,CRowValid) values(@COrderSerialNo,@CCommentsType,@CCommentsContent,@CCommentsTime,@CCommentsReply,@CReplyTime,@CCommentsState,@CRowValid)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@COrderSerialNo", comments.COrderSerialNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@CCommentsType", comments.CCommentsType,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@CCommentsContent", comments.CCommentsContent,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@CCommentsTime", comments.CCommentsTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@CCommentsReply", comments.CCommentsReply,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@CReplyTime", comments.CReplyTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@CCommentsState", comments.CCommentsState,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@CRowValid", comments.CRowValid,SqlDbType.TinyInt));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
/// 获取SqlParameterWrapperCollection
/// </summary>
/// <param name="collection">SqlParameterWrapperCollection</param>
/// <param name="updates">更新列表</param>
/// <param name="where">条件列表</param>
public static void GetSqlParameterWrapperCollection(SqlParameterWrapperCollection collection, List<CommentsFieldValuePair> updates, List<CommentsWhereFields> where)
{
if ( updates != null && updates.Count > 0 )
{
foreach ( CommentsFieldValuePair values in updates )
{
SetSqlParameterWrapperCollection(collection, values.Field, values.Field.ToString(), values.FieldValue);
}
}
if ( where != null && where.Count > 0 )
{
for( int i=0; i< where.Count; i++)
{
if (where[i].Condition == QueryCondition.InOpertion)
{
continue;
}
string suffix = string.Empty;
if ( updates != null && IsExistField(updates, where[i].Field) )
{
suffix = "1";
}
suffix = IsWhereField(where, i);
SetSqlParameterWrapperCollection(collection, where[i].Field, where[i].Field.ToString() + suffix, where[i].FieldValue);
}
}
}
/// <summary>
/// TicketType 自定义查询操作
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showFields">显示字段</param>
/// <param name="whereFields">条件字段</param>
/// <param name="orderFields">排序字段</param>
/// <returns>返回TicketType表格</returns>
public DataTable GetTicketTypeTable(DataBaseType dbType,List<TicketTypeFields> showFields, List<TicketTypeWhereFields> whereFields, List<TicketTypeOrderFields> orderFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:TicketType表查询操作/File:TicketTypeAccess.cs/Fun:GetTicketTypeTable*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("select " + GetShowFields(showFields) + " from ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[TicketType] with(nolock)");
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
sql.Append(" where ");
sql.Append(GetSqlString(null, whereFields));
}
if ( orderFields != null && orderFields.Count > 0 )
{
sql.Append(GetOrderFields(orderFields));
}
GetSqlParameterWrapperCollection(collection, null, whereFields);
return SqlHelper.ExecuteDataTable(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, RemarkFields field, string fieldVariable, object fieldValue)
{
switch ( field )
{
case RemarkFields.RId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int));
break;
case RemarkFields.ROrderSerialNo:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case RemarkFields.RRemarkType:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case RemarkFields.RRemarkContent:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case RemarkFields.RRemarkTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case RemarkFields.RRemarkReply:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case RemarkFields.RReplyTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case RemarkFields.RRemarkState:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case RemarkFields.RRowValid:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
}
}
/// <summary>
/// OrderTable修改操作
/// </summary>
/// <param name="oTId">订单表id</param>
/// <param name="updateModel">要修改OrderTable实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Update(int oTId,OrderTableModel updateModel,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:OrderTable表更新操作/File:OrderTableAccess.cs/Fun:Update*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("update ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[OrderTable] set OTOrderComfirmNo=@OTOrderComfirmNo,OTOrderCreateTime=@OTOrderCreateTime,OTTravelTime=@OTTravelTime,OTOrderPhone=@OTOrderPhone,OTOrderName=@OTOrderName,OTTicketPhone=@OTTicketPhone,OTTicketName=@OTTicketName,OTTicketNumber=@OTTicketNumber,OTOrderState=@OTOrderState,OTPayWay=@OTPayWay,OTTicketPrice=@OTTicketPrice,OTIdentityCard=@OTIdentityCard,OTBrokerage=@OTBrokerage,OTTicketTypeId=@OTTicketTypeId,OTRowValid=@OTRowValid,OTRemark=@OTRemark,OTScenicId=@OTScenicId,OTHaveTicketNumber=@OTHaveTicketNumber where OTId=@OTId");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@OTOrderComfirmNo", updateModel.OTOrderComfirmNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTOrderCreateTime", updateModel.OTOrderCreateTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@OTTravelTime", updateModel.OTTravelTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@OTOrderPhone", updateModel.OTOrderPhone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTOrderName", updateModel.OTOrderName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketPhone", updateModel.OTTicketPhone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketName", updateModel.OTTicketName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTTicketNumber", updateModel.OTTicketNumber,SqlDbType.Int));
Collection.Add(new SqlParameterWrapper("@OTOrderState", updateModel.OTOrderState,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTPayWay", updateModel.OTPayWay,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTTicketPrice", updateModel.OTTicketPrice,SqlDbType.Decimal));
Collection.Add(new SqlParameterWrapper("@OTIdentityCard", updateModel.OTIdentityCard,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTBrokerage", updateModel.OTBrokerage,SqlDbType.Decimal));
Collection.Add(new SqlParameterWrapper("@OTTicketTypeId", updateModel.OTTicketTypeId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTRowValid", updateModel.OTRowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@OTRemark", updateModel.OTRemark,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTScenicId", updateModel.OTScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@OTHaveTicketNumber", updateModel.OTHaveTicketNumber,SqlDbType.Int));
Collection.Add(new SqlParameterWrapper("@OTId", oTId,SqlDbType.Int));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
/// JQResource 添加操作返回主键的编号
/// </summary>
/// <param name="jqresource">JQResource实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public int AddByIdentity(JQResourceModel jqresource,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:JQResource表增加操作/File:JQResourceAccess.cs/Fun:AddByIdentity*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[JQResource] (JQRScenicId,JQRScenicName,JQRScenicDecribe,JQRPrincipal,JQRAddress,JQRTelephone,JQREmail,JQRRowValid,JQRCreateTime) values(@JQRScenicId,@JQRScenicName,@JQRScenicDecribe,@JQRPrincipal,@JQRAddress,@JQRTelephone,@JQREmail,@JQRRowValid,@JQRCreateTime)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@JQRScenicId", jqresource.JQRScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRScenicName", jqresource.JQRScenicName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRScenicDecribe", jqresource.JQRScenicDecribe,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRPrincipal", jqresource.JQRPrincipal,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRAddress", jqresource.JQRAddress,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRTelephone", jqresource.JQRTelephone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQREmail", jqresource.JQREmail,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRRowValid", jqresource.JQRRowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@JQRCreateTime", jqresource.JQRCreateTime,SqlDbType.DateTime));
return SqlHelper.ExecuteIdentity(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction);
}
/// <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, JQResourceFields field, string fieldVariable, object fieldValue)
{
switch ( field )
{
case JQResourceFields.JQRId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int));
break;
case JQResourceFields.JQRScenicId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRScenicName:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRScenicDecribe:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRPrincipal:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRAddress:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRTelephone:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQREmail:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case JQResourceFields.JQRRowValid:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case JQResourceFields.JQRCreateTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
}
}
/// <summary>
/// JQResource修改操作
/// </summary>
/// <param name="jQRId">景区资源表Id</param>
/// <param name="updateModel">要修改JQResource实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Update(int jQRId,JQResourceModel updateModel,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:JQResource表更新操作/File:JQResourceAccess.cs/Fun:Update*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("update ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[JQResource] set JQRScenicDecribe=@JQRScenicDecribe,JQRPrincipal=@JQRPrincipal,JQRAddress=@JQRAddress,JQRTelephone=@JQRTelephone,JQREmail=@JQREmail,JQRRowValid=@JQRRowValid,JQRCreateTime=@JQRCreateTime where JQRId=@JQRId");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@JQRScenicDecribe", updateModel.JQRScenicDecribe,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRPrincipal", updateModel.JQRPrincipal,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRAddress", updateModel.JQRAddress,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRTelephone", updateModel.JQRTelephone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQREmail", updateModel.JQREmail,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@JQRRowValid", updateModel.JQRRowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@JQRCreateTime", updateModel.JQRCreateTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@JQRId", jQRId,SqlDbType.Int));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showFields">显示字段</param>
/// <param name="whereFields">条件字段</param>
/// <param name="orderFields">排序字段</param>
/// <param name="pageSize">页面数量</param>
/// <param name="pageIndex">页面索引</param>
/// <returns>返回表格</returns>
public DataTable GetJQResourceTable(DataBaseType dbType,List<JQResourceFields> showFields, List<JQResourceWhereFields> whereFields, List<JQResourceOrderFields> orderFields, int pageSize, int pageIndex)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:JQResource表分页查询操作/File:JQResourceAccess.cs/Fun:GetJQResourceTable*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append(PageSplitQuery.GetPageSplitSql2005("JQResource", "JQRId", GetShowFields(showFields), string.Empty, GetSqlString(null, whereFields), GetOrderFields(orderFields), pageSize, pageIndex));
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
GetSqlParameterWrapperCollection(collection, null, whereFields);
}
return SqlHelper.ExecuteDataTable(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, TicketTypeFields field, string fieldVariable, object fieldValue)
{
switch ( field )
{
case TicketTypeFields.TTId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int));
break;
case TicketTypeFields.TTTypeId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case TicketTypeFields.TTTypeName:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case TicketTypeFields.TTScenicId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case TicketTypeFields.TTStartTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case TicketTypeFields.TTDeadline:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case TicketTypeFields.TTRowValid:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case TicketTypeFields.TTCreateTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
}
}
/// <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>
/// Remark 添加操作
/// </summary>
/// <param name="remark">Remark实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(RemarkModel remark,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Remark表增加操作/File:RemarkAccess.cs/Fun:Add*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Remark] (ROrderSerialNo,RRemarkType,RRemarkContent,RRemarkTime,RRemarkReply,RReplyTime,RRemarkState,RRowValid) values(@ROrderSerialNo,@RRemarkType,@RRemarkContent,@RRemarkTime,@RRemarkReply,@RReplyTime,@RRemarkState,@RRowValid)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@ROrderSerialNo", remark.ROrderSerialNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RRemarkType", remark.RRemarkType,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@RRemarkContent", remark.RRemarkContent,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RRemarkTime", remark.RRemarkTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@RRemarkReply", remark.RRemarkReply,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RReplyTime", remark.RReplyTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@RRemarkState", remark.RRemarkState,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@RRowValid", remark.RRowValid,SqlDbType.TinyInt));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
/// 自定义修改
/// </summary>
/// <param name="update">更新字段</param>
/// <param name="where">条件字段</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Update(List<CommentsFieldValuePair> update, List<CommentsWhereFields> where,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表更新操作/File:CommentsAccess.cs/Fun:Update*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("update ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Comments] set ");
sql.Append(GetSqlString(update, null));
if(where !=null && where.Count > 0)
{
sql.Append(" where ");
sql.Append(GetSqlString(null, where));
}
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
GetSqlParameterWrapperCollection(collection, update, where);
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig), sql.ToString(), collection,transaction) > 0;
}
/// <summary>
/// 查询数量
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="whereFields">条件字段</param>
/// <returns>返回Admin表格</returns>
public int GetCount(DataBaseType dbType, List<AdminWhereFields> whereFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表查询操作/File:AdminAccess.cs/Fun:GetTopAdminTable*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("select count(*) from ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Admin] 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.ExecuteScalarByInt(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, CommentsFields field, string fieldVariable, object fieldValue)
{
switch ( field )
{
case CommentsFields.CId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int));
break;
case CommentsFields.COrderSerialNo:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case CommentsFields.CCommentsType:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case CommentsFields.CCommentsContent:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case CommentsFields.CCommentsTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case CommentsFields.CCommentsReply:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case CommentsFields.CReplyTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case CommentsFields.CCommentsState:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case CommentsFields.CRowValid:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
}
}
/// <summary>
/// Admin修改操作
/// </summary>
/// <param name="aId">景区用户Id</param>
/// <param name="updateModel">要修改Admin实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Update(int aId,AdminModel updateModel,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表更新操作/File:AdminAccess.cs/Fun:Update*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("update ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Admin] set APassword=@APassword,AEmail=@AEmail,ATelephone=@ATelephone,ARowValid=@ARowValid,ACreateTime=@ACreateTime,AScenicId=@AScenicId,AUserLimit=@AUserLimit where AId=@AId");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@APassword", updateModel.APassword,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@AEmail", updateModel.AEmail,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@ATelephone", updateModel.ATelephone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@ARowValid", updateModel.ARowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@ACreateTime", updateModel.ACreateTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@AScenicId", updateModel.AScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@AUserLimit", updateModel.AUserLimit,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@AId", aId,SqlDbType.Int));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}
/// <summary>
/// 自定义添加操作
/// </summary>
/// <param name="list">字段值对</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(List<CommentsFieldValuePair> list,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表增加操作/File:CommentsAccess.cs/Fun:Add*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append(GetInsertSql(list));
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
GetSqlParameterWrapperCollection(collection, list, null);
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),collection,transaction) > 0;
}
/// <summary>
/// Comments 自定义查询操作
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="showFields">显示字段</param>
/// <param name="whereFields">条件字段</param>
/// <param name="orderFields">排序字段</param>
/// <returns>返回Comments实体列表</returns>
public List<CommentsModel> GetCommentsList(DataBaseType dbType,List<CommentsFields> showFields, List<CommentsWhereFields> whereFields, List<CommentsOrderFields> orderFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表查询操作/File:CommentsAccess.cs/Fun:GetCommentsList*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("select " + GetShowFields(showFields) + " from ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Comments] with(nolock)");
SqlParameterWrapperCollection collection = new SqlParameterWrapperCollection();
if ( whereFields != null && whereFields.Count > 0 )
{
sql.Append(" where ");
sql.Append(GetSqlString(null, whereFields));
}
if ( orderFields != null && orderFields.Count > 0 )
{
sql.Append(GetOrderFields(orderFields));
}
GetSqlParameterWrapperCollection(collection, null, whereFields);
IDataReader reader = SqlHelper.ExecuteReader(DatabaseManager.GetDataBase(DatabaseManager.Db_JQEBookingConfig,dbType),sql.ToString(), collection);
return GetList(showFields,reader);
}
/// <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, AdminFields field, string fieldVariable, object fieldValue)
{
switch ( field )
{
case AdminFields.AId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.Int));
break;
case AdminFields.AName:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.APassword:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.AEmail:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.ATelephone:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.ARowValid:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
case AdminFields.ACreateTime:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.DateTime));
break;
case AdminFields.AScenicId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.AUserId:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.NVarChar));
break;
case AdminFields.AUserLimit:
collection.Add(new SqlParameterWrapper("@" + fieldVariable, fieldValue, SqlDbType.TinyInt));
break;
}
}
/// <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="dbType">数据库类型</param>
/// <param name="showField">字段</param>
/// <param name="whereFields">条件字段</param>
/// <returns>返回Comments表格</returns>
public object GetObject(DataBaseType dbType, CommentsFields showField, List<CommentsWhereFields> whereFields)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Comments表查询操作/File:CommentsAccess.cs/Fun:GetTopCommentsTable*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("select "+ showField.ToString()+" from ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Comments] 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>
/// Admin 添加操作返回主键的编号
/// </summary>
/// <param name="admin">Admin实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public int AddByIdentity(AdminModel admin,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Admin表增加操作/File:AdminAccess.cs/Fun:AddByIdentity*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Admin] (AName,APassword,AEmail,ATelephone,ARowValid,ACreateTime,AScenicId,AUserId,AUserLimit) values(@AName,@APassword,@AEmail,@ATelephone,@ARowValid,@ACreateTime,@AScenicId,@AUserId,@AUserLimit)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@AName", admin.AName,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@APassword", admin.APassword,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@AEmail", admin.AEmail,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@ATelephone", admin.ATelephone,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@ARowValid", admin.ARowValid,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@ACreateTime", admin.ACreateTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@AScenicId", admin.AScenicId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@AUserId", admin.AUserId,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@AUserLimit", admin.AUserLimit,SqlDbType.TinyInt));
return SqlHelper.ExecuteIdentity(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction);
}