--SQL参数，预置脚本
--DELETE FROM t_msplan_sqlparam WHERE FID = 1955793900446736384;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955793900446736384) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955793900446736384,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetCurrentMonthFirstDayValue',1955793900446736384,'C','@@GetCurrentMonthFirstDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1);
 
--DELETE FROM t_msplan_sqlparam WHERE FID = 1955856992945889280;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955856992945889280) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955856992945889280,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetCurrentMonthLastDayValue',1955856992945889280,'C','@@GetCurrentMonthLastDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955857785115653120;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955857785115653120) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955857785115653120,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetCurrentDateValue',1955857785115653120,'C','@@GetCurrentDate',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955858389280022528;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955858389280022528) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955858389280022528,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetCurrentYearFirstDayValue',1955858389280022528,'C','@@GetCurrentYearFirstDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955859148826489856;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955859148826489856) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955859148826489856,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetCurrentYearLastDayValue',1955859148826489856,'C','@@GetCurrentYearLastDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955860363119484928;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955860363119484928) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955860363119484928,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetOneMonthBeforeDayValue',1955860363119484928,'C','@@GetOneMonthBeforeDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955860927521764352;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955860927521764352) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955860927521764352,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetOneMonthAfterDayValue',1955860927521764352,'C','@@GetOneMonthAfterDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955861733616705536;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955861733616705536) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955861733616705536,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetOneYearBeforeDayValue',1955861733616705536,'C','@@GetOneYearBeforeDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955862648746685440;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955862648746685440) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955862648746685440,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetOneYearAfterDayValue',1955862648746685440,'C','@@GetOneYearAfterDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955863139388022784;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955863139388022784) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955863139388022784,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetThreeMonthAfterDayValue',1955863139388022784,'C','@@GetThreeMonthAfterDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

--DELETE FROM t_msplan_sqlparam WHERE FID = 1955863609712107520;
IF NOT EXISTS (SELECT 1 FROM t_msplan_sqlparam WHERE FID =  1955863609712107520) 
INSERT INTO t_msplan_sqlparam(FID,FTYPE,FISSYS,FPLUGINCLASS,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPARAMVALUE,FCREATORID) VALUES (1955863609712107520,'A','1','kd.mpscmm.msplan.mservice.service.resourcecheck.sqlparam.impl.GetThreeMonthBeforeDayValue',1955863609712107520,'C','@@GetThreeMonthBeforeDay',{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},' ',1); 

DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955793900446736384 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955793900446736384,'448/OP=03/O7','zh_CN','获取当前月份的第一天，时分秒格式为00:00:00,如：2018-08-01 00:00:00','获取当前月份的第一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955793900446736384 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955793900446736384,'448/OP=03/O8','zh_TW','獲取當前月份的第一天，時分秒格式為00:00:00,如：2018-08-01 00:00:00','獲取當前月份的第一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955856992945889280 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955856992945889280,'448AGFK53YEC','zh_TW','獲取當前月份的最後一天，時分秒格式為23:59:59,如：2018-08-31 23:59:59','獲取當前月份的最後一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955856992945889280 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955856992945889280,'448AGFK53YED','zh_CN','获取当前月份的最后一天，时分秒格式为23:59:59,如：2018-08-31 23:59:59','获取当前月份的最后一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955857785115653120 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955857785115653120,'448AM7OPL6UI','zh_TW','獲取當前係統時間，精確到時分秒,如：2018-08-01 14:08:08','獲取當前係統時間'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955857785115653120 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955857785115653120,'448AM7OPL6UJ','zh_CN','获取当前系统时间，精确到时分秒,如：2018-08-01 14:08:08','获取当前系统时间'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955858389280022528 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955858389280022528,'448AQMCZJOYV','zh_TW','獲取當前年度的第一天，時分秒格式為00:00:00,如：2018-01-01 00:00:00','獲取當前年度的第一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955858389280022528 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955858389280022528,'448AQMCZJOYW','zh_CN','获取当前年度的第一天，时分秒格式为00:00:00,如：2018-01-01 00:00:00','获取当前年度的第一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955859148826489856 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955859148826489856,'448AW58DIB57','zh_TW','獲取當前年度的最後一天，時分秒格式為23:59:59,如：2018-12-31 23:59:59','獲取當前年度的最後一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955859148826489856 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955859148826489856,'448AW58DIB58','zh_CN','获取当前年度的最后一天，时分秒格式为23:59:59,如：2018-12-31 23:59:59','获取当前年度的最后一天'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955860363119484928 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955860363119484928,'448B3/B36OH0','zh_TW','獲取當前日期之前的一個月的日期，時分秒格式為00:00:00,如：2018-08-01 00:00:00','獲取一個月之前的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955860363119484928 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955860363119484928,'448B3/B36OH1','zh_CN','获取当前日期之前的一个月的日期，时分秒格式为00:00:00,如：2018-08-01 00:00:00','获取一个月之前的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955860927521764352 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955860927521764352,'448B73QK6774','zh_TW','獲取當前日期之後的一個月的日期，時分秒格式為23:59:59,如：2018-08-01 23:59:59','獲取一個月之後的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955860927521764352 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955860927521764352,'448B73QK6775','zh_CN','获取当前日期之后的一个月的日期，时分秒格式为23:59:59,如：2018-08-01 23:59:59','获取一个月之后的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955861733616705536 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955861733616705536,'448BC+TXZ=G2','zh_TW','獲取當前日期之前的一年的日期，時分秒格式為00:00:00,如：2018-08-01 00:00:00','獲取一年之前的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955861733616705536 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955861733616705536,'448BC+TXZ=G3','zh_CN','获取当前日期之前的一年的日期，时分秒格式为00:00:00,如：2018-08-01 00:00:00','获取一年之前的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955862648746685440 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955862648746685440,'448BINWZ5DWR','zh_TW','獲取當前日期之後的一年的日期，時分秒格式為23:59:59,如：2018-08-01 23:59:59','獲取一年之後的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955862648746685440 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955862648746685440,'448BINWZ5DWS','zh_CN','获取当前日期之后的一年的日期，时分秒格式为23:59:59,如：2018-08-01 23:59:59','获取一年之后的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955863139388022784 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955863139388022784,'448BM8AWEMVK','zh_TW','獲取當前日期之後的三個月的日期，時分秒格式為23:59:59,如：2018-08-01 23:59:59','獲取三個月之後的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955863139388022784 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955863139388022784,'448BM8AWEMVL','zh_CN','获取当前日期之后的三个月的日期，时分秒格式为23:59:59,如：2018-08-01 23:59:59','获取三个月之后的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955863609712107520 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955863609712107520,'448BPO+MG/7C','zh_TW','獲取當前日期之前的三個月的日期，時分秒格式為00:00:00,如：2018-08-01 00:00:00','獲取三個月之前的日期'); 
DELETE FROM t_msplan_sqlparam_l WHERE FID = 1955863609712107520 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_sqlparam_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1955863609712107520,'448BPO+MG/7D','zh_CN','获取当前日期之前的三个月的日期，时分秒格式为00:00:00,如：2018-08-01 00:00:00','获取三个月之前的日期'); 


