-
Notifications
You must be signed in to change notification settings - Fork 0
/
Constraint.cs
72 lines (67 loc) · 36.4 KB
/
Constraint.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
namespace MetroUITest
{
class Constraint
{
private static string TABLE_JBXX = "select 'insert into JBXX (ID,RYBH,JSBH,XM,XMPY,BM,XB,CSRQ,ZJLX,ZJH,HYZK,MZ,GJ,HJD,HJDXZ,XZDXZ,WHCD,ZY,GZDW,SF,TSSF,DH,RSRQ,RSXZ,ZRDW,SYDW,SYR,SYPZ,JYRQ,GYQX,AY,CYLX,BAHJ,BAR,JSH,RYGLLB,ZSZT,SCBZ,BZ,DAH,DWLX,CSSJ,TSBJ,ZZMM,CSYY,XQ,HX,HXQX,CLJG,FJX,BADW,ZWBH,JG,XZD,CSQX,FZJL,JYAQ,CAAJ,BHLX,SY,JLRQ,DBRQ,PWH,ZC,LSFH,WXDJ,ZYRYXGQK,BYZD,JKZK,CREATETIME,SNBH,OPERATOR,SYPZWSH,AQDJ,ZUC,SG,BMTY,STATE,SAVETIME,WBRYBH,GCBH,EMLX,ZDZY,JJ,JB,LDF,YGRY,ZYAF,BARJH,JSLY,ZZQSRQ,GRJL,AZB,LSCSYY,JSLX,JSHJ,CN_CXBH,XHAY,DAGDBJ,JYGZZLPG,JY,CLSYPZR,JARQ,ZDAJ) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(XM,Null,'Null',''''||XM||'''')||','||decode(XMPY,Null,'Null',''''||XMPY||'''')||','||decode(BM,Null,'Null',''''||BM||'''')||','||decode(XB,Null,'Null',''''||XB||'''')||','||decode(CSRQ,Null,'Null','to_date('''||to_char(CSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(ZJLX,Null,'Null',''''||ZJLX||'''')||','||decode(ZJH,Null,'Null',''''||ZJH||'''')||','||decode(HYZK,Null,'Null',''''||HYZK||'''')||','||decode(MZ,Null,'Null',''''||MZ||'''')||','||decode(GJ,Null,'Null',''''||GJ||'''')||','||decode(HJD,Null,'Null',''''||HJD||'''')||','||decode(HJDXZ,Null,'Null',''''||HJDXZ||'''')||','||decode(XZDXZ,Null,'Null',''''||XZDXZ||'''')||','||decode(WHCD,Null,'Null',''''||WHCD||'''')||','||decode(ZY,Null,'Null',''''||ZY||'''')||','||decode(GZDW,Null,'Null',''''||GZDW||'''')||','||decode(SF,Null,'Null',''''||SF||'''')||','||decode(TSSF,Null,'Null',''''||TSSF||'''')||','||decode(DH,Null,'Null',''''||DH||'''')||','||decode(RSRQ,Null,'Null','to_date('''||to_char(RSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(RSXZ,Null,'Null',''''||RSXZ||'''')||','||decode(ZRDW,Null,'Null',''''||ZRDW||'''')||','||decode(SYDW,Null,'Null',''''||SYDW||'''')||','||decode(SYR,Null,'Null',''''||SYR||'''')||','||decode(SYPZ,Null,'Null',''''||SYPZ||'''')||','||decode(JYRQ,Null,'Null','to_date('''||to_char(JYRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(GYQX,Null,'Null','to_date('''||to_char(GYQX,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(AY,Null,'Null',''''||AY||'''')||','||decode(CYLX,Null,'Null',''''||CYLX||'''')||','||decode(BAHJ,Null,'Null',''''||BAHJ||'''')||','||decode(BAR,Null,'Null',''''||BAR||'''')||','||decode(JSH,Null,'Null',''''||JSH||'''')||','||decode(RYGLLB,Null,'Null',''''||RYGLLB||'''')||','||decode(ZSZT,Null,'Null',''''||ZSZT||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(DAH,Null,'Null',''''||DAH||'''')||','||decode(DWLX,Null,'Null',''''||DWLX||'''')||','||decode(CSSJ,Null,'Null','to_date('''||to_char(CSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(TSBJ,Null,'Null',''''||TSBJ||'''')||','||decode(ZZMM,Null,'Null',''''||ZZMM||'''')||','||decode(CSYY,Null,'Null',''''||CSYY||'''')||','||decode(XQ,Null,'Null',''''||XQ||'''')||','||decode(HX,Null,'Null',''''||HX||'''')||','||decode(HXQX,Null,'Null',''''||HXQX||'''')||','||decode(CLJG,Null,'Null',''''||CLJG||'''')||','||decode(FJX,Null,'Null',''''||FJX||'''')||','||decode(BADW,Null,'Null',''''||BADW||'''')||','||decode(ZWBH,Null,'Null',''''||ZWBH||'''')||','||decode(JG,Null,'Null',''''||JG||'''')||','||decode(XZD,Null,'Null',''''||XZD||'''')||','||decode(CSQX,Null,'Null',''''||CSQX||'''')||','||decode(FZJL,Null,'Null',''''||FZJL||'''')||','||decode(JYAQ,Null,'Null',''''||JYAQ||'''')||','||decode(CAAJ,Null,'Null',''''||CAAJ||'''')||','||decode(BHLX,Null,'Null',''''||BHLX||'''')||','||decode(SY,Null,'Null',''''||SY||'''')||','||decode(JLRQ,Null,'Null','to_date('''||to_char(JLRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(DBRQ,Null,'Null','to_date('''||to_char(DBRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(PWH,Null,'Null',''''||PWH||'''')||','||decode(ZC,Null,'Null',''''||ZC||'''')||','||decode(LSFH,Null,'Null',''''||LSFH||'''')||','||decode(WXDJ,Null,'Null',''''||WXDJ||'''')||','||decode(ZYRYXGQK,Null,'Null',''''||ZYRYXGQK||'''')||','||decode(BYZD,Null,'Null',''''||BYZD||'''')||','||decode(JKZK,Null,'Null',''''||JKZK||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SNBH,Null,'Null',''''||SNBH||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(SYPZWSH,Null,'Null',''''||SYPZWSH||'''')||','||decode(AQDJ,Null,'Null',''''||AQDJ||'''')||','||decode(ZUC,Null,'Null',''''||ZUC||'''')||','||decode(SG,Null,'Null',''''||SG||'''')||','||decode(BMTY,Null,'Null',''''||BMTY||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(WBRYBH,Null,'Null',''''||WBRYBH||'''')||','||decode(GCBH,Null,'Null',''''||GCBH||'''')||','||decode(EMLX,Null,'Null',''''||EMLX||'''')||','||decode(ZDZY,Null,'Null',''''||ZDZY||'''')||','||decode(JJ,Null,'Null',''''||JJ||'''')||','||decode(JB,Null,'Null',''''||JB||'''')||','||decode(LDF,Null,'Null',''''||LDF||'''')||','||decode(YGRY,Null,'Null',''''||YGRY||'''')||','||decode(ZYAF,Null,'Null',''''||ZYAF||'''')||','||decode(BARJH,Null,'Null',''''||BARJH||'''')||','||decode(JSLY,Null,'Null',''''||JSLY||'''')||','||decode(ZZQSRQ,Null,'Null','to_date('''||to_char(ZZQSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(GRJL,Null,'Null',''''||GRJL||'''')||','||decode(AZB,Null,'Null',''''||AZB||'''')||','||decode(LSCSYY,Null,'Null',''''||LSCSYY||'''')||','||decode(JSLX,Null,'Null',''''||JSLX||'''')||','||decode(JSHJ,Null,'Null',''''||JSHJ||'''')||','||decode(CN_CXBH,Null,'Null',''''||CN_CXBH||'''')||','||decode(XHAY,Null,'Null',''''||XHAY||'''')||','||decode(DAGDBJ,Null,'Null',''''||DAGDBJ||'''')||','||decode(JYGZZLPG,Null,'Null',''''||JYGZZLPG||'''')||','||decode(JY,Null,'Null',''''||JY||'''')||','||decode(CLSYPZR,Null,'Null',''''||CLSYPZR||'''')||','||decode(JARQ,Null,'Null','to_date('''||to_char(JARQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(ZDAJ,Null,'Null',''''||ZDAJ||'''')||');' from JBXX where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ; ";
private static string TABLE_JCJL = "select 'insert into JCJL (ID,RYBH,JCRQ,GJMJ,LY,GJYJ,BZ,OPERATOR,CREATETIME,SCBZ,STATE,JSBH,JKF,LYDM) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(JCRQ,Null,'Null','to_date('''||to_char(JCRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(GJMJ,Null,'Null',''''||GJMJ||'''')||','||decode(LY,Null,'Null',''''||LY||'''')||','||decode(GJYJ,Null,'Null',''''||GJYJ||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(JKF,Null,'Null',JKF)||','||decode(LYDM,Null,'Null',''''||LYDM||'''')||');' from JCJL where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ; ";
private static string TABLE_JJ = "select 'insert into JJ (ID,JSBH,RYBH,LY,XJMC,JJSL,BLR,BLRQ,KSSJ,SYTS,JSSJ,BZ,PSBZ,BLLX,YWLCSYID,PASTABLE,SCBZ,OPERATOR,CREATETIME,STATE,YSYJ,ZDZYJ,LDYJ,LSH) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(LY,Null,'Null',''''||LY||'''')||','||decode(XJMC,Null,'Null',''''||XJMC||'''')||','||decode(JJSL,Null,'Null',JJSL)||','||decode(BLR,Null,'Null',''''||BLR||'''')||','||decode(BLRQ,Null,'Null','to_date('''||to_char(BLRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(KSSJ,Null,'Null','to_date('''||to_char(KSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SYTS,Null,'Null',SYTS)||','||decode(JSSJ,Null,'Null','to_date('''||to_char(JSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(PSBZ,Null,'Null',''''||PSBZ||'''')||','||decode(BLLX,Null,'Null',''''||BLLX||'''')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||','||decode(PASTABLE,Null,'Null',''''||PASTABLE||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(YSYJ,Null,'Null',''''||YSYJ||'''')||','||decode(ZDZYJ,Null,'Null',''''||ZDZYJ||'''')||','||decode(LDYJ,Null,'Null',''''||LDYJ||'''')||','||decode(LSH,Null,'Null',''''||LSH||'''')||');' from JJ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_SWDJ = "select 'insert into SWDJ (ID,RYBH,SWSJ,SWDD,SWYY,CLQK,SCBZ,SWLX,OPERATOR,CREATETIME,STATE,JSBH,SJZL_JSBZ,SAVETIME) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(SWSJ,Null,'Null','to_date('''||to_char(SWSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SWDD,Null,'Null',''''||SWDD||'''')||','||decode(SWYY,Null,'Null',''''||SWYY||'''')||','||decode(CLQK,Null,'Null',''''||CLQK||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(SWLX,Null,'Null',''''||SWLX||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||');' from SWDJ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_TPDJ = "select 'insert into TPDJ (ID,RYBH,TPSJ,TPDD,TPYY,CLJG,ZRR,BZ,SCBZ,OPERATOR,CREATETIME,STATE,JSBH,SJZL_JSBZ,SAVETIME) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(TPSJ,Null,'Null','to_date('''||to_char(TPSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(TPDD,Null,'Null',''''||TPDD||'''')||','||decode(TPYY,Null,'Null',''''||TPYY||'''')||','||decode(CLJG,Null,'Null',''''||CLJG||'''')||','||decode(ZRR,Null,'Null',''''||ZRR||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||');' from TPDJ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_HJBD = "select 'insert into HJBD (ID,RYBH,BDRQ,BAJD,DWLX,BADW,BAR,WSH,GYQX,QSRQ,ZZRQ,CQ,CQYY,PZDW,BZ,SCBZ,OPERATOR,CREATETIME,STATE,YWLCSYID,JSBH) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(BDRQ,Null,'Null','to_date('''||to_char(BDRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(BAJD,Null,'Null',''''||BAJD||'''')||','||decode(DWLX,Null,'Null',''''||DWLX||'''')||','||decode(BADW,Null,'Null',''''||BADW||'''')||','||decode(BAR,Null,'Null',''''||BAR||'''')||','||decode(WSH,Null,'Null',''''||WSH||'''')||','||decode(GYQX,Null,'Null','to_date('''||to_char(GYQX,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(QSRQ,Null,'Null','to_date('''||to_char(QSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(ZZRQ,Null,'Null','to_date('''||to_char(ZZRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(CQ,Null,'Null',''''||CQ||'''')||','||decode(CQYY,Null,'Null',''''||CQYY||'''')||','||decode(PZDW,Null,'Null',''''||PZDW||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||');' from HJBD where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_JJX = "select 'insert into JJX (ID,RYBH,YXMRQ,JJXQ,XMSFRQ,PZWH,PZR,BLRQ,BZ,SCBZ,FLAG,OPERATOR,CREATETIME,STATE,JSBH) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(YXMRQ,Null,'Null','to_date('''||to_char(YXMRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(JJXQ,Null,'Null',''''||JJXQ||'''')||','||decode(XMSFRQ,Null,'Null','to_date('''||to_char(XMSFRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(PZWH,Null,'Null',''''||PZWH||'''')||','||decode(PZR,Null,'Null',''''||PZR||'''')||','||decode(BLRQ,Null,'Null','to_date('''||to_char(BLRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(FLAG,Null,'Null',''''||FLAG||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||');' from JJX where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_FSSG = "select 'insert into FSSG (ID,JSBH,RYBH,QKLX,SGLX,TTSG,FZCSWSG,SGXZ,SJLX,SGSJ,SGDD,SJRY,JYQK,CLJG,SCBZ,STATE,CREATETIME,OPERATOR) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(QKLX,Null,'Null',''''||QKLX||'''')||','||decode(SGLX,Null,'Null',''''||SGLX||'''')||','||decode(TTSG,Null,'Null',''''||TTSG||'''')||','||decode(FZCSWSG,Null,'Null',''''||FZCSWSG||'''')||','||decode(SGXZ,Null,'Null',''''||SGXZ||'''')||','||decode(SJLX,Null,'Null',''''||SJLX||'''')||','||decode(SGSJ,Null,'Null','to_date('''||to_char(SGSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SGDD,Null,'Null',''''||SGDD||'''')||','||decode(SJRY,Null,'Null',''''||SJRY||'''')||','||decode(JYQK,Null,'Null',''''||JYQK||'''')||','||decode(CLJG,Null,'Null',''''||CLJG||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||');' from FSSG where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_LSHJ = "select 'insert into LSHJ (ID,RYBH,LSXM,ZJLX,ZJH,DW,RS,HJSY,HJSJ,JSSJ,SCBZ,PZR,FZMJ,BZ,JSR,YWSHWJWPQK,YCCON,OPERATOR,CREATETIME,STATE,LRMJ,FLAG,JSBH,PASTABLE,SJZL_JSBZ,SAVETIME,YWLCSYID,HJS) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(LSXM,Null,'Null',''''||LSXM||'''')||','||decode(ZJLX,Null,'Null',''''||ZJLX||'''')||','||decode(ZJH,Null,'Null',''''||ZJH||'''')||','||decode(DW,Null,'Null',''''||DW||'''')||','||decode(RS,Null,'Null',RS)||','||decode(HJSY,Null,'Null',''''||HJSY||'''')||','||decode(HJSJ,Null,'Null','to_date('''||to_char(HJSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(JSSJ,Null,'Null','to_date('''||to_char(JSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(PZR,Null,'Null',''''||PZR||'''')||','||decode(FZMJ,Null,'Null',''''||FZMJ||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(JSR,Null,'Null',''''||JSR||'''')||','||decode(YWSHWJWPQK,Null,'Null',''''||YWSHWJWPQK||'''')||','||decode(YCCON,Null,'Null',''''||YCCON||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(LRMJ,Null,'Null',''''||LRMJ||'''')||','||decode(FLAG,Null,'Null',''''||FLAG||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(PASTABLE,Null,'Null',''''||PASTABLE||'''')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||','||decode(HJS,Null,'Null',''''||HJS||'''')||');' from LSHJ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_TSDJ = "select 'insert into TSDJ (ID,RYBH,DW,RY,ZJLX,ZJH,KSSJ,TSZBR,JSSJ,SCBZ,JSR,BZ,DCMJ,YWSHWJWPQK,YCCON,CREATETIME,OPERATOR,STATE,FLAG,PSBZ,PASTABLE,BLLX,JSBH,SJZL_JSBZ,SAVETIME,TSS,YWLCSYID) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(DW,Null,'Null',''''||DW||'''')||','||decode(RY,Null,'Null',''''||RY||'''')||','||decode(ZJLX,Null,'Null',''''||ZJLX||'''')||','||decode(ZJH,Null,'Null',''''||ZJH||'''')||','||decode(KSSJ,Null,'Null','to_date('''||to_char(KSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(TSZBR,Null,'Null',''''||TSZBR||'''')||','||decode(JSSJ,Null,'Null','to_date('''||to_char(JSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(JSR,Null,'Null',''''||JSR||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(DCMJ,Null,'Null',''''||DCMJ||'''')||','||decode(YWSHWJWPQK,Null,'Null',''''||YWSHWJWPQK||'''')||','||decode(YCCON,Null,'Null',''''||YCCON||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(FLAG,Null,'Null',''''||FLAG||'''')||','||decode(PSBZ,Null,'Null',''''||PSBZ||'''')||','||decode(PASTABLE,Null,'Null',''''||PASTABLE||'''')||','||decode(BLLX,Null,'Null',''''||BLLX||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(TSS,Null,'Null',''''||TSS||'''')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||');' from TSDJ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_CLCS = "select 'insert into CLCS (ID,RYBH,CSYY,CSSJ,CSQX,PZDW,PZR,BZ,SCBZ,OPERATOR,CREATETIME,STATE,BLR,JSBH,DBR,DBRDW,JDDW,ZCDWSZD,SAVETIME,SJZL_JSBZ) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(CSYY,Null,'Null',''''||CSYY||'''')||','||decode(CSSJ,Null,'Null','to_date('''||to_char(CSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(CSQX,Null,'Null',''''||CSQX||'''')||','||decode(PZDW,Null,'Null',''''||PZDW||'''')||','||decode(PZR,Null,'Null',''''||PZR||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(BLR,Null,'Null',''''||BLR||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(DBR,Null,'Null',''''||DBR||'''')||','||decode(DBRDW,Null,'Null',''''||DBRDW||'''')||','||decode(JDDW,Null,'Null',''''||JDDW||'''')||','||decode(ZCDWSZD,Null,'Null',''''||ZCDWSZD||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||');' from CLCS where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_TAF = "select 'insert into TAF (ID,RYBH,TAFH,BZ,SCBZ,OPERATOR,CREATETIME,LAH,STATE,JSBH) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(TAFH,Null,'Null',''''||TAFH||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(LAH,Null,'Null',''''||LAH||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||');' from TAF where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_JS = "select 'insert into JS (ID,JSBH,JSMC,JSH,FIELDNAME,CODE,CONTENT,JSLB,TYPE,INNUM,ZGMJ,XGMJ,OPERATOR,CREATETIME,STATE,WMJS,SCBZ) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(JSMC,Null,'Null',''''||JSMC||'''')||','||decode(JSH,Null,'Null',''''||JSH||'''')||','||decode(FIELDNAME,Null,'Null',''''||FIELDNAME||'''')||','||decode(CODE,Null,'Null',''''||CODE||'''')||','||decode(CONTENT,Null,'Null',''''||CONTENT||'''')||','||decode(JSLB,Null,'Null',''''||JSLB||'''')||','||decode(TYPE,Null,'Null',''''||TYPE||'''')||','||decode(INNUM,Null,'Null',''''||INNUM||'''')||','||decode(ZGMJ,Null,'Null',''''||ZGMJ||'''')||','||decode(XGMJ,Null,'Null',''''||XGMJ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(WMJS,Null,'Null',''''||WMJS||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||');' from JS where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_JY = "select 'insert into JY (ID,RYBH,XM,ZDRQ,YS,LY,ZS,ZD,JZYY,CLJG,SWJY,SCBZ,PSBZ,OPERATOR,CREATETIME,STATE,YYZDSJ,YYZDJG,YYZLCS,CSJYLX,PTMJ,FY,BZ,PASTABLE,YWLCSYID,JSBH,HSSJ,BHLX,LDYJ,YPFF,FYKSRQ,FYJSRQ,SJZL_JSBZ,SAVETIME) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(XM,Null,'Null',''''||XM||'''')||','||decode(ZDRQ,Null,'Null','to_date('''||to_char(ZDRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(YS,Null,'Null',''''||YS||'''')||','||decode(LY,Null,'Null',''''||LY||'''')||','||decode(ZS,Null,'Null',''''||ZS||'''')||','||decode(ZD,Null,'Null',''''||ZD||'''')||','||decode(JZYY,Null,'Null',''''||JZYY||'''')||','||decode(CLJG,Null,'Null',''''||CLJG||'''')||','||decode(SWJY,Null,'Null',''''||SWJY||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(PSBZ,Null,'Null',''''||PSBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(YYZDSJ,Null,'Null','to_date('''||to_char(YYZDSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(YYZDJG,Null,'Null',''''||YYZDJG||'''')||','||decode(YYZLCS,Null,'Null',''''||YYZLCS||'''')||','||decode(CSJYLX,Null,'Null',''''||CSJYLX||'''')||','||decode(PTMJ,Null,'Null',''''||PTMJ||'''')||','||decode(FY,Null,'Null',FY)||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(PASTABLE,Null,'Null',''''||PASTABLE||'''')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(HSSJ,Null,'Null','to_date('''||to_char(HSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(BHLX,Null,'Null',''''||BHLX||'''')||','||decode(LDYJ,Null,'Null',''''||LDYJ||'''')||','||decode(YPFF,Null,'Null',''''||YPFF||'''')||','||decode(FYKSRQ,Null,'Null','to_date('''||to_char(FYKSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(FYJSRQ,Null,'Null','to_date('''||to_char(FYJSRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||');' from JY where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_JKQK = "select 'insert into JKQK (ID,GCBH,SG,TZ,XX,XY,RTBW1,FW1,SL1,ZC,TB,JB,XB,FB,BB,DB,SZ,XZ,YY,XZZK,JKZK,JBLL,BRBS,JTBS,CRB,SBQ,YSYJ,JCR,BZ,ZSBW,SCBZ,OPERATOR,CREATETIME,TMTZ1,STATE,JSBH,BHLX,XL,TW,GMS,ZSRQYYY,CQCS,TMTZ2,RTBW2,FW2,SL2,TMTZ3,RTBW3,FW3,SL3,TMTZ4,RTBW4,FW4,SL4,TMTZ5,RTBW5,FW5,SL5,XCG,XDT,BC,ZQ,XP,YLNXRSJC,SDRYDJ,AZBRYJC,TNBRYJC,LXBJC,SJZL_JSBZ,SAVETIME) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(GCBH,Null,'Null',''''||GCBH||'''')||','||decode(SG,Null,'Null',''''||SG||'''')||','||decode(TZ,Null,'Null',''''||TZ||'''')||','||decode(XX,Null,'Null',''''||XX||'''')||','||decode(XY,Null,'Null',''''||XY||'''')||','||decode(RTBW1,Null,'Null',''''||RTBW1||'''')||','||decode(FW1,Null,'Null',''''||FW1||'''')||','||decode(SL1,Null,'Null',''''||SL1||'''')||','||decode(ZC,Null,'Null',''''||ZC||'''')||','||decode(TB,Null,'Null',''''||TB||'''')||','||decode(JB,Null,'Null',''''||JB||'''')||','||decode(XB,Null,'Null',''''||XB||'''')||','||decode(FB,Null,'Null',''''||FB||'''')||','||decode(BB,Null,'Null',''''||BB||'''')||','||decode(DB,Null,'Null',''''||DB||'''')||','||decode(SZ,Null,'Null',''''||SZ||'''')||','||decode(XZ,Null,'Null',''''||XZ||'''')||','||decode(YY,Null,'Null',''''||YY||'''')||','||decode(XZZK,Null,'Null',''''||XZZK||'''')||','||decode(JKZK,Null,'Null',''''||JKZK||'''')||','||decode(JBLL,Null,'Null',''''||JBLL||'''')||','||decode(BRBS,Null,'Null',''''||BRBS||'''')||','||decode(JTBS,Null,'Null',''''||JTBS||'''')||','||decode(CRB,Null,'Null',''''||CRB||'''')||','||decode(SBQ,Null,'Null',''''||SBQ||'''')||','||decode(YSYJ,Null,'Null',''''||YSYJ||'''')||','||decode(JCR,Null,'Null',''''||JCR||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(ZSBW,Null,'Null',''''||ZSBW||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(TMTZ1,Null,'Null',''''||TMTZ1||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(BHLX,Null,'Null',''''||BHLX||'''')||','||decode(XL,Null,'Null',''''||XL||'''')||','||decode(TW,Null,'Null',''''||TW||'''')||','||decode(GMS,Null,'Null',''''||GMS||'''')||','||decode(ZSRQYYY,Null,'Null',''''||ZSRQYYY||'''')||','||decode(CQCS,Null,'Null',''''||CQCS||'''')||','||decode(TMTZ2,Null,'Null',''''||TMTZ2||'''')||','||decode(RTBW2,Null,'Null',''''||RTBW2||'''')||','||decode(FW2,Null,'Null',''''||FW2||'''')||','||decode(SL2,Null,'Null',''''||SL2||'''')||','||decode(TMTZ3,Null,'Null',''''||TMTZ3||'''')||','||decode(RTBW3,Null,'Null',''''||RTBW3||'''')||','||decode(FW3,Null,'Null',''''||FW3||'''')||','||decode(SL3,Null,'Null',''''||SL3||'''')||','||decode(TMTZ4,Null,'Null',''''||TMTZ4||'''')||','||decode(RTBW4,Null,'Null',''''||RTBW4||'''')||','||decode(FW4,Null,'Null',''''||FW4||'''')||','||decode(SL4,Null,'Null',''''||SL4||'''')||','||decode(TMTZ5,Null,'Null',''''||TMTZ5||'''')||','||decode(RTBW5,Null,'Null',''''||RTBW5||'''')||','||decode(FW5,Null,'Null',''''||FW5||'''')||','||decode(SL5,Null,'Null',''''||SL5||'''')||','||decode(XCG,Null,'Null',''''||XCG||'''')||','||decode(XDT,Null,'Null',''''||XDT||'''')||','||decode(BC,Null,'Null',''''||BC||'''')||','||decode(ZQ,Null,'Null',''''||ZQ||'''')||','||decode(XP,Null,'Null',''''||XP||'''')||','||decode(YLNXRSJC,Null,'Null',''''||YLNXRSJC||'''')||','||decode(SDRYDJ,Null,'Null',''''||SDRYDJ||'''')||','||decode(AZBRYJC,Null,'Null',''''||AZBRYJC||'''')||','||decode(TNBRYJC,Null,'Null',''''||TNBRYJC||'''')||','||decode(LXBJC,Null,'Null',''''||LXBJC||'''')||','||decode(SJZL_JSBZ,Null,'Null',''''||SJZL_JSBZ||'''')||','||decode(SAVETIME,Null,'Null','to_date('''||to_char(SAVETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||');' from JKQK where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_JQ = "select 'insert into JQ (ID,JSBH,JQH,JQICONS,BZ,OPERATOR,CREATETIME,STATE) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(JQH,Null,'Null',''''||JQH||'''')||','||decode(JQICONS,Null,'Null',''''||JQICONS||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||');' from JQ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_LSCS = "select 'insert into LSCS (ID,RYBH,BLSJ,LRMJ,CSYY,CSSJ,HSSJ,PZR,BADW,DCMJ,BZ,SCBZ,SJMJ,CREATETIME,OPERATOR,YWSHWJWPQK,YCQK,STATE,FLAG,YWLCSYID,BLLX,PASTABLE,PSBZ,JSBH,LDYJ) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(BLSJ,Null,'Null','to_date('''||to_char(BLSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(LRMJ,Null,'Null',''''||LRMJ||'''')||','||decode(CSYY,Null,'Null',''''||CSYY||'''')||','||decode(CSSJ,Null,'Null','to_date('''||to_char(CSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(HSSJ,Null,'Null','to_date('''||to_char(HSSJ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(PZR,Null,'Null',''''||PZR||'''')||','||decode(BADW,Null,'Null',''''||BADW||'''')||','||decode(DCMJ,Null,'Null',''''||DCMJ||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(SJMJ,Null,'Null',''''||SJMJ||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(YWSHWJWPQK,Null,'Null',''''||YWSHWJWPQK||'''')||','||decode(YCQK,Null,'Null',''''||YCQK||'''')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(FLAG,Null,'Null',''''||FLAG||'''')||','||decode(YWLCSYID,Null,'Null',''''||YWLCSYID||'''')||','||decode(BLLX,Null,'Null',''''||BLLX||'''')||','||decode(PASTABLE,Null,'Null',''''||PASTABLE||'''')||','||decode(PSBZ,Null,'Null',''''||PSBZ||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(LDYJ,Null,'Null',''''||LDYJ||'''')||');' from LSCS where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_YQ = "select 'insert into YQ (ID,RYBH,YGYQX,XGYQX,YQYY,BLRQ,FLWSH,PZR,PZDW,BZ,SCBZ,OPERATOR,CREATETIME,STATE,JSBH,BAHJ) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(YGYQX,Null,'Null','to_date('''||to_char(YGYQX,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(XGYQX,Null,'Null','to_date('''||to_char(XGYQX,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(YQYY,Null,'Null',''''||YQYY||'''')||','||decode(BLRQ,Null,'Null','to_date('''||to_char(BLRQ,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(FLWSH,Null,'Null',''''||FLWSH||'''')||','||decode(PZR,Null,'Null',''''||PZR||'''')||','||decode(PZDW,Null,'Null',''''||PZDW||'''')||','||decode(BZ,Null,'Null',''''||BZ||'''')||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(BAHJ,Null,'Null',''''||BAHJ||'''')||');' from YQ where createtime>=to_date('exportBeginDate','yyyy-MM-dd') and createtime< (to_date('exportEndDate','yyyy-MM-dd')+1) ;";
private static string TABLE_KSS = "select 'insert into KSS (ID,JSBH,KSSMC,DZ,DQ,DH,CZ,YZBM,EMAIL,NET,LDXM,DJ,GM,RS,BZRS,JSS,RL,SCBZ,VERSION,KSSJC,ENABLE) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(KSSMC,Null,'Null',''''||KSSMC||'''')||','||decode(DZ,Null,'Null',''''||DZ||'''')||','||decode(DQ,Null,'Null',''''||DQ||'''')||','||decode(DH,Null,'Null',''''||DH||'''')||','||decode(CZ,Null,'Null',''''||CZ||'''')||','||decode(YZBM,Null,'Null',''''||YZBM||'''')||','||decode(EMAIL,Null,'Null',''''||EMAIL||'''')||','||decode(NET,Null,'Null',''''||NET||'''')||','||decode(LDXM,Null,'Null',''''||LDXM||'''')||','||decode(DJ,Null,'Null',''''||DJ||'''')||','||decode(GM,Null,'Null',''''||GM||'''')||','||decode(RS,Null,'Null',RS)||','||decode(BZRS,Null,'Null',BZRS)||','||decode(JSS,Null,'Null',JSS)||','||decode(RL,Null,'Null',RL)||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(VERSION,Null,'Null',''''||VERSION||'''')||','||decode(KSSJC,Null,'Null',''''||KSSJC||'''')||','||decode(ENABLE,Null,'Null',''''||ENABLE||'''')||');' from KSS ;";
// private static string TABLE_PHOTOS = "select 'insert into PHOTOS (ID,RYBH,PHOTO,SCBZ,CREATETIME,STATE,OPERATOR,YWZP,JSBH,TYPE) values ('||decode(ID,Null,'Null',''''||ID||'''')||','||decode(RYBH,Null,'Null',''''||RYBH||'''')||','||decode(PHOTO,Null,'Null',PHOTO)||','||decode(SCBZ,Null,'Null',''''||SCBZ||'''')||','||decode(CREATETIME,Null,'Null','to_date('''||to_char(CREATETIME,'mm/dd/yyyy hh24:mi')||''',''mm/dd/yyyy hh24:mi'')')||','||decode(STATE,Null,'Null',''''||STATE||'''')||','||decode(OPERATOR,Null,'Null',''''||OPERATOR||'''')||','||decode(YWZP,Null,'Null',''''||YWZP||'''')||','||decode(JSBH,Null,'Null',''''||JSBH||'''')||','||decode(TYPE,Null,'Null',TYPE)||');' from PHOTOS ";
public static Dictionary<string,string> TABLE_INSERT_SQL
{
get
{
Dictionary<string, string> dict = new Dictionary<string,string>();
dict.Add("JBXX", TABLE_JBXX);
dict.Add("JCJL", TABLE_JCJL);
dict.Add("JJ", TABLE_JJ);
dict.Add("SWDJ", TABLE_SWDJ);
dict.Add("TPDJ", TABLE_TPDJ);
dict.Add("HJBD", TABLE_HJBD);
dict.Add("JJX", TABLE_JJX);
dict.Add("FSSG", TABLE_FSSG);
dict.Add("LSHJ", TABLE_LSHJ);
dict.Add("TSDJ", TABLE_TSDJ);
dict.Add("CLCS", TABLE_CLCS);
dict.Add("TAF", TABLE_TAF);
dict.Add("JS", TABLE_JS);
dict.Add("KSS", TABLE_KSS);
// dict.Add("PHOTOS", TABLE_JKQK);
dict.Add("JY", TABLE_JY);
dict.Add("JKQK", TABLE_JKQK);
dict.Add("JQ", TABLE_JQ);
dict.Add("LSCS", TABLE_LSCS);
dict.Add("YQ", TABLE_YQ);
return dict;
}
}
public static string getInsertSql(string tableName)
{
tableName = tableName.ToUpper();
if (TABLE_INSERT_SQL.ContainsKey(tableName))
{
return TABLE_INSERT_SQL[tableName];
}
return null;
}
}
}