## 技术栈
Appgallery connect
## 开发准备
上一节我们实现了兑换提交前的准备页面，向用户展示了兑换相关的所有信息，这一节我们就可以实现兑换订单的提交了
## 功能分析
订单提交我们需要创建对应的兑换商品订单提交信息表，我们需要把地址，商品信息，积分，备注，订单状态，订单创建时间，订单取消时间，订完完成时间等信息都进行存储
## 代码实现
首先我们创建兑换订单表
```css
{
"objectTypeName": "points_order_info",
"fields": [
{"fieldName": "id", "fieldType": "Integer", "notNull": true, "belongPrimaryKey": true},
{"fieldName": "user_id", "fieldType": "String"},
{"fieldName": "order_code", "fieldType": "String"},
{"fieldName": "name", "fieldType": "String"},
{"fieldName": "points", "fieldType": "Double"},
{"fieldName": "msg", "fieldType": "String"},
{"fieldName": "amount", "fieldType": "Integer"},
{"fieldName": "nike_name", "fieldType": "String"},
{"fieldName": "address", "fieldType": "String"},
{"fieldName": "phone", "fieldType": "String"},
{"fieldName": "crete_time", "fieldType": "String"},
{"fieldName": "cancel_time", "fieldType": "String"},
{"fieldName": "over_time", "fieldType": "String"},
{"fieldName": "success_time", "fieldType": "String"},
{"fieldName": "order_type", "fieldType": "Integer"}
],
"indexes": [
{"indexName": "field1Index", "indexList": [{"fieldName":"id","sortType":"ASC"}]}
],
"permissions": [
{"role": "World", "rights": ["Read", "Upsert", "Delete"]},
{"role": "Authenticated", "rights": ["Read", "Upsert", "Delete"]},
{"role": "Creator", "rights": ["Read", "Upsert", "Delete"]},
{"role": "Administrator", "rights": ["Read", "Upsert", "Delete"]}
]
}
```
实体
```css
class PointsOrderInfo {
id: number;
user_id: string;
order_code: string;
name: string;
points: number;
msg: string;
amount: number;
nike_name: string;
address: string;
phone: string;
crete_time: string;
cancel_time: string;
over_time: string;
success_time: string;
order_type: number;
constructor() {
}
setId(id: number): void {
this.id = id;
}
getId(): number {
return this.id;
}
setUser_id(user_id: string): void {
this.user_id = user_id;
}
getUser_id(): string {
return this.user_id;
}
setOrder_code(order_code: string): void {
this.order_code = order_code;
}
getOrder_code(): string {
return this.order_code;
}
setName(name: string): void {
this.name = name;
}
getName(): string {
return this.name;
}
setPoints(points: number): void {
this.points = points;
}
getPoints(): number {
return this.points;
}
setMsg(msg: string): void {
this.msg = msg;
}
getMsg(): string {
return this.msg;
}
setAmount(amount: number): void {
this.amount = amount;
}
getAmount(): number {
return this.amount;
}
setNike_name(nike_name: string): void {
this.nike_name = nike_name;
}
getNike_name(): string {
return this.nike_name;
}
setAddress(address: string): void {
this.address = address;
}
getAddress(): string {
return this.address;
}
setPhone(phone: string): void {
this.phone = phone;
}
getPhone(): string {
return this.phone;
}
setCrete_time(crete_time: string): void {
this.crete_time = crete_time;
}
getCrete_time(): string {
return this.crete_time;
}
setCancel_time(cancel_time: string): void {
this.cancel_time = cancel_time;
}
getCancel_time(): string {
return this.cancel_time;
}
setOver_time(over_time: string): void {
this.over_time = over_time;
}
getOver_time(): string {
return this.over_time;
}
setSuccess_time(success_time: string): void {
this.success_time = success_time;
}
getSuccess_time(): string {
return this.success_time;
}
setOrder_type(order_type: number): void {
this.order_type = order_type;
}
getOrder_type(): number {
return this.order_type;
}
}
export { PointsOrderInfo };
```
db类
```css
import { cloudDatabase } from '@kit.CloudFoundationKit';
class points_order_info extends cloudDatabase.DatabaseObject {
public id: number;
public user_id: string;
public order_code: string;
public name: string;
public points: number;
public msg: string;
public amount: number;
public nike_name: string;
public address: string;
public phone: string;
public crete_time: string;
public cancel_time: string;
public over_time: string;
public success_time: string;
public order_type: number;
public naturalbase_ClassName(): string {
return 'points_order_info';
}
}
export { points_order_info };
```
然后我们开始提交数据
```css
Text("确认兑换")
.fontColor(Color.White)
.padding(10)
.borderRadius(10)
.backgroundColor("#d81e06")
.fontSize(14)
.onClick(async ()=>{
if (this.addressInfo!=null) {
let order=new points_order_info()
order.id=Math.floor(Math.random() * 1000000)
order.user_id=String(this.user!.user_id)
order.order_code=Math.floor(Math.random() * 1000000)+"1013"
order.url=this.pointsProduct!.url
order.name=this.pointsProduct!.name
order.points=this.pointsProduct!.points
if (this.remark!='') {
order.msg=this.remark
}else {
order.msg="无"
}
order.amount=1
order.nike_name=this.addressInfo.nikeName
order.address=this.addressInfo.address
order.phone=this.addressInfo.phone
order.crete_time=this.thisTime()
let num = await databaseZone.upsert(order);
if (num>0) {
showToast("兑换成功")
}
}else {
showToast("请选择地址")
}
})
```
到这里我们的兑换订单提交就完成了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70046889/viewspace-3089320/ ，如需转载，请注明出处，否则将追究法律责任。
