public int NewProcessOrderFlow(ProcessOrderFlow processOrderFlow, IEnumerable <int> orderColorDetailNo)
{
var sqlCmd = @"INSERT INTO ProcessOrderFlow
OUTPUT inserted.OrderDetailNo
VALUES
(@OrderNo,@FactoryID);";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@OrderNo", SqlDbType.Int)
{
Value = processOrderFlow.OrderNo
},
new SqlParameter("@FactoryID", SqlDbType.Int)
{
Value = processOrderFlow.FactoryID
}
};
var orderDetailNo = DapperHelper.Query <int>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameter);
var cmd = @"INSERT INTO ProcessOrderFlowDate
VALUES(@OrderColorDetailNo,@OrderDetailNo,null,null,GETDATE());";
var parameters =
orderColorDetailNo.Select(s => new { OrderColorDetailNo = s, OrderDetailNo = orderDetailNo, });
var count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, cmd, parameters);
return(count);
}
/// <summary>
/// 新增加工訂單流程
/// </summary>
/// <param name="list"></param>
/// <param name="orderColorDetailNo"></param>
/// <returns></returns>
public int NewProcessOrderFlow(ProcessOrderFlow processOrderFlow, IEnumerable <int> orderColorDetailNo)
{
int rsult = ProcessOrderAdapter.NewProcessOrderFlow(processOrderFlow, orderColorDetailNo);
return(rsult);
}