public bool UpdateShopActivityNoticeInfo(ShopActivityNoticeInfo info)
{
const string SQL = @"UPDATE [ShopActivityNotice] SET [NoticeTitle] = @NoticeTitle ,[NoticeContent] = @NoticeContent ,[IsNotice] = @IsNotice ,[IsShow] = @IsShow WHERE [NoticeID] = @NoticeID";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
NoticeID = info.NoticeID,
NoticeTitle = info.NoticeTitle,
NoticeContent = info.NoticeContent,
IsNotice = info.IsNotice,
IsShow = info.IsShow,
}) > 0);
}
}
public bool InsertShopActivityNoticeInfo(ShopActivityNoticeInfo info)
{
const string SQL = @"INSERT INTO [ShopActivityNotice]
([NoticeID] ,[NoticeTitle] ,[NoticeContent] ,[CreateTime] ,[IsNotice] ,[IsShow] ,[OrderIndex])
VALUES
(@NoticeID ,@NoticeTitle ,@NoticeContent ,@CreateTime,@IsNotice ,@IsShow ,(select ISNULL(MAX(OrderIndex)+1,1) from ShopActivityNotice))";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
NoticeID = info.NoticeID,
NoticeTitle = info.NoticeTitle,
NoticeContent = info.NoticeContent,
CreateTime = info.CreateTime,
IsNotice = info.IsNotice,
IsShow = info.IsShow,
}) > 0);
}
}
