public ActionResult Edit(DefaultSearchConfig model) { string js = "<script>alert(\"保存失败 \");location='/DefaultSearchConfig/Index';</script>"; if (model.Id != 0) { if (DefaultSearchConfigManager.UpdateDefaultSearchConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } else { if (DefaultSearchConfigManager.InsertDefaultSearchConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } }
public ActionResult Edit(int id = 0) { if (id == 0) { DefaultSearchConfig model = new DefaultSearchConfig(); model.Type = 2; return(View(model)); } else { return(View(DefaultSearchConfigManager.GetDefaultSearchConfig(id))); } }
public static bool UpdateDefaultSearchConfig(DefaultSearchConfig model) { const string sql = @" UPDATE Configuration..DefaultSearchConfig SET Name = @Name , Keywords = @Keywords , Image = @Image , Description = @Description , Link = @Link , IOSProcessValue = @IOSProcessValue , AndroidProcessValue = @AndroidProcessValue , IOSCommunicationValue = @IOSCommunicationValue , AndroidCommunicationValue = @AndroidCommunicationValue , WXAPPValue = @WXAPPValue , H5Value = @H5Value , Type = @Type , CreateTime = GETDATE() , ActivityType = @ActivityType , ActivityPromotionId = @ActivityPromotionId , ActivityStartTime = @ActivityStartTime , ActivityEndTime = @ActivityEndTime, IsJump=@IsJump WHERE Id = @Id;"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Name", model.Name ?? string.Empty), new SqlParameter("@Keywords", model.Keywords ?? string.Empty), new SqlParameter("@Image", model.Image ?? string.Empty), new SqlParameter("@Description", model.Description ?? string.Empty), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@IOSProcessValue", model.IOSProcessValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@WXAPPValue", model.WXAPPValue ?? string.Empty), new SqlParameter("@H5Value", model.H5Value ?? string.Empty), new SqlParameter("@Type", model.Type), new SqlParameter("@Id", model.Id), new SqlParameter("@ActivityType", model.ActivityType), new SqlParameter("@ActivityPromotionId", model.ActivityPromotionId), new SqlParameter("@ActivityStartTime", model.ActivityStartTime), new SqlParameter("@ActivityEndTime", model.ActivityEndTime), new SqlParameter("@IsJump", model.IsJump?1:0) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public bool InsertDefaultSearchConfig(DefaultSearchConfig model) { try { return(DALDefaultSearchConfig.InsertDefaultSearchConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DefaultSearchConfigException(1, "InsertDefaultSearchConfig", ex); Logger.Log(Level.Error, exception, "InsertDefaultSearchConfig"); throw ex; } }
public static bool InsertDefaultSearchConfig(DefaultSearchConfig model) { const string sql = @" INSERT INTO Configuration..DefaultSearchConfig ( [Name] , [Keywords] , [Image] , [Description] , [Link] , [IOSProcessValue] , [AndroidProcessValue] , [IOSCommunicationValue] , [AndroidCommunicationValue] , [WXAPPValue] , [H5Value] , [Type] , [CreateTime] , ActivityType , ActivityPromotionId , ActivityStartTime , ActivityEndTime ) VALUES ( @Name , @Keywords , @Image , @Description , @Link , @IOSProcessValue , @AndroidProcessValue , @IOSCommunicationValue , @AndroidCommunicationValue , @WXAPPValue , @H5Value , @Type , GETDATE() , @ActivityType , @ActivityPromotionId , @ActivityStartTime , @ActivityEndTime );"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Name", model.Name ?? string.Empty), new SqlParameter("@Keywords", model.Keywords ?? string.Empty), new SqlParameter("@Image", model.Image ?? string.Empty), new SqlParameter("@Description", model.Description ?? string.Empty), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@IOSProcessValue", model.IOSProcessValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@WXAPPValue", model.WXAPPValue ?? string.Empty), new SqlParameter("@H5Value", model.H5Value ?? string.Empty), new SqlParameter("@Type", model.Type), new SqlParameter("@ActivityType", model.ActivityType), new SqlParameter("@ActivityPromotionId", model.ActivityPromotionId), new SqlParameter("@ActivityStartTime", model.ActivityStartTime), new SqlParameter("@ActivityEndTime", model.ActivityEndTime) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }