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