kingofhawks/yyapi

通过backid,将收款帐户信息写入uportal库中的t_hg_pay表中

Closed this issue · 1 comments

通过backid,将收款帐户信息写入uportal库中的t_hg_pay表中

CREATE TABLE uportal.t_hg_pay
(
Id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
transportno varchar(25),
paytype varchar(25),
bank varchar(50),
bankno varchar(25),
khname varchar(25),
wxname varchar(30),
zhifubaoname varchar(40),
status varchar(25),
money varchar(25),
creater varchar(25),
createtime datetime,
operator varchar(25),
paytime datetime,
discription varchar(255),
fj varchar(255),
backid varchar(30)
);
INSERT INTO uportal.t_hg_pay (Id, transportno, paytype, bank, bankno, khname, wxname, zhifubaoname, status, money, creater, createtime, operator, paytime, discription, fj, backid) VALUES (16, 'SO2001101138694287877', '银行转帐', '上海农商银行六里支行', '6224781320358882', '杨钰珺', null, null, null, null, '周波', '2020-01-14 14:22:44', null, null, null, null, 'hg1620261786202001140222');
INSERT INTO uportal.t_hg_pay (Id, transportno, paytype, bank, bankno, khname, wxname, zhifubaoname, status, money, creater, createtime, operator, paytime, discription, fj, backid) VALUES (17, 'SF1007113356004', '银行转帐', '北京农商银行丰台支行营业部', '6210666166009922553', '张亚辉', null, null, null, null, '刘倩-三部', '2020-01-16 14:08:52', null, null, null, null, null);
INSERT INTO uportal.t_hg_pay (Id, transportno, paytype, bank, bankno, khname, wxname, zhifubaoname, status, money, creater, createtime, operator, paytime, discription, fj, backid) VALUES (18, 'SF1007113356004', '银行转帐', '北京农商银行丰台支行营业部', '6210666166009922553', '张亚辉', null, null, null, null, '刘倩-三部', '2020-01-16 15:19:18', null, null, null, null, null);
INSERT INTO uportal.t_hg_pay (Id, transportno, paytype, bank, bankno, khname, wxname, zhifubaoname, status, money, creater, createtime, operator, paytime, discription, fj, backid) VALUES (19, 'SF1007113356004', null, null, null, null, null, null, '待支付', '0', '周波', '2020-01-20 11:15:58', null, null, null, null, null);