public void Update(PointProductOrderInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"UPDATE PointProductOrder SET OrderNumber = @OrderNumber, OrderStatus = @OrderStatus, OrderNote = @OrderNote, Point = @Point, ProductId = @ProductId, ProductName = @ProductName, BuyCount = @BuyCount, Consignee = @Consignee, RegionId = @RegionId, Address = @Address, Tel = @Tel, ShippingName = @ShippingName, ShippingNumber = @ShippingNumber, ShippingDate = @ShippingDate, AddDate = @AddDate, IP = @IP, UserId = @UserId, UserName = @UserName
where Id=@Id";
conn.Execute(sql, entity);
}
}
public int Add(PointProductOrderInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO PointProductOrder( OrderNumber,OrderStatus,OrderNote,Point,ProductId,ProductName,BuyCount,Consignee,RegionId,Address,Tel,ShippingName,ShippingNumber,ShippingDate,AddDate,IP,UserId,UserName) VALUES(@OrderNumber,@OrderStatus,@OrderNote,@Point,@ProductId,@ProductName,@BuyCount,@Consignee,@RegionId,@Address,@Tel,@ShippingName,@ShippingNumber,@ShippingDate,@AddDate,@IP,@UserId,@UserName);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
public static void Update(PointProductOrderInfo entity)
{
dal.Update(entity);
}
protected void Submit()
{
if (base.UserId <= 0)
{
ResponseHelper.Write("error|还未登录");
ResponseHelper.End();
}
int pointLeft = UserAccountRecordBLL.SumPoint(base.UserId);
string userName = base.UserName;
string userEmail = CookiesHelper.ReadCookieValue("UserEmail");
//检测积分
int id = RequestHelper.GetForm <int>("updateId");
if (id < 1)
{
ResponseHelper.Write("error|无效的请求");
ResponseHelper.End();
}
gift = PointProductBLL.Read(id);
if (gift.IsSale != (int)BoolType.True)
{
ResponseHelper.Write("error|该商品已下架");
ResponseHelper.End();
}
if (gift.Point > pointLeft)
{
ResponseHelper.Write("error|您当前的积分不足以兑取该商品");
ResponseHelper.End();
}
if (gift.EndDate.Date < DateTime.Now.Date)
{
ResponseHelper.Write("error|该商品已过有效兑取时间");
ResponseHelper.End();
}
//库存
if (gift.TotalStorageCount - gift.SendCount < 1)
{
ResponseHelper.Write("error|该商品库存不足");
ResponseHelper.End();
}
//添加订单
var order = new PointProductOrderInfo();
order.OrderNumber = ShopCommon.CreateOrderNumber();
order.OrderStatus = (int)PointProductOrderStatus.Shipping;
order.Point = gift.Point;
order.ProductId = gift.Id;
order.ProductName = gift.Name;
order.BuyCount = 1;
order.Consignee = StringHelper.AddSafe(RequestHelper.GetForm <string>("username"));
SingleUnlimitClass singleUnlimitClass = new SingleUnlimitClass();
order.RegionId = singleUnlimitClass.ClassID;
order.Address = StringHelper.AddSafe(RequestHelper.GetForm <string>("address"));
order.Tel = StringHelper.AddSafe(RequestHelper.GetForm <string>("mobile"));
order.AddDate = DateTime.Now;
order.IP = ClientHelper.IP;
order.UserId = base.UserId;
order.UserName = base.UserName;
order.Id = PointProductOrderBLL.Add(order);
if (order.Id > 0)
{
//扣减积分
UserAccountRecordBLL.Add(new UserAccountRecordInfo
{
RecordType = (int)AccountRecordType.Point,
Money = 0,
Point = -order.Point,
Date = DateTime.Now,
IP = ClientHelper.IP,
Note = "兑取商品：" + order.ProductName + " 订单号：" + order.OrderNumber,
UserId = order.UserId,
UserName = order.UserName
});
//扣减库存
PointProductBLL.ChangeSendCount(order.ProductId, ChangeAction.Plus);
}
ResponseHelper.Write("ok|" + order.Id);
ResponseHelper.End();
}
public static int Add(PointProductOrderInfo entity)
{
return(dal.Add(entity));
}
