/** 1、普通电子发票 2、电子发票专票3、普通纸质发票4、专用纸质发票5、普通纸质卷票发票 12、机动车 15、通行费 26、全电普票27、全电专票
  这些发票的价税合计金额小于0，则升级后值为红字发票；价税合计金额大于等于0，则升级后值为蓝字发票。 **/
update t_er_invoiceinfo set fisred = '1' where ftotalamount < 0 and finvoicetype in ('1', '2', '3', '4', '12', '15', '26', '27');
update t_er_pubreiminvoiceinfo set fisred = '1' where ftotalamount < 0 and finvoicetype in ('1', '2', '3', '4', '12', '15', '26', '27');
update t_er_invoiceinfocp set fisred = '1' where ftotalamount < 0 and finvoicetype in ('1', '2', '3', '4', '12', '15', '26', '27');
update t_er_invoicepoolinfo set fisred = '1' where ftotalamount < 0 and finvoicetype in ('1', '2', '3', '4', '12', '15', '26', '27');