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