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