public JsonResult EditOrderRule(OrderRuleDetailModel request)
{
var result = TaskConfigManager.EditOrderRule(request, ThreadIdentity.Operator.Name);
return(Json(new
{
Code = result ? 1 : 0,
Indo = request
}));
}
public static bool EditOrderRule(OrderRuleDetailModel request, string Operator)
{
if (request.RuleNo == 0)
{
return(DalTask.AddOrderRule(request, Operator));
}
else
{
return(DalTask.UpdateOrderRuleInfo(request));
}
}
public static bool UpdateOrderRuleInfo(OrderRuleDetailModel request)
{
const string sqlStr = @"UPDATE Configuration..TaskOrderRuleId WITH ( ROWLOCK )
SET RuleName = @ruleName, RuleStatus = @ruleStatus, RuleType = @ruleType,
MatchType = @matchType, ConditionType = @conditionType,
CategoryList = @categoryList, Brand = @brand, PIDS = @pids
WHERE PKID = @ruleno;";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@ruleName", request.RuleName);
cmd.Parameters.AddWithValue("@ruleStatus", request.RuleStatus);
cmd.Parameters.AddWithValue("@ruleType", request.RuleType);
cmd.Parameters.AddWithValue("@matchType", request.MatchType);
cmd.Parameters.AddWithValue("@conditionType", request.ConditionType);
cmd.Parameters.AddWithValue("@categoryList", request.CategoryList);
cmd.Parameters.AddWithValue("@brand", request.Brand);
cmd.Parameters.AddWithValue("@pids", request.PIDS);
cmd.Parameters.AddWithValue("@ruleno", request.RuleNo);
return(DbHelper.ExecuteNonQuery(cmd) > 0);
}
}
public static bool AddOrderRule(OrderRuleDetailModel request, string creator)
{
const string sqlStr = @"
INSERT INTO Configuration..TaskOrderRuleId ( RuleName, RuleStatus, RuleType,
MatchType, ConditionType,
CategoryList, Brand, PIDS,
Creator )
VALUES ( @ruleName, @ruleStatus, @ruleType, @matchType, @conditionType,
@categoryList, @brand, @pids, @creator );";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@ruleName", request.RuleName);
cmd.Parameters.AddWithValue("@ruleStatus", request.RuleStatus);
cmd.Parameters.AddWithValue("@ruleType", request.RuleType);
cmd.Parameters.AddWithValue("@matchType", request.MatchType);
cmd.Parameters.AddWithValue("@conditionType", request.ConditionType);
cmd.Parameters.AddWithValue("@categoryList", request.CategoryList);
cmd.Parameters.AddWithValue("@brand", request.Brand);
cmd.Parameters.AddWithValue("@pids", request.PIDS);
cmd.Parameters.AddWithValue("@creator", creator);
return(DbHelper.ExecuteNonQuery(cmd) > 0);
}
}
