MZ@ !L!This program cannot be run in DOS mode. $PELcU! jn @ @Wp t  H.textti j `.rsrcpl@@.reloc p@BPH=J{*"}*{*"}*{*"}*r( (((*( ( (( ((*{*"}*{*"}*{ *"} *{ *"} *{ *"} *{ *"} *{ *"} *{*"}*{*"}*{*"}*{*"}*{*"}*{*"}*{*"}*{*"}*0(,o (+}{(o o o*98rp(( ((( (( o rprCp( o &o r]po &o r}po &o rprCp( o & 8o o {o (! o o (" o o rpo# o o r]po# o o r}p o# o o rpo# X o o ?V*(o rprCp( o &+$o o rpo# Xo o 2*vs:}s$ }( *{*"}*{*"}*{*"}*{*"}*>%(-X(.*>%(-X(.*>%(/X(0*>%(/X(0*>%(+X(,*>%(+X(,*>%()X(**>%()X(**0Krp ()(-(+(/(% *( *( }}(& -+rp}*( *0s' o( *03() rpo* o+  rpo, (- s. z*+0s( (A (B&rgp o  o {o+ {o+ (% (/ ] rpo0 o, (% (/ {rpo, o0 (1 o2 &{o-{o){o-Y{o+Y{o+ s; (=*Z`]+0s( (A (C&rgp o  o {o+ {o+ (% (/ ] rpo0 o, (% (/ {rpo, o0 (1 o2 &{o-{o){o-Y{o+Y{o+ s; (=*Z`]+0(3 s( o4 oo5 0o+ oo6 rp(7 o o8 o o9 oo: os; oo< o= o> o?  + (@ oo sA oB  (C - oD  8ooE o< o= oF  +3 (G (H (I ,(I o+ +r3po#  (J - oD oo oK X o< oL ?kr=po, (- s. z*AL+@0jj+0BPo'Po(D,#PPoPo(Fo(HP{*bPo'(LP{*0,rgp( ~(M &&(E  z** %+ 0;rp( ~(N &  rprpo, (O s. z* +0rp(1 ~(P oQ oR , o o -,rsp*rp*0P(T  8rQp o 1 +o + rSpo ( (- X2 og Yoh  Po(U~(N & Porgpo, ( s. zo o =[*x +0s orwpo[  +r rpo oo r]po` o+ o r}po` o+ (% o X i2*0 rp(1 *0krp Po PoPo Po Po(% ~(N & rpo, (- s. z*ES+0E (& - r3p(Y , r3p -*r pr pr po r p( *0sr! po\ ,*-*o -*(Y sr  +7o o o / o Y2( o X o 2 z*To+0oX % 9~-Us %r+ p( %r; p( %rM p( %ra p( %ru p( %r p( ~( ,/E +******r ps. z( *BSJB v4.0.30319l@#~ #Strings# #USD#GUIDD(#BlobW %3IZPT,   ha |, YFA4$  ;  X  w           + 9  R   o  [   B U p a| a a     4 6 aC R   "8  \ a&y & | | | a ?aZ{44F)a"b"b*=Zi$2$ <$)D$;L$=P$>[,>F>^Asz:~Nf %@\x> >(>E>>> P  X a  i r z  && &2 V Z V Z V Z V !Z !V!Z!V$!Z-!_5!$d>!-VF!7ZO!AVW!MZ`!YVh!gZq!ujy!n!j!n!j!n!j!n!j!n!An#&#O #^#m #{# #$  $$#$3$C$S$ c$ s$!$!$V"$&"$&"%&%(%%D%&%&&('*)+*-*/p*0*1\+3-54.#7.48/c90s:D1}<2=2>l4@6D9F9G:H\;Ix;K<LT<"M<I-P=&QYYY_el_elYYYYYYYYYYYYYYYrYYYYzzzz~8Y   I&ZQ&ZY&Za&Zi&Zq&Zy&Z&Z&n&Z&Z&Z&Z&3&&&& &v > C J) _ e k)* q); w!N ~!N  Z  c k u 9 1&  A&A IL QZ  VYf Vr Y&Za Y V 1 q (yVy/y 5yVyVyV)&y;Z Uc$w,*1&Z!N ,6jK)S4*<i<q46j N   r Z %9Z +9@*F1VVJ6j)j1 "r0x9Z 969Z 9&9N B H SZVD&L&!Z !&LN DN T&&ZD,\*)&>)%FLc 14L9GA&SIwZTN Y|V `\6j1 Z Ur   & N T TZ UTd&dN d" 9!9.. 0.E.{.#K.+0.s.9.E.KE.k.;E.3W.Su.c@9A9`9a99999999 9!9@9A9`9a99999999999 9!9@9A9`9a99999999999 9!9@9`999999 9@9`9999 9@9`99999990P} h+uI~IM !,8A`IkIuII       !!"!##$#&%%%)'*'+),).+-+/-0-I[o&6$Xo*6   ay -[PageDataCheck.dllRecordsPageDataCheckNPagePostCResultSresultBllCheckermscorlibSystemObjectDataLineSendGenius.SvrIPagePostget_RecordIdset_RecordIdget_Statusset_StatusSystem.Collections.GenericList`1System.DataSystem.Data.SqlClientSqlParameterget_Parasset_Paras.ctork__BackingFieldk__BackingFieldk__BackingFieldRecordIdStatusParasget_ProcIDset_ProcIDget_EndDateset_EndDateget_ClassIDset_ClassIDget_DbKeyset_DbKeyget_TbNameset_TbNameget_TbKeysset_TbKeysDataTableget_dataset_dataget_TB_IDset_TB_IDget_DataMd5set_DataMd5get_RecTBNameset_RecTBNameget_isAddCtimeset_isAddCtimeget_isAddMtimeset_isAddMtimeget_isAddIsvaidset_isAddIsvaidget_isAddSeqset_isAddSeqget_isSendMessageset_isSendMessageTbKeysDicResultSystem.TextStringBuilderErrMsgPretreatmentk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldProcIDEndDateClassIDDbKeyTbNameTbKeysdataTB_IDDataMd5RecTBNameisAddCtimeisAddMtimeisAddIsvaidisAddSeqisSendMessageget_TotalCountset_TotalCountget_SkipCountset_SkipCountget_SubmitCountset_SubmitCountget_FailCountset_FailCountAddSubmitAddFailAddSkipAddTotalToStringk__BackingFieldk__BackingFieldk__BackingFieldk__BackingFieldTotalCountSkipCountSubmitCountFailCountCountSubmitCountFailPromptToJson_mySqlConn.cctorSubmitAndCheckSubmitJsonToNPagePostTbNameCheckCreatTableGetTB_IDTBCheckAutoMD5CheckAndSaveDateDataMD5CheckCheckAllRecordMD5System.CollectionsHashtableGetAllRecordMd5SumitDataGetCommondTextGetValueSaveDataBySqlParametersSaveRecordsSaveDataGetSqlExpSaveRecordsMD5GetRecMd5InserValuesGetRECORD_MD5SaveSqlSaveDateMd5EscapeFormatSendMessageDAServiceHX.DAServiceEDBNameGetDataBaseTypevaluerecidstatusparasisChecknumsubmitfailpromptresultjsonconnStringjsonStringpageDatatbNamedbKeysinputsqlrecordspagedatavaluestbnameseqlistdataBaseNametableNameSystem.ReflectionAssemblyTitleAttributeAssemblyDescriptionAttributeAssemblyConfigurationAttributeAssemblyCompanyAttributeAssemblyProductAttributeAssemblyCopyrightAttributeAssemblyTrademarkAttributeAssemblyCultureAttributeSystem.Runtime.InteropServicesComVisibleAttributeGuidAttributeAssemblyVersionAttributeAssemblyFileVersionAttributeSystem.Runtime.VersioningTargetFrameworkAttributeSystem.DiagnosticsDebuggableAttributeDebuggingModesSystem.Runtime.CompilerServicesCompilationRelaxationsAttributeRuntimeCompatibilityAttributeSystem.CoreExtensionAttributeCompilerGeneratedAttributeInt32ParseCharStringSplitSystem.LinqEnumerableIEnumerable`1ToListDataRowCollectionget_RowsInternalDataCollectionBaseget_CountFormatBusinessServiceMD5DataColumnCollectionget_ColumnsTypeGetTypeDataColumnAddDataRowget_ItemToArrayGetKeyMd5GetDataRowMd5set_ItemIsNullOrEmptySystem.Web.ExtensionsSystem.Web.Script.SerializationJavaScriptSerializerSerializeSystem.ConfigurationConfigurationManagerSystem.Collections.SpecializedNameValueCollectionget_AppSettingsExceptionget_MessageConcatLogHelperHX.LogLogTypeWriteLogget_StackTraceAppendPagePostBllPagePostFromJsonenDbKeysDateTimeget_EndDataDictionary`2KeyCollectionget_KeysEnumeratorGetEnumeratorget_CurrentMoveNextIDisposableDisposeNewRowKeyValuePair`2get_Keyget_ValueDbHelperMySqlGetDataExecuteSqlDataSetGetDataSetDataTableCollectionget_TablesDBHelperNIEnumeratorget_ColumnNameToUpperop_EqualitySelectContainsAppendLineEqualsDBNullValueContainsKeyEmptyget_LengthRemoveToLowerSystem.Text.RegularExpressionsRegexMatchMSServiceHX.MSServiceMessageServiceIList`1SqlConnectionSystem.Data.CommonDbConnectionset_ConnectionStringOpenSqlCommandSqlParameterCollectionget_ParametersAddRangeDbCommandset_CommandTimeoutSqlDataAdapterDbDataAdapterFillget_SourceCloseInsertAppendFormatRemoveRangeReplaceClear{A35AF78A-96B9-4386-8C1B-E698B99B5E7C}$$method0x6000059-1TryGetValueRECORD_MD5_{0}#MD5CHECK_RECORDIDSystem.Int32MD5CHECK_KEYMD5%MD5CHECK_RECORDMD5'MD5CHECK_CHANGE_TAG/;`pe{0};cN{1};Ǐ{2};Q{3}OKCheckerServerIMD5hg!jWWRYS1Y%hg/f&T:\CheckerServerMn%NR{0}.{1},{2},{3}?json={2},connString={3},{0}:{1}{0},{1}?{0}:{1},json={2},connString={3}yyyy-MM-dd null)gbLJosnToNPagePostQ#select 1 from {0} SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `record_md5_(table_name)` -- ---------------------------- CREATE TABLE `{0}` ( `TASK_ID` int(11) NOT NULL DEFAULT '0', `TB_ID` int(11) NOT NULL DEFAULT '0', `DATA_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `KEY_MD5` varchar(50) NOT NULL DEFAULT '', `ASSI_KEY` varchar(50) DEFAULT NULL, `REC_MD5` varchar(50) DEFAULT NULL, PRIMARY KEY (`TASK_ID`,`TB_ID`,`DATA_DATE`,`KEY_MD5`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of record_md5_(table_name) -- ----------------------------h T,md5^^h1Y%select TB_ID from tb_info where TB_NAME = '{0}' and DB_NAME= '{1}'INSERT into tb_info (TB_NAME,DB_NAME,REMARK) values ('{0}','{1}',null); select tb_id from tb_info where TB_NAME = '{0}' and DB_NAME= '{1}'1select top 1 * from {0} CTIME MTIMEISVALIDSEQ/MD5CHECK_CHANGE_TAG='1'(W{0}Q:{1} select 1 from DATE_MD5 where TASK_ID = '{0}' and TB_ID= '{1}' and DATA_DATE='{2}' and ASSI_KEY = '{3}' and DATA_MD5 = '{4}' 1Gel CheckAllRecordMD5 -NpencMD5[kǏ z-NQ:select KEY_MD5,REC_MD5 from {4} where TASK_ID = '{0}' and TB_ID = '{1}' and DATA_DATE ='{2}' and ASSI_KEY = '{3}' KEY_MD5REC_MD5GNR{0}[{1}],date{2}nhpencOX[{3},{4}MD5CHECK {0} = @{0} and {0} = @{0} , {0}, @{0}, --declare @update int=0 declare @seqlist table(isupdate int,seq int) update {0} set {1} --@update=1 , mtime = getdate() output 1, inserted.SEQ into @seqlist(isupdate,seq) where {2}; if @@rowcount=0 BEGIN insert into {0} ({3},mtime) output 0, inserted.SEQ into @seqlist(isupdate,seq) values ({4},getdate()); END --select @update select * from @seqlist 0@5(?<=Data Source=)\S*?(?=;)=(?<=Initial Catalog=)\S*?(?=;)2{0}{1}{2}cNpencQ! {0} = '{1}' and {0} = {1} , {0} ,mtime ,getdate() ,'mtime = getdate() ,%{0}OX[Q,Oo`Y N{1}# declare @num int declare @status int set @num = 0 set @status = 0 select @num = seq from {0} where {1} if(@num =0) begin set @status = 0 declare @seq int exec PubDB..getseq '{0}',@seq output insert into {0} (seq, {2}) values (@seq, {3}) select @status,@seq end else begin set @status = 1 update {0} set {4} where seq = @num select @status,@num end --declare @update int=0 declare @seqlist table(isupdate int,seq int) update {0} set {4} --,@update=1 output 1, inserted.SEQ into @seqlist(isupdate,seq) where {1}; if @@rowcount=0 BEGIN insert into {0} ({2}) output 0, inserted.SEQ into @seqlist(isupdate,seq) values ({3}); END --select @update select * from @seqlist {0} ,pencOX[Q3MD5CHECK_CHANGE_TAG = '2'K('{0}','{1}','{2}','{3}','{4}','{5}') DROP TEMPORARY TABLE IF EXISTS TMPWEBCATCH_REC_MD5; CREATE TEMPORARY TABLE TMPWEBCATCH_REC_MD5 (TASK_ID INT, TB_ID INT, DATA_DATE VARCHAR(200), KEY_MD5 VARCHAR(200), ASSI_KEY VARCHAR(200), REC_MD5 VARCHAR(200) ); INSERT INTO TMPWEBCATCH_REC_MD5 (TASK_ID,TB_ID,DATA_DATE,KEY_MD5,ASSI_KEY,REC_MD5) VALUES {0}; UPDATE {1} T INNER JOIN TMPWEBCATCH_REC_MD5 S ON T.TASK_ID= S.TASK_ID AND T.TB_ID = S.TB_ID AND T.DATA_DATE = S.DATA_DATE AND T.KEY_MD5= S.KEY_MD5 SET T.REC_MD5= S.REC_MD5; INSERT INTO {1} (TASK_ID,TB_ID,DATA_DATE,KEY_MD5,ASSI_KEY,REC_MD5) SELECT TASK_ID,TB_ID,DATA_DATE,KEY_MD5,ASSI_KEY,REC_MD5 FROM TMPWEBCATCH_REC_MD5 S WHERE NOT EXISTS (SELECT 1 FROM {1} T WHERE T.TASK_ID= S.TASK_ID AND T.TB_ID = S.TB_ID AND T.DATA_DATE = S.DATA_DATE AND T.KEY_MD5 = S.KEY_MD5); DROP TEMPORARY TABLE IF EXISTS TMPWEBCATCH_REC_MD5;'insert into date_md5 (task_id,tb_id,data_date,assi_key,data_md5) values ('{0}','{1}','{2}','{3}','{4}') on DUPLICATE key update data_md5 = '{4}'!DATE_MD5hpencOX[Q''' testCGENIUSDATAPOOLXINFODATAEGENIUS_1EGENIUS_2PGENIUS OeQN*g[INv EDBNameZC昹^|z\V4           ((         (((                                ! ]            18V6N5 ?_ :                   )                                 !   !        ! !   JosnDataChecker geniusCopyright © genius 2014)$01a26fd4-800c-4112-ac6b-dde9275b242a 1.0.0.0G.NETFramework,Version=v4.0TFrameworkDisplayName.NET Framework 4TWrapNonExceptionThrowscUjRSDSaqsX@t!\ D:\SVN\DCDeveloper\SourceCode\Dll_Libarys\GeniusClassLibrary\PageDataCheck\obj\Release\PageDataCheck.pdb<^ P_CorDllMainmscoree.dll% @0HX4VS_VERSION_INFO?DVarFileInfo$TranslationtStringFileInfoP000004b00CompanyNamegeniusHFileDescriptionJosnDataChecker0FileVersion1.0.0.0DInternalNamePageDataCheck.dllTLegalCopyrightCopyright genius 2014LOriginalFilenamePageDataCheck.dll@ProductNameJosnDataChecker4ProductVersion1.0.0.08Assembly Version1.0.0.0 p9