public string toSaveSqlString()
{
String sqlString = "INSERT into tradelog (nozzleno,meterialcode,volume,realamount,price,starttime,endtime,startread,endread," +
"carnumber,carbrand,subbrand,cartype,carcolor,carnumcolor,realcarbrand,realsubbrand,oilname,oilcode,oilclass)" +
"VALUES({0}, '{1}', {2}, {3}, {4}, '{5}', '{6}', {7}, {8}, '{9}', {10}, {11},{12},{13},{14},'{15}', '{16}','{17}','{18}','{19}') ";
return(String.Format(sqlString, OilGun_NO, OIL_TYPE, OIL_Q.ToString(), OIL_AMT.ToString(), OIL_PRC.ToString(), START_TIME, END_TIME, START_READ.ToString(),
END_READ.ToString(), VehicleNo, VehicleBrandCode, SubBrandCode, VehicleModel, VehicleColor, BodyColor, CarBrand, SubBrand, OilName, OilCode, OilClass));
}
public string toSaveSqlString()
{
String sqlString = "INSERT into orderlog (transtype,transcode,meterialcode,volume,realamount,price,paytime,settledate,nozzleno," +
"startread,endread,billno,billitemid,posno,statustype,paycode,tradeid)" +
"VALUES('{0}','{1}','{2}', {3}, {4}, {5}, '{6}', '{7}', {8}, {9}, {10}, {11},{12},'{13}','{14}','{15}',{16}) ";
return(String.Format(sqlString, TRANS_TYPE, TRANS_CODE, BAR_CODE, TRANS_Q.ToString(), TRANS_AMT.ToString(), TRANS_PRC.ToString(),
FINISH_TIME, SETTLE_DAY, OilGun_NO.ToString(), START_READ.ToString(), END_READ.ToString(), BILL_NUM.ToString(),
BILL_ITEM_ID.ToString(), POS_NO, StatusType, Pumpsrv_ref, TRADE_ID.ToString()));
}
