/// <summary> /// 添加一条订单流程 这个add是重载函数,不是调用的这个方法 /// </summary> /// <param name="operUser">操作人</param> /// <param name="operType">操作类型(利用enum流程名称枚举获取)</param> /// <param name="dealerID">经销店ID,只有在提交订单时需要,其他填写Guid.Empty</param> /// <param name="ordersID">订单ID</param> /// <param name="ordersID">是否直接提交给大客户室</param> public void Add(string operUser, string operType, int dealerID, int ordersID, bool directSubmit) { Common.Entity.OrderProcess e = new Common.Entity.OrderProcess(); e.OperationName = operType; e.Operator = operUser; e.OperationDate = DateTime.Now; e.OrderId = ordersID; switch ((int)Enum.Parse(typeof(Common.Utilities.enum流程名称枚举), operType)) { case (int)Common.Utilities.enum流程名称枚举.订单生成: break; case (int)Common.Utilities.enum流程名称枚举.订单提交: if (directSubmit) { e.NextOperator = userList(GetFTMSUser()); } else { e.NextOperator = userList(GetDDDQUser(dealerID)); } break; case (int)Common.Utilities.enum流程名称枚举.地担审批通过: e.NextOperator = userList(GetFTMSUser()); break; case (int)Common.Utilities.enum流程名称枚举.大区经理审批通过: e.NextOperator = userList(GetFTMSUser()); break; case (int)Common.Utilities.enum流程名称枚举.大客户室审批通过: e.NextOperator = string.Format("配车:{0}; 返款:{1}", userList(GetDistributeUser(ordersID)), userList(GetRebatesUser(ordersID))); break; case (int)Common.Utilities.enum流程名称枚举.订单交车: e.NextOperator = string.Format("返款:{0}", userList(GetRebatesUser(ordersID))); break; case (int)Common.Utilities.enum流程名称枚举.订单配车: e.NextOperator = string.Format("返款:{0}", userList(GetRebatesUser(ordersID))); break; case (int)Common.Utilities.enum流程名称枚举.订单返款: e.NextOperator = string.Format("返款:{0}", userList(GetRebatesUser(ordersID))); break; case (int)Common.Utilities.enum流程名称枚举.订单年终补款: e.NextOperator = string.Format("返款:{0}", userList(GetRebatesUser(ordersID))); break; default: e.NextOperator = ""; break; } Add(e); }
/// <summary> /// 添加订单流程表 /// </summary> /// <param name="model"></param> private static void Add(Common.Entity.OrderProcess model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Insert into OrderProcess(OrderId,OperationName,Operator,OperationDate,NextOperator) Values"); strSql.Append("(@OrderId,@OperationName,@Operator,@OperationDate,@NextOperator)"); strSql.Append(";SELECT @@IDENTITY");// 返回插入用户的主键 SqlParameter[] param = { new SqlParameter("@OrderId", model.OrderId), new SqlParameter("@OperationName", model.OperationName), new SqlParameter("@Operator", model.Operator), new SqlParameter("@OperationDate", model.OperationDate), new SqlParameter("@NextOperator", SqlNull(model.NextOperator)), }; SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param); }