Winform桌面程序采用C#语言编写的数据转换数据处理工具

2019-07-18 09:15:20,266 [2536] INFO RollingLogFileAppender [(null)] - 初始化 2019-07-18 09:15:20,291 [2536] INFO RollingLogFileAppender [(null)] - 执行Query=select group_id,name,remark,order_id,add_user,add_time,org_dblink_id,obj_dblink_id from job_group where group_id=17 正常，影响1行 2019-07-18 09:15:20,338 [2536] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=7 正常，影响1行 2019-07-18 09:15:20,339 [2536] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-18 09:15:22,279 [2536] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='工资' 正常，影响0行 2019-07-24 14:34:02,307 [7816] INFO RollingLogFileAppender [(null)] - 初始化 2019-07-24 14:34:02,456 [7816] INFO RollingLogFileAppender [(null)] - 执行Query=select group_id,name,remark,order_id,add_user,add_time,org_dblink_id,obj_dblink_id from job_group where group_id=17 正常，影响1行 2019-07-24 14:34:02,695 [7816] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=7 正常，影响1行 2019-07-24 14:34:02,696 [7816] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-24 14:34:05,049 [7816] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='银行对账' 正常，影响0行 2019-07-24 14:34:50,774 [10476] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='银行对账' 正常，影响1行 2019-07-29 09:34:58,993 [7948] INFO RollingLogFileAppender [(null)] - 初始化 2019-07-29 09:34:59,035 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select group_id,name,remark,order_id,add_user,add_time,org_dblink_id,obj_dblink_id from job_group where group_id=17 正常，影响1行 2019-07-29 09:34:59,055 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=7 正常，影响1行 2019-07-29 09:34:59,056 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-29 09:35:07,899 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='银行对账' 正常，影响1行 2019-07-29 09:36:17,850 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='工资' 正常，影响0行 2019-07-29 09:38:17,186 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select ruleName,sysType,sysKX,sysCode,sysJD,sysKJTX,sysdept,id,sysSx from linkrule where sysType='工资' and sysKJTX='CJ' order by sysSx 正常，影响107行 2019-07-29 09:38:32,584 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='工资' 正常，影响0行 2019-07-29 09:38:37,562 [7948] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-29 17:46:42,327 [10852] INFO RollingLogFileAppender [(null)] - 初始化 2019-07-29 17:46:42,358 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select group_id,name,remark,order_id,add_user,add_time,org_dblink_id,obj_dblink_id from job_group where group_id=17 正常，影响1行 2019-07-29 17:46:42,381 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=7 正常，影响1行 2019-07-29 17:46:42,383 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-29 17:46:43,584 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='工资' 正常，影响8行 2019-07-29 17:46:46,057 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='额度到账' 正常，影响2行 2019-07-29 17:47:01,178 [10852] INFO RollingLogFileAppender [(null)] - 1、开始执行凭证导入 2019-07-29 17:47:05,884 [10852] INFO RollingLogFileAppender [(null)] - 2、取得凭证号：JZ-02-0021 2019-07-29 17:47:06,913 [10852] INFO RollingLogFileAppender [(null)] - 3、取得HeadSql： insert into GL_VOU_HEAD (VOU_NO, CO_CODE, ACCOUNT_ID, FISCAL, FIS_PERD, VOU_TYPE_CODE, VOU_DESC, VOU_DATE, AMT_CR, ACCE_CNT, AMT_DR, INPUTOR, AUDITOR, POSTER, CDATE, ADATE, POST_DATE, STATUS, IS_REVERSE, REVER_MON, REVER_YEAR, VOU_SOURCE, COMPO_SOURCE, FSR, FSDATE, PRINT_STATUS, IS_PREPOSTED, CHECKER, CHECKER_DATE, ERR_MESSAGE, ERR_FLAG, ERROR, GUID, MODIFYTIME, VOU_KIND, TYPE, DTA_S_IMP_ROWID, DTA_D_IMP_BATCHID, DTA_LAST_TIME_STAMP, GL_KJTX, GL_YWNR, VOU_GROUP_ID, YSAMT_DR, YSAMT_CR, FILEADER) values ('JZ-02-0021', '152044', '001', 2019, 2, 'JZ', '6666', to_date('28-2-2019', 'dd-mm-yyyy'), 0, 0,0, 'wangli', null, null, null, null, null, 'Open', null, null, null, 'Entered', null, null, null, '1', 'N', null, null, null, '0', null, 2500939, sysdate,'RC', null, null, null, null, 'ALL', null, '2500939', 0, 0, '鲁冰') 2019-07-29 17:47:12,116 [10852] INFO RollingLogFileAppender [(null)] - 4、读取EXCEL成功！ 2019-07-29 17:48:37,586 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select ruleName,syscode,sysJD,sysSx from linkrule where sysType='额度到账' and sysKJTX='CJ' order by sysSx 正常，影响1行 2019-07-29 17:49:26,282 [10852] INFO RollingLogFileAppender [(null)] - 8、取得GetDetailSQLToYSXD 2019-07-29 17:49:26,283 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select ruleName,syscode,sysJD,sysSx from linkrule where sysType='额度到账' and sysKJTX='YJ' order by sysSx 正常，影响1行 2019-07-29 17:49:26,338 [10852] INFO RollingLogFileAppender [(null)] - 9、开始执行SQL 2019-07-29 17:49:30,508 [10852] INFO RollingLogFileAppender [(null)] - 10、执行SQL成功 2019-07-29 17:49:31,896 [10852] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='额度到账' 正常，影响3行 2019-07-29 17:57:08,783 [11060] INFO RollingLogFileAppender [(null)] - 初始化 2019-07-29 17:57:08,809 [11060] INFO RollingLogFileAppender [(null)] - 执行Query=select group_id,name,remark,order_id,add_user,add_time,org_dblink_id,obj_dblink_id from job_group where group_id=17 正常，影响1行 2019-07-29 17:57:08,830 [11060] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=7 正常，影响1行 2019-07-29 17:57:08,832 [11060] INFO RollingLogFileAppender [(null)] - 执行Query=select conn_id,name,db_type,server_name,username,password,db_name,add_time from db_conn_config where conn_id=12 正常，影响1行 2019-07-29 17:57:09,880 [11060] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='工资' 正常，影响8行 2019-07-29 17:57:12,101 [11060] INFO RollingLogFileAppender [(null)] - 执行Query=select * from opt_log where sysType='额度到账' 正常，影响3行 2019-07-29 17:57:26,236 [11060] INFO RollingLogFileAppender [(null)] - 1、开始执行凭证导入 2019-07-29 17:57:29,955 [11060] INFO RollingLogFileAppender [(null)] - 2、取得凭证号：JZ-02-0022 2019-07-29 17:57:31,072 [11060] INFO RollingLogFileAppender [(null)] - 3、取得HeadSql： insert into GL_VOU_HEAD (VOU_NO, CO_CODE, ACCOUNT_ID, FISCAL, FIS_PERD, VOU_TYPE_CODE, VOU_DE