public bool UpdateBaoYangPackageImageConfigNew(BaoYangPackageImageConfig model) { try { return(DalBaoYangPackageImageConfig.UpdateBaoYangPackageImageConfigNew(model)); } catch (Exception ex) { _Logger.Error("UpdateBaoYangPackageImageConfigNew", ex); return(false); } }
public ActionResult Edit(BaoYangPackageImageConfig model) { string js = "<script>alert(\"保存失败 \");location='/BaoYangPackageImageConfig/Index';</script>"; if (BaoYangPackageImageConfigManager.UpdateBaoYangPackageImageConfigNew(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } }
public static bool UpdateBaoYangPackageImageConfigNew(BaoYangPackageImageConfig model) { const string sql = @"IF EXISTS ( SELECT 1 FROM Configuration..SE_BaoYangPackageImageConfig WITH ( NOLOCK ) WHERE PID = @PID ) BEGIN UPDATE [Configuration].[dbo].[SE_BaoYangPackageImageConfig] SET [Image] = @Image , [Image2] = @Image2 , [CreateTime] = GETDATE() WHERE PID = @PID; END; ELSE BEGIN INSERT INTO [Configuration].[dbo].[SE_BaoYangPackageImageConfig] ( [PID] , [Image] , [Image2] , [CreateTime] ) VALUES ( @PID , @Image , @Image2 , GETDATE() ); END;"; var sqlParameters = new SqlParameter[] { new SqlParameter("@PID", model.PID), new SqlParameter("@Image", model.Image), new SqlParameter("@Image2", model.Image2), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0); }