/// <summary>
/// 添加活动信息
/// </summary>
/// <param name="data"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool InsertThirdPartActivity(ThirdPartActivity data, string user)
{
var result = 0;
try
{
if (data != null)
{
dbScopeManager.Execute(conn =>
{
result = DALThirdPartActivity.InsertThirdPartActivity(conn, data);
});
}
}
catch (Exception ex)
{
logger.Log(Level.Error, ex, "InsertThirdPartActivity");
}
if (result > 0)
{
ActivityBoardManager.InsertLog("InsertThirdPartActivity", result.ToString(),
$"Data:{JsonConvert.SerializeObject(data)}", result > 0 ? "添加成功" : "添加失败", user, LogType);
CallCRMService.NewAddActivity(data.ActivityName, data.StartTime, data.EndTime, data.WebUrl, data.ActivityRules, result.ToString(), CRMSourceType.ActivityBoaardThirdParty, user);
}
return(result > 0);
}
/// <summary>
/// 更新活动信息
/// </summary>
/// <param name="data"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateThirdPartActivity(ThirdPartActivity data, string user)
{
var result = false;
try
{
if (data != null)
{
result = dbScopeManager.Execute(conn => DALThirdPartActivity.UpdateThirdPartActivity(conn, data)) > 0;
}
}
catch (Exception ex)
{
logger.Log(Level.Error, ex, "UpdateThirdPartActivity");
}
if (result)
{
ActivityBoardManager.InsertLog("UpdateThirdPartActivity", data.PKID.ToString(),
$"Data:{JsonConvert.SerializeObject(data)}", result ? "修改成功" : "修改失败", user, LogType);
CallCRMService.NewUpdateActivity(data.ActivityName, data.StartTime, data.EndTime, data.WebUrl, data.ActivityRules, data.PKID.ToString(), CRMSourceType.ActivityBoaardThirdParty, user);
}
return(result);
}
/// <summary>
/// 更新活动信息
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateThirdPartActivity(SqlConnection conn, ThirdPartActivity model)
{
var sql = @"UPDATE Configuration..ThirdPartActivity
SET ActivityName = @ActivityName ,
ActivityType = @ActivityType ,
H5Url = @H5Url ,
WebUrl = @WebUrl ,
ActivityRules = @ActivityRules ,
StartTime = @StartTime ,
EndTime = @EndTime ,
Owner = @Owner ,
Channel = @Channel ,
UpdatedTime = GETDATE()
WHERE PKID = @PKID";
return(conn.Execute(sql, new
{
PKID = model.PKID,
ActivityType = (int)model.ActivityType,
ActivityName = model.ActivityName,
H5Url = model.H5Url,
WebUrl = model.WebUrl,
ActivityRules = model.ActivityRules,
StartTime = model.StartTime,
EndTime = model.EndTime,
Owner = model.Owner,
Channel = model.Channel
}, commandType: CommandType.Text));
}
/// <summary>
/// 根据PKID获取活动信息
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public ThirdPartActivity GetThirdPartActivityByPKID(int pkid)
{
ThirdPartActivity result = null;
try
{
result = dbScopeReadManager.Execute(conn => DALThirdPartActivity.SelectThirdPartActivityByPKID(conn, pkid));
}
catch (Exception ex)
{
logger.Log(Level.Error, ex, "GetThirdPartActivityByPKID");
}
return(result);
}
/// <summary>
/// 添加活动信息
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertThirdPartActivity(SqlConnection conn, ThirdPartActivity model)
{
var sql = @"
INSERT INTO Configuration..ThirdPartActivity
( ActivityType ,
ActivityName ,
H5Url ,
WebUrl ,
ActivityRules ,
StartTime ,
EndTime ,
Owner ,
Channel ,
CreatedTime
)
OUTPUT Inserted.PKID
VALUES ( @ActivityType ,
@ActivityName ,
@H5Url ,
@WebUrl ,
@ActivityRules ,
@StartTime ,
@EndTime ,
@Owner ,
@Channel ,
GETDATE()
);";
return(Convert.ToInt32(conn.ExecuteScalar(sql, new
{
ActivityType = model.ActivityType,
ActivityName = model.ActivityName,
H5Url = model.H5Url,
WebUrl = model.WebUrl,
ActivityRules = model.ActivityRules,
StartTime = model.StartTime,
EndTime = model.EndTime,
Owner = model.Owner,
Channel = model.Channel
}, commandType: CommandType.Text)));
}
