/// <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);
}
/// <summary>
/// 新增明细
/// </summary>
/// <remarks>Update By 万伟超</remarks>
/// <param name="header">明细对象</param>
/// <returns>新增结果</returns>
public static int InsertDetail(TMSDataDetail detail)
{
string sql = @"INSERT INTO TMS_DATA_DETAIL(MARKET_ID, BILL_NO, IN_SORT,
WHLOE_QTY, BULK_QTY, ATTRI_1, ATTRI_2, ATTRI_3, ATTRI_4, ATTRI_5, GROUP_NO) VALUES(@MarketId,
@BillNo, @InSort, @WhloeQty, @BulkQty, @Attri1, @Attri2, @Attri3, @Attri4, @Attri5, @GroupNo)";
IMapper map = DatabaseInstance.Instance();
return(map.Execute(sql, new
{
MarketId = detail.MarketID,
BillNo = detail.orderid,
InSort = detail.sort,
WhloeQty = detail.zhengnum,
BulkQty = detail.sannum,
Attri1 = detail.Attri1,
Attri2 = detail.Attri2,
Attri3 = detail.Attri3,
Attri4 = detail.Attri4,
Attri5 = detail.Attri5,
GroupNo = detail.GroupNo
}));
}
