/// <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))); }