|
conn.Execute("INSERT INTO Card
(ID
,Status
,name
,SEX
,Certificate
,CertificateNo
,Birthday
,Address
,SaleTime
,BarNo
,labelNub
,fate
,OnlienDate)
VALUES
('"+string.right(winform.sn.text,10) /*ID*/
+"','"+666 /*Status*/
+"','"+winform.name_edit.text /*name*/
+"','"+男 /*SEX*/
+"','"+1 /*Certificate证件类型*/
+"','"+winform.sn.text /*CertificateNo证件号码*/
+"','"+string.slice(winform.sn.text,7,14) /*Birthday*/
+"','"+rrrrrrrrr /*Address*/
+"','"+time() /*SaleTime*/
+"','"+ 2310232010 /*BarNo*/
+"','"+string.right(winform.sn.text,12) /*labelNub*/
+"','"+10 /*fate*/
+"','"+time() /*OnlienDate*/
+"')");
|
|