create proc create_OrderConfrim@orderId nvarchar(50),--订单号@userId int,---用户编号@address nvarchar(255),--收货人地址@totalMoney money output--总价as declare @error int set @error=0--记录错误--计算订单的总价(当前用户) select @totalMoney=sum([count]*UnitPrice) from Cart inner join Books on Cart.BookId=Books.Id where Cart.UserI Read More
此案例需要引入NPOI.dll文件和Ionic.Zip.dll文件 1 using System; 2 3 using System.Collections.Generic; 4 5 using System.Linq; 6 7 using System.Text; 8 9 using System.Data.SqlClient; 10 11 using NPOI.SS.UserModel; 12 13 using NPOI.HSSF.UserModel; 14 15 using System.IO; 16 17 18 19 namespace 导出数据... Read More