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