MySQL操作程序二十四(OWNER1專(zhuān)用Paymentid的修改)
返回
- 數(shù)據(jù)庫(kù)操作
- 修改mscenq1_start.pl
- 修改選擇船公司時(shí)自動(dòng)改paymentid
<![CDATA[
數(shù)據(jù)庫(kù)操作
mysql> select * from enq2_payment;
+----+--------------------------------------------------+
| id | PAYMENT |
+----+--------------------------------------------------+
| 1 | T/T At sight after recept of invoice & documents |
| 2 | IN ADVANCED |
| 3 | T/T Before shipment |
| 4 | 50% On order, 50% after shipment |
+----+--------------------------------------------------+
4 rows in set (0.00 sec)
mysql> INSERT INTO eqn2_payment (PAYMENT) VALUES('T/T 10 days after B/L date');
ERROR 1146 (42S02): Table 'cookbook.eqn2_payment' doesn't exist
mysql> INSERT INTO enq2_payment (PAYMENT) VALUES('T/T 10 days after B/L date');
Query OK, 1 row affected (0.20 sec)
mysql> select * from enq2_payment;
+----+--------------------------------------------------+
| id | PAYMENT |
+----+--------------------------------------------------+
| 1 | T/T At sight after recept of invoice & documents |
| 2 | IN ADVANCED |
| 3 | T/T Before shipment |
| 4 | 50% On order, 50% after shipment |
| 5 | T/T 10 days after B/L date |
+----+--------------------------------------------------+
5 rows in set (0.00 sec)
]]>
<![CDATA[
修改mscenq1_start.pl
# 寫(xiě)入quo2操作
$t{sql} = "INSERT INTO quo2 (";
$t{sql} .= 'time,ORIGINid,PRICEid,PAYMENTid,money,percent0,discount0,percent,discount,price,disc0,disc,price0) VALUES(';
$t{sql} .= '"' . $t{time1} . '"';
#$t{sql} .= ',"1","1","1","1","115","100","P1","D","P2","100","D0","P0")';
$t{sql} .= ',"1","1","5","1","115","100","P1","D","P2","100","D0","P0")'; # 1改為5
$t{insert} = $self->dbh->do("$t{sql}");
]]>
<![CDATA[
修改選擇船公司時(shí)自動(dòng)改paymentid
增加mscenq1.pl的u_header部分
} elsif ($t{item} eq 'owner' && $t{id2} != 1 ) {
$t{sql} = 'UPDATE quo2 set PAYMENTid = 1 where id = ';
$t{sql} .= $t{enq1_id};
$t{DO} = $self->dbh->do($t{sql});
} elsif ($t{item} eq 'owner' && $t{id2} == 1 ) {
$t{sql} = 'UPDATE quo2 set PAYMENTid = 5 where id = ';
$t{sql} .= $t{enq1_id};
$t{DO} = $self->dbh->do($t{sql});
}
]]>
返回
江孜县|
鹿泉市|
鱼台县|
桃园县|
全州县|
民丰县|
且末县|
云林县|
辽源市|
柏乡县|
革吉县|
吐鲁番市|
甘肃省|
清河县|
黄平县|
汤阴县|
清河县|
丰顺县|
化德县|
抚远县|
南开区|
西林县|
竹北市|
兖州市|
绵竹市|
孟津县|
乌鲁木齐市|
那曲县|
高雄市|
洛川县|
庆阳市|
大丰市|
新兴县|
弥渡县|
河津市|
万全县|
蒙城县|
凤庆县|
微博|
银川市|
黔东|