String sql = string.Format(@"select OID as'订单号',OrderName as '订单别名',FUNType as '方案商',
TXMID as'条码方案编号',MakeDate as '生产日期',Count as '数量',ReMark as '备注',
VIPP_01 as '采集点1',VIPP_01_SU_ID as '方案准备1',VIPP_02 as '采集点2',VIPP_02_SU_ID as '方案准备2',
VIPP_03 as '采集点3',VIPP_03_SU_ID as '方案准备3',VIPP_04 as '采集点4',VIPP_04_SU_ID as '方案准备4',
VIPP_05 as '采集点5',VIPP_05_SU_ID as '方案准备5',VIPP_06 as '采集点6',VIPP_06_SU_ID as '方案准备6',
VIPP_07 as '采集点7',VIPP_07_SU_ID as '方案准备7',VIPP_08 as '采集点8',VIPP_08_SU_ID as '方案准备8',
VIPP_09 as '采集点9',VIPP_09_SU_ID as '方案准备9',VIPP_10 as '采集点10',VIPP_10_SU_ID as '方案准备10',
VIPP_11 as '采集点11',VIPP_11_SU_ID as '方案准备11',VIPP_12 as '采集点12',VIPP_12_SU_ID as '方案准备12'from OrderDetail");
TXMID as'条码方案编号',MakeDate as '生产日期',Count as '数量',ReMark as '备注',
VIPP_01 as '采集点1',VIPP_01_SU_ID as '方案准备1',VIPP_02 as '采集点2',VIPP_02_SU_ID as '方案准备2',
VIPP_03 as '采集点3',VIPP_03_SU_ID as '方案准备3',VIPP_04 as '采集点4',VIPP_04_SU_ID as '方案准备4',
VIPP_05 as '采集点5',VIPP_05_SU_ID as '方案准备5',VIPP_06 as '采集点6',VIPP_06_SU_ID as '方案准备6',
VIPP_07 as '采集点7',VIPP_07_SU_ID as '方案准备7',VIPP_08 as '采集点8',VIPP_08_SU_ID as '方案准备8',
VIPP_09 as '采集点9',VIPP_09_SU_ID as '方案准备9',VIPP_10 as '采集点10',VIPP_10_SU_ID as '方案准备10',
VIPP_11 as '采集点11',VIPP_11_SU_ID as '方案准备11',VIPP_12 as '采集点12',VIPP_12_SU_ID as '方案准备12'from OrderDetail");