public ActionResult Edit(BusinessKeywordsConfig model) { string js = "<script>alert(\"保存失败 \");location='/BusinessKeywordsConfig/Index';</script>"; if (model.Id != 0) { if (BusinessKeywordsConfigManager.UpdateBusinessKeywordsConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } else { if (BusinessKeywordsConfigManager.InsertBusinessKeywordsConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } }
public static bool UpdateBusinessKeywordsConfig(BusinessKeywordsConfig model) { const string sql = @"UPDATE Configuration..BusinessKeywordsConfig SET Keywords=@Keywords ,CreateTime=GETDATE(), Sort=@Sort WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Keywords", model.Keywords ?? string.Empty), new SqlParameter("@Id", model.Id), new SqlParameter("@Sort", model.Sort) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public bool InsertBusinessKeywordsConfig(BusinessKeywordsConfig model) { try { return(DALBusinessKeywordsConfig.InsertBusinessKeywordsConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new BusinessKeywordsConfigException(1, "InsertBusinessKeywordsConfig", ex); Logger.Log(Level.Error, exception, "InsertBusinessKeywordsConfig"); throw ex; } }
public static bool InsertBusinessKeywordsConfig(BusinessKeywordsConfig model) { const string sql = @" INSERT INTO Configuration..BusinessKeywordsConfig ([Keywords] ,[CreateTime] ,Sort ) VALUES( @Keywords ,GETDATE() ,@Sort )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Keywords", model.Keywords), new SqlParameter("@Sort", model.Sort) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }