/// <summary>
/// 新增分组
/// </summary>
/// <param name="header">分组对象</param>
/// <returns>新增结果</returns>
public static int Insert(TMSDataHeader header)
{
string sql = @"INSERT INTO TMS_DATA_HEADER(GROUP_NO, VH_TYPE, WH_CODE, CREATE_DATE, START_TIME,
ATTRI_1, ATTRI_2, ATTRI_3, ATTRI_4, ATTRI_5) VALUES(@GroupNo, @VhType, @WhCode, NOW(),@StartTime, @Attri1,
@Attri2, @Attri3, @Attri4, @Attri5)";
IMapper map = DatabaseInstance.Instance();
//IDbTransaction trans = map.BeginTransaction();
int result = -1;
try
{
result = map.Execute(sql, new
{
GroupNo = header.id,
VhType = header.car_type,
WhCode = header.storehouse,
StartTime = header.start_time,
Attri1 = header.Attri1,
Attri2 = header.Attri2,
Attri3 = header.Attri3,
Attri4 = header.Attri4,
Attri5 = header.Attri5
});
if (result > 0)
{
foreach (string marketKey in header.order_list.Keys)
{
TMSDataMarket market = header.order_list[marketKey];
market.marketid = marketKey;
market.GroupNo = header.id;
result += InsertMarket(market);
}
}
//trans.Commit();
}
catch
{
result = -1;
//trans.Rollback();
}
return(result);
}
/// <summary>
/// 新增分组
/// </summary>
/// <remarks>Add By 万伟超</remarks>
/// <param name="header">市场对象</param>
/// <returns>新增结果</returns>
public static int InsertMarket(TMSDataMarket market)
{
int result = -1;
string sql = @"INSERT INTO TMS_DATA_MARKET(MARKET_ID,GROUP_NO, X, Y,
ATTRI_1, ATTRI_2, ATTRI_3, ATTRI_4, ATTRI_5) VALUES(@MarketId, @GroupNo, @X, @Y, @Attri1,
@Attri2, @Attri3, @Attri4, @Attri5)";
IMapper map = DatabaseInstance.Instance();
result = map.Execute(sql, new
{
MarketId = market.marketid,
GroupNo = market.GroupNo,
X = market.x,
Y = market.y,
Attri1 = market.Attri1,
Attri2 = market.Attri2,
Attri3 = market.Attri3,
Attri4 = market.Attri4,
Attri5 = market.Attri5
});
if (result > 0)
{
foreach (string detailKey in market.order_info.Keys)
{
TMSDataDetail detail = market.order_info[detailKey];
detail.orderid = detailKey;
detail.MarketID = market.marketid;
detail.GroupNo = market.GroupNo;
result += InsertDetail(detail);
}
}
return(result);
}
