public ActionResult Edit(RulesDictionaryConfig model) { if (model.Id != 0) { return(Json(RulesDictionaryConfigManager.UpdateRulesDictionaryConfig(model))); } else { return(Json(RulesDictionaryConfigManager.InsertRulesDictionaryConfig(model))); } }
public ActionResult Edit(int id = 0, int type = 0) { if (id == 0) { RulesDictionaryConfig model = new RulesDictionaryConfig(); model.Type = type; return(View(model)); } else { return(View(RulesDictionaryConfigManager.GetRulesDictionaryConfigById(id))); } }
public static bool UpdateRulesDictionaryConfig(RulesDictionaryConfig model) { const string sql = @"UPDATE Configuration..SE_RulesDictionaryConfig SET Content=@Content, Status=@Status, CreateTime=GETDATE() WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@Content", model.Content ?? string.Empty), new SqlParameter("@Status", model.Status) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public bool InsertRulesDictionaryConfig(RulesDictionaryConfig model) { try { return(DALRulesDictionaryConfig.InsertRulesDictionaryConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new RulesDictionaryConfigException(1, "InsertRulesDictionaryConfig", ex); Logger.Log(Level.Error, "InsertRulesDictionaryConfig", exception); throw ex; } }
public static bool InsertRulesDictionaryConfig(RulesDictionaryConfig model) { const string sql = @" INSERT INTO Configuration..[SE_RulesDictionaryConfig] ( Type, Content, Status, CreateTime ) VALUES ( @Type , @Content , @Status , GETDATE() )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Content", model.Content ?? string.Empty), new SqlParameter("@Status", model.Status), new SqlParameter("@Type", model.Type) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }