ϵͳ˵

iWebSignature һͨIEдǩ͵ӡµм.
===============================================================================


1OCX ˵
   WebUrl    ϵͳ·
   RecordID  ĵ¼
   FieldName ǩڼ¼еıֶ
   UserName  ǩû
   Enabled   Ƿǩ

2OCX˵
   OpenSignature ǩڽǩ
   ShowSignature ʾǩʷϢб
   LoadSignature ǩ
   SaveSignature ǩ


3OCXĲ
   OPTION 
     SIGNATRUELIST  ӡб
     SIGNATRUEIMAGE ӡͼƬ

     SAVESIGNATURE  ǩϢ
     LOADSIGNATURE  鿴ǩϢ

     SAVEHISTORY    ǩʷϢ
     SHOWHISTORY    鿴ǩʷϢ

4OCXͲ
   OpenSignature ܲ˳
     a) SIGNATRUELIST  ӡб
        Ͳ
                ֵ
        OPTION     =  SIGNATRUELIST
        USERNAME   =  û

        ز
                ֵ
        SIGNATRUELIST=ӡб
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ

     b) SIGNATRUEIMAGE ӡͼƬ
        Ͳ
                ֵ
        OPTION     =  SIGNATRUEIMAGE
        USERNAME   =  û
        PASSWORD   =  û
        IMAGENAME  =  ӡ

        ز
                ֵ
        IMAGETYPE  =  ӡ(.bmp  .jpg)
        MsgFileBody=  ӡͼƬ
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ



     c) SAVEHISTROY  ǩʷϢ
        Ͳ
                ֵ
        OPTION     =  SAVEHISTROY
        RECORDID   =  ǰ¼
        FIELDNAME  =  ǰǩڼ¼еıֶ
        MARKNAME   =  ǩӡ(ӡ£ΪӡƣдǩΪ"дǩ")
        USERNAME   =  û
        DATETIME   =  ǩӡʱ
        MARKGUID   =  ǩӡ¼ܱ

        ز
                ֵ
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ

   ShowSignature ʾǩϢб
        SHOWHISTROY   鿴ǩʷϢ
        Ͳ
                ֵ
        OPTION     =  SHOWHISTROY
        RECORDID   =  ǰ¼
        FIELDNAME  =  ǰǩڼ¼еֶ
        USERNAME   =  û

        ز
                ֵ
        MARKNAME   =  ӡб
        USERNAME   =  û
        DATETIME   =  ǩӡʱ
        HOSTNAME   =  ǩڵIPַ
        MARKGUID   =  ǩӡ¼ܱ
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ
        
   SaveSignature ǩ
        SAVESIGNATURE  ǩϢ
        Ͳ
                ֵ
        OPTION     =  SAVESIGNATURE
        RECORDID   =  ǰ¼
        FIELDNAME  =  ǰǩڼ¼еıֶ
        FIELDVALUE =  ǰǩľϢ
        USERNAME   =  û
        DATETIME   =  ǩӡʱ
        MARKGUID   =  ǩӡ¼ܱ

        ز
                ֵ
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ


   LoadSignature ǩ
        LOADSIGNATURE  ǩϢ
        Ͳ
                ֵ
        OPTION     =  LOADSIGNATURE
        RECORDID   =  ǰ¼
        FIELDNAME  =  ǰǩڼ¼еıֶ
        USERNAME   =  û

        ز
                ֵ
        FIELDVALUE =  ǰǩľϢ
        STATUS     =  ɹʧϢ
        MsgError   =  ΪɹΪʧ



ݽṹ
===============================================================================
ΪSQL ServerĽűļ

CREATE TABLE [dbo].[Document] (
	[DocumentID] [int] IDENTITY (1, 1) NOT NULL ,
	[RecordID] [nvarchar] (50) NULL ,
	[DocNo] [nvarchar] (128) NULL ,
	[UserName] [nvarchar] (128) NULL ,
	[Security] [nvarchar] (128) NULL ,
	[Draft] [nvarchar] (128) NULL ,
	[Check] [nvarchar] (128) NULL ,
	[Title] [nvarchar] (128) NULL ,
	[CopyTo] [nvarchar] (128) NULL ,
	[Subject] [nvarchar] (128) NULL ,
	[Copies] [nvarchar] (128) NULL ,
	[DateTime] [nvarchar] (128) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Document_History] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[RecordID] [nvarchar] (16) NULL ,
	[FieldName] [nvarchar] (50) NULL ,
	[MarkName] [nvarchar] (50) NULL ,
	[UserName] [nvarchar] (50) NULL ,
	[DateTime] [smalldatetime] NULL ,
	[HostName] [nvarchar] (50) NULL ,
	[MarkGuid] [nvarchar] (128) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Document_Signature] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[RecordID] [nvarchar] (16) NULL ,
	[FieldName] [nvarchar] (50) NULL ,
	[FieldValue] [ntext] NULL ,
	[UserName] [nvarchar] (50) NULL ,
	[DateTime] [smalldatetime] NULL ,
	[HostName] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Signature] (
	[SignatureID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (32) NULL ,
	[PassWord] [nvarchar] (32) NULL ,
	[MarkName] [nvarchar] (254) NULL ,
	[MarkType] [nvarchar] (4) NULL ,
	[MarkBody] [image] NULL ,
	[MarkPath] [nvarchar] (128) NULL ,
	[MarkSize] [int] NULL ,
	[MarkDate] [smalldatetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



//-------------------˵-----------------------------------------------------
Document 		ĵ
	[DocumentID] 	ĵ(Զ)
	[RecordID] 	ĵ¼,ͨñźӡ¿жӦ
	[DocNo]  	ı
	[UserName] 	û
	[Security] 	ܼ
	[Draft] 	
	[Check] 	
	[Title] 	
	[CopyTo] 	
	[Subject] 	
	[Copies] 	ӡ
	[DateTime] 	ʱ

Signature		ӡ¿
	[SignatureID] 	Զ
	[UserName] 	û
	[PassWord] 	û
	[MarkName] 	ӡ
	[MarkType] 	ӡ(.bmp,.jpg,.gif)
	[MarkBody] 	ӡϢ(,Ϊݿ,Ҫõ)
	[MarkPath] 	ӡĿ¼(ǱΪϵļ,Ҫʹñ)
	[MarkSize] 	ӡ´С
	[MarkDate] 	ӡ±ʱ


Document_Signature	ĵӡ¿
	[ID] 		Զ
	[RecordID] 	ӡ¶Ӧĵ
	[FieldName] 	ӡ¶Ӧֶ()
	[FieldValue] 	ӡ¶ӦӡϢ(ǰӡµļͼƬϢ)
	[UserName] 	û
	[DateTime] 	ӡʱ
	[HostName]	ӡûIPַ

Document_History  	ĵӡʷ
	[ID] 		Զ
	[RecordID] 	ĵ¼,ĵݿеRecordIDӦ,Ϊһӡ,Զӡ,ӡ¹̱ڴ
	[FieldName] 	ֶ
	[MarkName] 	ӡ
	[UserName] 	ӡû
	[DateTime] 	ʱ
	[HostName] 	ӡIPַ
	[MarkGuid] 	ԶɵӡΨһ


//-------------------------------------------------------------------------------------


DBSignature.mdb Accessݿļ.
DBSignature.bak SQL2000ݿⱸļ.

Ҫװʵע޸global.asaļеַ.
ʹSQL server2000,SQL 2000ϽDBSignatureݿ,Ȼ
DBSignature.bakָSQLϼɣʹsaʻ¼
οĵMS SQL ServerݿĻԭ˵.doc



װ˵
===============================================================================
1ļiWebSignature.asp.rarڷϽѹ,ļб
2iWebSignatureļĿ¼IISӳһĿ¼iWebSignature,עglobal.asaļ
   ܹĿ¼УͨĿ¼С
3RegSvr32 ̷:\iWebSignature\iMsgServer2000.dllעiMsgServer2000.dll
   ӡ¹Ҫע iFileUpload.dllעʾϴô100Kͼ£
   ҲעᣬοCOMװ.docǿƼʹøע᷽ʽ
4IE,http://localhost/iWebSignature/DocumentList.asp,㽫һҳ档



ĵ
===============================================================================
iWebSignature HTMLǩӡмƤ.doc



ϵǣ
===============================================================================
עҪʽ棬밴·ʽϵ
վ: http://www.goldgrid.com
ʼ: webmaster@goldgrid.com
      dbstep@hotmail.com
      dbstep@21cn.com
