SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [FormControl](
	[HtmlID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Label] [nvarchar](max) NULL,
	[Type] [varchar](50) NULL,
 CONSTRAINT [PK_Html] PRIMARY KEY CLUSTERED 
(
	[HtmlID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET IDENTITY_INSERT [FormControl] ON 

INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (1, N'文本框', N'<input id="{$id}" name="{$id}" type="text" class="text {$id}text" placeholder="{$placeholder}"  />', N'text')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (2, N'密码框', N'<input id="{$id}" name="{$id}" type="password" class="password  {$id}password" placeholder="{$placeholder}" />', N'password')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (3, N'复选框', N'<input name="{$id}" type="checkbox" value="{$value}" class="checkbox  {$id}checkbox" />', N'checkbox')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (4, N'单选框', N'<input name="{$id}" type="radio"  value="{$value}" class="radio  {$id}radio" />', N'radio')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (5, N'单文件上传', N'<script type="text/javascript">var {$id}HtmlUpload=new UploadStyle("{$id}HtmlUpload", true);document.write({$id}HtmlUpload.initialSingleFile(''/Ashx/FileUpload.ashx?cmd=inforelease&source=html''));\r\n</script>', N'singlefile')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (6, N'隐藏域', N'<input id="{$id}" name="{$id}" type="hidden" />', N'hidden')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (7, N'多行文本框', N'<textarea id="{$id}" name="{$id}" cols="20" rows="2" class="textarea  {$id}textarea" placeholder="{$placeholder}"></textarea>', N'textarea')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (8, N'下拉列表', N'<select id="{$id}" name="{$id}" class="select  {$id}select">{$option}</select>', N'select')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (9, N'编辑器', N'<textarea id="{$id}" name="{$id}" cols="20" rows="2" class="editor {$id}editor xheditor-simple" placeholder="{$placeholder}"></textarea>', N'editor')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (10, N'验证码', N'<input id="{$id}" name="{$id}" type="text" class="verification {$id}verification"  /><img id="imgVerification" alt="验证码" src="/Ashx/VerificationCode.ashx?625" placeholder="{$placeholder}" />', N'verification')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (11, N'城市选择', N'<input id="{$id}" name="{$id}" type="text" class="text {$id}text" onclick="ClickOpenCityList(event, this);" cityid="" cityname="" idpath="" namepath="" nosubmit="nosubmit" placeholder="{$placeholder}" />', N'city')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (12, N'多文件上传', N'<script type="text/javascript">var {$id}HtmlUpload= new UploadStyle("{$id}HtmlUpload", true);document.write({$id}HtmlUpload.initialMultipleFile(''/Ashx/FileUpload.ashx?cmd=inforelease&source=html''));</script>', N'multifile')
INSERT [FormControl] ([HtmlID], [Name], [Label], [Type]) VALUES (13, N'日期', N'<input id="{$id}" name="{$id}" type="text" class="text Wdate {$id}text"  onclick="WdatePicker()" readonly="readonly" placeholder="{$placeholder}" />', N'date')
SET IDENTITY_INSERT [FormControl] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表主键,自增长编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FormControl', @level2type=N'COLUMN',@level2name=N'HtmlID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Html元素中文名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FormControl', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Html标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FormControl', @level2type=N'COLUMN',@level2name=N'Label'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Html控件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FormControl', @level2type=N'COLUMN',@level2name=N'Type'
GO
