/// <summary>
/// 修改个人中心页面配置渠道
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMemberPageChannel(MemberPageChannelModel model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.UpdateMemberPageChannel(conn, model));
}
}
/// <summary>
/// 新增个人中心页面配置渠道
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMemberPageChannel(SqlConnection conn, MemberPageChannelModel model)
{
#region SQL
string sql = @"
INSERT INTO [dbo].[MemberPageChannel]
([Channel]
,[MemberPageModuleID]
,[MemberPageModuleContentID]
,[Link]
,[MiniProgramAppID])
VALUES
(@Channel
,@MemberPageModuleID
,@MemberPageModuleContentID
,@Link
,@MiniProgramAppID);
SELECT CAST(SCOPE_IDENTITY() as int);";
#endregion
model.PKID = conn.Query <int>(sql, model).FirstOrDefault();
if (model.PKID > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改个人中心页面配置渠道
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMemberPageChannel(SqlConnection conn, MemberPageChannelModel model)
{
#region SQL
string sql = @"
UPDATE [Configuration]..[MemberPageChannel] WITH(ROWLOCK)
SET [Channel] = @Channel
,[MemberPageModuleContentID] = @MemberPageModuleContentID
,[Link] = @Link
,[MiniProgramAppID] = @MiniProgramAppID
,[LastUpdateDateTime] =GETDATE()
WHERE PKID=@PKID";
#endregion
return(conn.Execute(sql, model) > 0);
}
