/// <summary>保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_UpdateGoods(object sender, EventArgs e)
{
var index = RadMultiPage1.SelectedIndex;
ShopActivityImageInfo shopActivityImageInfo;
switch (index)
{
case 0: //网站
shopActivityImageInfo = new ShopActivityImageInfo
{
ShopActivityImage = Editor_DescriptionWeb.Content,
ShopActivityImageType = (int)ShopActivityImageType.Web
};
break;
case 1: //手机
shopActivityImageInfo = new ShopActivityImageInfo
{
ShopActivityImage = Editor_DescriptionPhone.Content,
ShopActivityImageType = (int)ShopActivityImageType.Phone
};
break;
default:
shopActivityImageInfo = null;
break;
}
if (shopActivityImageInfo == null)
{
return;
}
var result = _activityImageDalWrite.InsertOrUpdate(shopActivityImageInfo);
RAM.Alert(result ? "保存成功" : "保存失败");
}
/// <summary>
/// 插入或修改活动图片
/// </summary>
/// <returns></returns>
public bool InsertOrUpdate(ShopActivityImageInfo imageInfo)
{
const string SQL = @" IF NOT EXISTS(SELECT ShopActivityImage FROM [ShopActivityImage] WHERE ShopActivityImageType=@ShopActivityImageType)
begin
INSERT INTO ShopActivityImage([ShopActivityImage],[ShopActivityImageType])VALUES(@ShopActivityImage,@ShopActivityImageType)
end
else
begin
UPDATE [ShopActivityImage]SET [ShopActivityImage] = @ShopActivityImage WHERE ShopActivityImageType=@ShopActivityImageType
end";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
ShopActivityImage = imageInfo.ShopActivityImage,
ShopActivityImageType = imageInfo.ShopActivityImageType,
}) > 0);
}
}
