/// <summary> /// 修改购买订单处理结果 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateOrderResult(CouponBuyModel model) { const string sql = @"update coupon_order set result=@result,resultdesc=@resultdesc,modifiedtime=@modifiedtime where innerid=@innerid;"; try { Helper.Execute(sql, new { model.innerid, model.result, model.resultdesc, modifiedtime = DateTime.Now }); return 1; } catch (Exception ex) { return 0; } }
/// <summary> /// 保存购买订单信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SaveOrder(CouponBuyModel model) { const string sql = @"INSERT INTO coupon_order (innerid, order_id, order_status, order_total_price, order_create_time, order_express_price, buyer_openid, buyer_nick, receiver_name, receiver_province, receiver_city, receiver_address, receiver_mobile, receiver_phone, product_id, product_name, product_price, product_sku, product_count, product_img, delivery_id, delivery_company, trans_id, result,resultdesc,createdtime) VALUES (@innerid, @order_id, @order_status, @order_total_price, @order_create_time, @order_express_price, @buyer_openid, @buyer_nick, @receiver_name, @receiver_province, @receiver_city,@receiver_address, @receiver_mobile, @receiver_phone, @product_id, @product_name, @product_price, @product_sku, @product_count, @product_img, @delivery_id, @delivery_company, @trans_id, @result,@resultdesc,@createdtime);"; try { Helper.Execute(sql, new { model.innerid, model.Order.order_id, model.Order.order_status, model.Order.order_total_price, model.Order.order_create_time, model.Order.order_express_price, model.Order.buyer_openid, model.Order.buyer_nick, model.Order.receiver_name, model.Order.receiver_province, model.Order.receiver_city, model.Order.receiver_address, model.Order.receiver_mobile, model.Order.receiver_phone, model.Order.product_id, model.Order.product_name, model.Order.product_price, model.Order.product_sku, model.Order.product_count, model.Order.product_img, model.Order.delivery_id, model.Order.delivery_company, model.Order.trans_id, model.result, model.resultdesc, createdtime = DateTime.Now }); return 1; } catch (Exception ex) { return 0; } }