本文整理汇总了C#中SqlHelper.Execute方法的典型用法代码示例。如果您正苦于以下问题：C# SqlHelper.Execute方法的具体用法？C# SqlHelper.Execute怎么用？C# SqlHelper.Execute使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlHelper的用法示例。
在下文中一共展示了SqlHelper.Execute方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GenerateSale
void GenerateSale(OleDbConnection connection, OleDbTransaction transaction, DateTime date) {
int id = GetId();
int region = regions[rndRegions[random.Next(0, rndRegions.Length)]].Id;
int channel = channels[rndChannels[random.Next(0, rndChannels.Length)]].Id;
int sector = sectors[rndSectors[random.Next(0, rndSectors.Length)]].Id;
Product product = products[rndProducts[random.Next(0, rndProducts.Length)]];
int productPrice = product.Price;
int discount = rndDiscounts[random.Next(0, rndDiscounts.Length)];
int units = rndUnits[random.Next(0, rndUnits.Length)];
int totalPrice = (productPrice * units) - discount;
SqlHelper<OleDbConnection, OleDbCommand> helper = new SqlHelper<OleDbConnection, OleDbCommand>();
helper.Execute(connection, transaction, "insert into sales (id, units, cost_per_unit, discount, total_cost, sale_date, productId, RegionId, ChannelId, SectorId) " +
"values (@id, @units, @cost_per_unit, @discount, @total_cost, @sale_date, @productId, @RegionId, @ChannelId, @SectorId)",
new OleDbParameter("@id", id),
new OleDbParameter("@units", units),
new OleDbParameter("@cost_per_unit", productPrice),
new OleDbParameter("@discount", discount),
new OleDbParameter("@total_cost", totalPrice),
new OleDbParameter("@sale_date", date),
new OleDbParameter("@productId", product.Id),
new OleDbParameter("@RegionId", region),
new OleDbParameter("@ChannelId", channel),
new OleDbParameter("@SectorId", sector));
}