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