/// <summary>
/// 添加会员促销活动.
/// </summary>
/// <param name="promoteVip">
/// Promote_Vip的对象实例.
/// </param>
/// <returns>
/// 会员促销活动的编号.
/// </returns>
public int Add(Promote_Vip promoteVip)
{
SqlTransaction transaction = null;
try
{
var promoteVipID = this.promoteVipDA.Insert(promoteVip, out transaction);
if (promoteVip.Scopes != null && promoteVip.Scopes.Count > 0)
{
foreach (var scope in promoteVip.Scopes)
{
scope.PromoteVipID = promoteVipID;
this.promoteVipScopeDA.Insert(scope, transaction);
}
}
transaction.Commit();
return promoteVipID;
}
catch (Exception exception)
{
if (transaction != null)
{
transaction.Rollback();
}
throw new Exception(exception.Message, exception);
}
}
/// <summary>
/// 添加会员促销活动.
/// </summary>
/// <param name="promoteVip">
/// Promote_Vip的对象实例.
/// </param>
public void Modify(Promote_Vip promoteVip)
{
SqlTransaction transaction = null;
try
{
this.promoteVipDA.Update(promoteVip, out transaction);
if (promoteVip.Scopes != null && promoteVip.Scopes.Count > 0)
{
this.promoteVipScopeDA.Delete(promoteVip.ID, transaction);
foreach (var scope in promoteVip.Scopes)
{
scope.PromoteVipID = promoteVip.ID;
this.promoteVipScopeDA.Insert(scope, transaction);
}
}
transaction.Commit();
}
catch (Exception exception)
{
if (transaction != null)
{
transaction.Rollback();
}
throw new Exception(exception.Message, exception);
}
}
/// <summary>
/// 添加会员促销活动.
/// </summary>
/// <param name="promoteVip">
/// Promote_Vip的对象实例.
/// </param>
/// <param name="transaction">
/// 数据库事务.
/// </param>
/// <returns>
/// 会员促销活动的编号.
/// </returns>
public int Insert(Promote_Vip promoteVip, out SqlTransaction transaction)
{
if (promoteVip == null)
{
throw new ArgumentNullException("promoteVip");
}
this.SqlServer.BeginTransaction();
transaction = this.SqlServer.Transaction;
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
promoteVip.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
promoteVip.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"StartTime",
SqlDbType.DateTime,
promoteVip.StartTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EndTime",
SqlDbType.DateTime,
promoteVip.EndTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNewUser",
SqlDbType.Bit,
promoteVip.IsNewUser,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsMobileValidate",
SqlDbType.Bit,
promoteVip.IsMobileValidate,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsUseCoupon",
SqlDbType.Bit,
promoteVip.IsUseCoupon,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
promoteVip.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
promoteVip.Description,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
promoteVip.ID,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Promote_Vip_Insert",
parameters,
transaction);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 修改会员促销活动.
/// </summary>
/// <param name="promoteVip">
/// Promote_Vip的对象实例.
/// </param>
/// <param name="transaction">
/// 数据库事务.
/// </param>
public void Update(Promote_Vip promoteVip, out SqlTransaction transaction)
{
if (promoteVip == null)
{
throw new ArgumentNullException("promoteVip");
}
this.SqlServer.BeginTransaction(IsolationLevel.ReadCommitted);
transaction = this.SqlServer.Transaction;
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
promoteVip.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
promoteVip.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
promoteVip.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNewUser",
SqlDbType.Bit,
promoteVip.IsNewUser,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsMobileValidate",
SqlDbType.Bit,
promoteVip.IsMobileValidate,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsUseCoupon",
SqlDbType.Bit,
promoteVip.IsUseCoupon,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"StartTime",
SqlDbType.DateTime,
promoteVip.StartTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EndTime",
SqlDbType.DateTime,
promoteVip.EndTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
promoteVip.Description,
ParameterDirection.Input)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_Vip_Update", parameters, transaction);
}
