/// <summary>
/// 更新 素材关系表
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateWXMenuMaterialMapping(SqlConnection conn, WXMenuMaterialMappingModel model)
{
#region SQL
string sql = @"Update [Configuration].[dbo].[WXMenuMaterialMapping]
set [ObjectID]=@ObjectID,
[ObjectType]=@ObjectType,
[OriginalID]=@OriginalID,
[ButtonKey]=@ButtonKey,
[MaterialID]=@MaterialID,
[MediaType]=@MediaType,
[MediaID]=ISNULL(@MediaID,0),
[Title]=ISNULL(@Title,''),
[ImageUrl]=ISNULL(@ImageUrl,''),
[ReplyWay]=@ReplyWay,
[IsDelaySend]=@IsDelaySend,
[IntervalHours]=ISNULL(@IntervalHours,0),
[IntervalMinutes]=ISNULL(@IntervalMinutes,0)
where PKID =@PKID
";
#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 AddWXMenuMaterialMapping(WXMenuMaterialMappingModel model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.AddWXMenuMaterialMapping(conn, model));
}
}
/// <summary>
/// 新增微信菜单和素材关系信息
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool AddWXMenuMaterialMapping(SqlConnection conn, WXMenuMaterialMappingModel model)
{
#region SQL
string sql = @"INSERT INTO [Configuration].[dbo].[WXMenuMaterialMapping]
([ObjectID]
,[ObjectType]
,[OriginalID]
,[ButtonKey]
,[MaterialID]
,[AppID]
,[MediaType]
,[MediaID]
,[Title]
,[ImageUrl]
,[ReplyWay]
,[IsDelaySend]
,[IntervalHours]
,[IntervalMinutes])
VALUES
(@ObjectID
,@ObjectType
,@OriginalID
,@ButtonKey
,@MaterialID
,@AppID
,@MediaType
,ISNULL(@MediaID,0)
,ISNULL(@Title,'')
,ISNULL(@ImageUrl,'')
,@ReplyWay
,@IsDelaySend
,ISNULL(@IntervalHours,0)
,ISNULL(@IntervalMinutes,0));
SELECT CAST(SCOPE_IDENTITY() as int);";
#endregion
model.PKID = conn.Query <int>(sql, model).FirstOrDefault();
if (model.PKID > 0)
{
return(true);
}
else
{
return(false);
}
}
