Map工具系列-01-Map代码生成工具说明
所有cs端工具集成了一个工具面板 -打开(IE)
Map工具系列-01-Map代码生成工具说明
Map工具系列-02-数据迁移工具使用说明
Map工具系列-03-代码生成BySQl工具使用说明
Map工具系列-04-SQL合并执行工具
Map工具系列-05-添加业务参数工具
Map工具系列-06-销售营改增历史数据处理工具
Map工具系列-07-TFS变更集提取工具
Map工具系列-08-map控件查看器
Map工具系列-09-文件自动对比合并工具
more...
--------------------------2016-10-4更新---------------------------------------------
1,添加到cs端代码生成by设计文档工具中,功能一致
1.解决什么问题?
我们在开发的流程一般先用文档设计成一个表,在根据设计手动写sql,然后写gridxml和editxml。这个工具使你做好文档后,其他的全都自动生成。
2.怎么用
2.1 设计的表
2.2 SQL
修改生成的sql:
---------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------- GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='RentGUID') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [RentGUID] uniqueidentifier declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '租赁意向书GUID' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RentGUID' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='RencentName') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [RencentName] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '名称' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RencentName' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='RencentAmount') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [RencentAmount] money declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '金额' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RencentAmount' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='QSDate') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [QSDate] datetime declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '签署时间' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'QSDate' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='IsEnable') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [IsEnable] tinyint declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '是否启用' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'IsEnable' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='Remark') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [Remark] text declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '备注' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'Remark' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='RentOrderType') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [RentOrderType] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '租赁类型 area' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RentOrderType' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='CompanyType') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [CompanyType] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '公司类型 bu' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'CompanyType' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='ProjType') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [ProjType] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '项目类型 proj' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'ProjType' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='KSName') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [KSName] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '客商名称 link' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'KSName' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='UserName') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [UserName] varchar(128) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '用户名称 lookup' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'UserName' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_RentOrder]') AND name='UserGUID') BEGIN ALTER TABLE [dbo].[y_RentOrder] ADD [UserGUID] uniqueidentifier declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '用户GUID' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'UserGUID' END GO DELETE FROM dbo.def_table WHERE table_eng='y_RentOrder';insert into def_table (guid , table_eng , table_chn , comments , b_clear , b_system , b_view , is_export , b_report , b_sys , tabid) values ('0847708b-ea03-4242-9941-ce9b0547ae82','y_RentOrder','租赁意向书','',0, 0 ,0 , 0 , 0 ,0 ,NULL); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='RentGUID'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('a140962f-8b99-4e48-90ba-83450bb67028','0847708b-ea03-4242-9941-ce9b0547ae82','租赁意向书GUID' ,'RentGUID','40','uniqueidentifier','1' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='RencentName'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('569c5931-77b1-4bdf-8221-ef598ec60ca2','0847708b-ea03-4242-9941-ce9b0547ae82','名称' ,'RencentName','128','varchar','2' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='RencentAmount'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('bb5ebd58-7b32-43ed-886f-73a2605195cb','0847708b-ea03-4242-9941-ce9b0547ae82','金额' ,'RencentAmount','40','money','3' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='QSDate'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('fd6b616a-1c73-4071-8e26-27b58725ba8d','0847708b-ea03-4242-9941-ce9b0547ae82','签署时间' ,'QSDate','40','datetime','4' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='IsEnable'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('52ff0d48-d7df-4f3d-ae73-cd2e1b5d1702','0847708b-ea03-4242-9941-ce9b0547ae82','是否启用' ,'IsEnable','20','tinyint','5' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='Remark'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('147fc565-2ad1-4c6b-9ddb-9379e0db314e','0847708b-ea03-4242-9941-ce9b0547ae82','备注' ,'Remark','0','text','6' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='RentOrderType'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('d06602b6-6671-4b5f-bf7b-918448419a5a','0847708b-ea03-4242-9941-ce9b0547ae82','租赁类型' ,'RentOrderType','128','varchar','7' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'area' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='CompanyType'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('f98782b0-a558-4e0a-99ab-9150c6ceeb0f','0847708b-ea03-4242-9941-ce9b0547ae82','公司类型' ,'CompanyType','128','varchar','8' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'bu' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='ProjType'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('e50b25d4-6cb8-40bc-92b1-062fad79625d','0847708b-ea03-4242-9941-ce9b0547ae82','项目类型' ,'ProjType','128','varchar','9' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'proj' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='KSName'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('36a39140-4da3-432c-a13c-3f800cbf18ae','0847708b-ea03-4242-9941-ce9b0547ae82','客商名称' ,'KSName','128','varchar','10' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'link' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='UserName'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('66ca64cb-6006-493c-a1f9-8d8415086002','0847708b-ea03-4242-9941-ce9b0547ae82','用户名称' ,'UserName','128','varchar','11' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'lookup' ); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder' AND field_name='UserGUID'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('0a0dd818-8c64-48af-88a2-14f9b7abacb2','0847708b-ea03-4242-9941-ce9b0547ae82','用户GUID' ,'UserGUID','40','uniqueidentifier','12' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='RentGUID'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RentGUID','租赁意向书GUID','租赁意向书GUID',56,'租赁意向书GUID');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='RencentName'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RencentName','名称','名称',56,'名称');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='RencentAmount'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RencentAmount','金额','金额',56,'金额');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='QSDate'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','QSDate','签署时间','签署时间',56,'签署时间');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='IsEnable'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','IsEnable','是否启用','是否启用',56,'是否启用');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='Remark'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','Remark','备注','备注',56,'备注');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='RentOrderType'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RentOrderType','租赁类型','租赁类型',56,'租赁类型');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='CompanyType'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','CompanyType','公司类型','公司类型',56,'公司类型');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='ProjType'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','ProjType','项目类型','项目类型',56,'项目类型');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='KSName'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','KSName','客商名称','客商名称',56,'客商名称');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='UserName'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','UserName','用户名称','用户名称',56,'用户名称');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder' AND pbc_cnam='UserGUID'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','UserGUID','用户GUID','用户GUID',56,'用户GUID'); GO GO ---------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------- GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_Contact]') AND name='YTypeCode') BEGIN ALTER TABLE [dbo].[y_Contact] ADD [YTypeCode] varchar(256) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '经营业态' ,'user', @CurrentUser, 'table', 'y_Contact', 'column', 'YTypeCode' END GO GO IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE id=OBJECT_ID('[y_Contact]') AND name='RencentTypeCode') BEGIN ALTER TABLE [dbo].[y_Contact] ADD [RencentTypeCode] varchar(256) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '租赁类型' ,'user', @CurrentUser, 'table', 'y_Contact', 'column', 'RencentTypeCode' END GO DELETE FROM dbo.def_table WHERE table_eng='y_Contact';insert into def_table (guid , table_eng , table_chn , comments , b_clear , b_system , b_view , is_export , b_report , b_sys , tabid) values ('7b56e6be-9a36-48ba-9bca-4ad576e1e739','y_Contact','租赁合同','',0, 0 ,0 , 0 , 0 ,0 ,NULL); DELETE FROM dbo.data_dict WHERE table_name='y_Contact' AND field_name='YTypeCode'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('e244782f-f5e3-4209-9381-a6d18718bad1','7b56e6be-9a36-48ba-9bca-4ad576e1e739','经营业态' ,'YTypeCode','256','varchar','1' , '1' , '0' ,'y_Contact','租赁合同','', '0' , '' ); DELETE FROM dbo.data_dict WHERE table_name='y_Contact' AND field_name='RencentTypeCode'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('91d378be-518b-4a3f-a889-21eca636b280','7b56e6be-9a36-48ba-9bca-4ad576e1e739','租赁类型' ,'RencentTypeCode','256','varchar','2' , '1' , '0' ,'y_Contact','租赁合同','', '0' , '' ); DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_Contact' AND pbc_cnam='YTypeCode'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_Contact','dbo','YTypeCode','经营业态','经营业态',56,'经营业态');DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_Contact' AND pbc_cnam='RencentTypeCode'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_Contact','dbo','RencentTypeCode','租赁类型','租赁类型',56,'租赁类型'); GO GO
新增生成的sql:
---------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/) ----------------------- GO IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE id=OBJECT_ID('[y_RentOrder]')) BEGIN /*==============================================================*/ /* Table: y_RentOrder */ /*==============================================================*/ CREATE TABLE [dbo].[y_RentOrder]( [RentGUID] uniqueidentifier , [RencentName] varchar(128) , [RencentAmount] money , [QSDate] datetime , [IsEnable] tinyint , [Remark] text , [RentOrderType] varchar(128) , [CompanyType] varchar(128) , [ProjType] varchar(128) , [KSName] varchar(128) , [UserName] varchar(128) , [UserGUID] uniqueidentifier ) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '租赁意向书','user', @CurrentUser, 'table', 'y_RentOrder' execute sp_addextendedproperty 'MS_Description', '租赁意向书GUID' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RentGUID' execute sp_addextendedproperty 'MS_Description', '名称' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RencentName' execute sp_addextendedproperty 'MS_Description', '金额' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RencentAmount' execute sp_addextendedproperty 'MS_Description', '签署时间' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'QSDate' execute sp_addextendedproperty 'MS_Description', '是否启用' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'IsEnable' execute sp_addextendedproperty 'MS_Description', '备注' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'Remark' execute sp_addextendedproperty 'MS_Description', '租赁类型 area' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'RentOrderType' execute sp_addextendedproperty 'MS_Description', '公司类型 bu' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'CompanyType' execute sp_addextendedproperty 'MS_Description', '项目类型 proj' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'ProjType' execute sp_addextendedproperty 'MS_Description', '客商名称 link' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'KSName' execute sp_addextendedproperty 'MS_Description', '用户名称 lookup' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'UserName' execute sp_addextendedproperty 'MS_Description', '用户GUID' ,'user', @CurrentUser, 'table', 'y_RentOrder', 'column', 'UserGUID' END GO DELETE FROM dbo.def_table WHERE table_eng='y_RentOrder';insert into def_table (guid , table_eng , table_chn , comments , b_clear , b_system , b_view , is_export , b_report , b_sys , tabid) values ('0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','y_RentOrder','租赁意向书','',0, 0 ,0 , 0 , 0 ,0 ,NULL); DELETE FROM dbo.data_dict WHERE table_name='y_RentOrder'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('09a3326e-3482-44a0-b92f-c69fc2786ba3','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','租赁意向书GUID' ,'RentGUID','40','uniqueidentifier','1' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('0db2ae1b-f0f6-462c-9f2e-63c2af75e742','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','名称' ,'RencentName','128','varchar','2' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('96c430b1-f135-4d8a-b435-6b4780ceebf8','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','金额' ,'RencentAmount','40','money','3' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('993f2e2b-f598-40fb-8215-74e73e978801','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','签署时间' ,'QSDate','40','datetime','4' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('489aa9d5-abb3-4169-adf9-d2570b4e21b4','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','是否启用' ,'IsEnable','20','tinyint','5' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('5aa1a919-4e03-432e-9093-da6004cd5bf7','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','备注' ,'Remark','0','text','6' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('1d3e108a-8d61-4774-841e-776d13c88a9e','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','租赁类型' ,'RentOrderType','128','varchar','7' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'area' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('78e871cb-168f-46b3-b50c-abdbcca71133','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','公司类型' ,'CompanyType','128','varchar','8' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'bu' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('c25d1c58-0b81-4fce-b4e0-158f134dc3b4','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','项目类型' ,'ProjType','128','varchar','9' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'proj' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('d0632152-588d-4c74-8f8e-e93f31ce0b01','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','客商名称' ,'KSName','128','varchar','10' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'link' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('4b6dedd6-1d6d-46a9-8b0e-bb00401b9d65','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','用户名称' ,'UserName','128','varchar','11' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , 'lookup' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('01991373-028a-4c95-bfaa-15db3dfa7060','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','用户GUID' ,'UserGUID','40','uniqueidentifier','12' , '1' , '0' ,'y_RentOrder','租赁意向书','', '0' , '' ); DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_RentOrder'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RentGUID','租赁意向书GUID','租赁意向书GUID',56,'租赁意向书GUID'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RencentName','名称','名称',56,'名称'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RencentAmount','金额','金额',56,'金额'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','QSDate','签署时间','签署时间',56,'签署时间'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','IsEnable','是否启用','是否启用',56,'是否启用'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','Remark','备注','备注',56,'备注'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','RentOrderType','租赁类型','租赁类型',56,'租赁类型'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','CompanyType','公司类型','公司类型',56,'公司类型'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','ProjType','项目类型','项目类型',56,'项目类型'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','KSName','客商名称','客商名称',56,'客商名称'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','UserName','用户名称','用户名称',56,'用户名称'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_RentOrder','dbo','UserGUID','用户GUID','用户GUID',56,'用户GUID'); GO --Action表 DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=00 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '00', '查看租赁意向书', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=01 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '01', '新增租赁意向书', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=02 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '02', '修改租赁意向书', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=03 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '03', '删除租赁意向书', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=91 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '91', '打印租赁意向书', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=92 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '92', '导出租赁意向书', NULL, NULL, NULL, NULL ); --特殊 /*DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=01 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '01', '新增租赁意向书', NULL, 'Mysoft.Sxlt.Business. RentOrderMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=02 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '02', '修改租赁意向书', NULL, 'Mysoft.Sxlt.Business.RentOrderMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=71 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '71', '发起审批', NULL, 'Mysoft.Sxlt.Business.RentOrderMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=72 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '72', '审批过程', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=81 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '81', '提交审批', NULL, 'Mysoft.Sxlt.Business.RentOrderMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=82 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '82', '审批通过', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=83 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '83', '审批驳回', NULL, NULL, NULL, NULL );*/---------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/) ----------------------- GO IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE id=OBJECT_ID('[y_Contact]')) BEGIN /*==============================================================*/ /* Table: y_Contact */ /*==============================================================*/ CREATE TABLE [dbo].[y_Contact]( [YTypeCode] varchar(256) , [RencentTypeCode] varchar(256) ) declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_addextendedproperty 'MS_Description', '租赁合同','user', @CurrentUser, 'table', 'y_Contact' execute sp_addextendedproperty 'MS_Description', '经营业态' ,'user', @CurrentUser, 'table', 'y_Contact', 'column', 'YTypeCode' execute sp_addextendedproperty 'MS_Description', '租赁类型' ,'user', @CurrentUser, 'table', 'y_Contact', 'column', 'RencentTypeCode' END GO DELETE FROM dbo.def_table WHERE table_eng='y_Contact';insert into def_table (guid , table_eng , table_chn , comments , b_clear , b_system , b_view , is_export , b_report , b_sys , tabid) values ('95fdbc5d-7ff6-484f-b08f-049544db12b3','y_Contact','租赁合同','',0, 0 ,0 , 0 , 0 ,0 ,NULL); DELETE FROM dbo.data_dict WHERE table_name='y_Contact'; insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('3c72cec7-e62e-4223-b480-92d93657a64f','95fdbc5d-7ff6-484f-b08f-049544db12b3','经营业态' ,'YTypeCode','256','varchar','1' , '1' , '0' ,'y_Contact','租赁合同','', '0' , '' ); insert into data_dict( guid ,tableguid ,field_name_c ,field_name ,width ,data_type ,field_sequence ,b_null ,b_pk ,table_name ,table_name_c ,defaultvalue ,b_identity,Description) values ('dac7c6f5-4667-42f1-9f2c-48dc3332014a','95fdbc5d-7ff6-484f-b08f-049544db12b3','租赁类型' ,'RencentTypeCode','256','varchar','2' , '1' , '0' ,'y_Contact','租赁合同','', '0' , '' ); DELETE FROM dbo.pbcatcol WHERE pbc_tnam='y_Contact'; insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_Contact','dbo','YTypeCode','经营业态','经营业态',56,'经营业态'); insert into pbcatcol( pbc_tnam,pbc_ownr,pbc_cnam,pbc_labl,pbc_hdr,pbc_hght,pbc_cmnt) VALUES ('y_Contact','dbo','RencentTypeCode','租赁类型','租赁类型',56,'租赁类型'); GO --Action表 DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=00 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '00', '查看租赁合同', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=01 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '01', '新增租赁合同', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=02 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '02', '修改租赁合同', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=03 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '03', '删除租赁合同', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=91 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '91', '打印租赁合同', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=92 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '92', '导出租赁合同', NULL, NULL, NULL, NULL ); --特殊 /*DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=01 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '01', '新增租赁合同', NULL, 'Mysoft.Sxlt.Business. ContactMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=02 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '02', '修改租赁合同', NULL, 'Mysoft.Sxlt.Business.ContactMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=71 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '71', '发起审批', NULL, 'Mysoft.Sxlt.Business.ContactMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=72 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '72', '审批过程', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=81 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '81', '提交审批', NULL, 'Mysoft.Sxlt.Business.ContactMNG', 'SaveAct', 'Mysoft.Sxlt.Business' ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=82 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '82', '审批通过', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='02020901' AND ActionCode=83 Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly) values ( '02020901', NEWID(), '83', '审批驳回', NULL, NULL, NULL, NULL );*/
2.3 GridXml
Grid修改状态:
<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)--------------------------------> --------------------- y_RentOrder---------------------- ,RentGUID ,RencentName ,RencentAmount ,QSDate ,IsEnable ,Remark ,RentOrderType ,CompanyType ,ProjType ,KSName ,UserName ,UserGUID ,RentGUID,RencentName,RencentAmount,QSDate,IsEnable,Remark,RentOrderType,CompanyType,ProjType,KSName,UserName,UserGUID <attribute name="RentGUID" field="RentGUID" datatype="varchar" title="租赁意向书GUID" format="" />; <attribute name="UserGUID" field="UserGUID" datatype="varchar" title="用户GUID" format="" />; <cell datatype="varchar" width="100" field="RencentName" title="名称" orderby="RencentName" sortable="true" exportfield="RencentName" ></cell>; <cell datatype="money" width="80" format="0.00" field="RencentAmount" title="金额" orderby="RencentAmount" sortable="true" exportfield="RencentAmount" ></cell>; <cell datatype="datetime" width="80" format="yyyy-MM-dd" field="QSDate" title="签署时间" orderby="QSDate" sortable="true" exportfield="QSDate" ></cell>; <cell field="IsEnable" width="80" title="是否启用" orderby="IsEnable" sortable="true" exportfield="IsEnable" ></cell>; <cell datatype="text" field="Remark" title="备注" orderby="Remark" sortable="true" exportfield="Remark" ></cell>; <cell datatype="varchar" width="100" field="RentOrderType" title="租赁类型" orderby="RentOrderType" sortable="true" exportfield="RentOrderType" ></cell>; <cell datatype="varchar" width="100" field="CompanyType" title="公司类型" orderby="CompanyType" sortable="true" exportfield="CompanyType" ></cell>; <cell datatype="varchar" width="100" field="ProjType" title="项目类型" orderby="ProjType" sortable="true" exportfield="ProjType" ></cell>; <cell datatype="varchar" width="100" field="KSName" title="客商名称" orderby="KSName" sortable="true" exportfield="KSName" ></cell>; <cell datatype="varchar" width="100" field="UserName" title="用户名称" orderby="UserName" sortable="true" exportfield="UserName" ></cell>; --------------------- y_Contact---------------------- ,YTypeCode ,RencentTypeCode ,YTypeCode,RencentTypeCode <cell datatype="varchar" width="100" field="YTypeCode" title="经营业态" orderby="YTypeCode" sortable="true" exportfield="YTypeCode" ></cell>; <cell datatype="varchar" width="100" field="RencentTypeCode" title="租赁类型" orderby="RencentTypeCode" sortable="true" exportfield="RencentTypeCode" ></cell>;
Grid新增状态:
<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)--------------------------------> <?xml version="1.0" encoding="utf-8" ?> <page funcid="02020901"> <controls> <control id="appGridMenu"> <title>租赁意向书列表</title> <menu title="更多操作"> <menuitem id="btnDelete" actionid="03" title="删除" action="openDelWin()" display="true" /> <menuitem title="-" id="mHx" /> <menuitem id="m2" actionid="91" title="打印" action="AppGridPrint(appGrid);" /> <menuitem id="m3" actionid="92" title="导出" action="AppGridToExcel(appGrid);" /> </menu> <shortcuts> <shortcut id="btnNew" actionid="01" title="新增" action="openAddWin();" tip="新增" icon="/images/New_16_blue.gif" display="true" /> <!--<shortcut id="shtProcess" title="审批" icon="/cbgl/images/Examine_16_blue.gif" display="false"> <menuitem id="btnNewProcess" actionid="71" title="发起审批" action="doNewProcess()" display="false" /> <menuitem id="btnOpenProcess" actionid="72" title="审批过程" action="doOpenProcess()" display="false"/> <menuitem id="btnTjApprove" actionid="81" title="提交审批" action="doProcessLaunch()" display="false" /> <menuitem id="btnTgApprove" actionid="82" title="审批通过" action="doProcessPass()" display="false" /> <menuitem id="btnBhApprove" actionid="83" title="审批驳回" action="doProcessIgnore()" display="false" /> </shortcut>--> </shortcuts> </control> <control id="appGrid"> <datasource entity="y_RentOrder" keyname="RentGUID"> <sql> <![CDATA[ SELECT RentGUID, RencentName, RencentAmount, QSDate, IsEnable, Remark, RentOrderType, CompanyType, ProjType, KSName, UserName, UserGUID FROM dbo.y_RentOrder WHERE (1=1) AND (2=2); ]]> </sql> <order field="RentGUID" descending="false" /> </datasource> <grid ondblclick="openModiWin();" onready="" onclick="trClick();"> <row> <attributes> <attribute name="oid" field="RentGUID" datatype="varchar" title="租赁意向书GUID" /> <attribute name="UserGUID" field="UserGUID" datatype="varchar" title="用户GUID" /> </attributes> <cell datatype="varchar" width="100" field="RencentName" title="名称" orderby="RencentName" sortable="true" exportfield="RencentName" ></cell> <cell datatype="money" width="80" format="0.00" field="RencentAmount" title="金额" orderby="RencentAmount" sortable="true" exportfield="RencentAmount" ></cell> <cell datatype="datetime" width="80" format="yyyy-MM-dd" field="QSDate" title="签署时间" orderby="QSDate" sortable="true" exportfield="QSDate" ></cell> <cell field="IsEnable" width="80" title="是否启用" orderby="IsEnable" sortable="true" exportfield="IsEnable" ></cell> <cell datatype="text" field="Remark" title="备注" orderby="Remark" sortable="true" exportfield="Remark" ></cell> <cell datatype="varchar" width="100" field="RentOrderType" title="租赁类型" orderby="RentOrderType" sortable="true" exportfield="RentOrderType" ></cell> <cell datatype="varchar" width="100" field="CompanyType" title="公司类型" orderby="CompanyType" sortable="true" exportfield="CompanyType" ></cell> <cell datatype="varchar" width="100" field="ProjType" title="项目类型" orderby="ProjType" sortable="true" exportfield="ProjType" ></cell> <cell datatype="varchar" width="100" field="KSName" title="客商名称" orderby="KSName" sortable="true" exportfield="KSName" ></cell> <cell datatype="varchar" width="100" field="UserName" title="用户名称" orderby="UserName" sortable="true" exportfield="UserName" ></cell> </row> <!-- <summary>--> <!-- <cell field="Summary1" title="本页合计一" titlewidth="50" align="right" format="#,##0.00" />--> <!-- <cell sumtotalfield="Summary1" title="所有数据合计一" titlewidth="50" align="right" format="#,##0.00" />--> <!-- </summary>--> </grid> </control> </controls> </page> <?xml version="1.0" encoding="utf-8" ?> <page funcid="02020901"> <controls> <control id="appGridMenu"> <title>租赁合同列表</title> <menu title="更多操作"> <menuitem id="btnDelete" actionid="03" title="删除" action="openDelWin()" display="true" /> <menuitem title="-" id="mHx" /> <menuitem id="m2" actionid="91" title="打印" action="AppGridPrint(appGrid);" /> <menuitem id="m3" actionid="92" title="导出" action="AppGridToExcel(appGrid);" /> </menu> <shortcuts> <shortcut id="btnNew" actionid="01" title="新增" action="openAddWin();" tip="新增" icon="/images/New_16_blue.gif" display="true" /> <!--<shortcut id="shtProcess" title="审批" icon="/cbgl/images/Examine_16_blue.gif" display="false"> <menuitem id="btnNewProcess" actionid="71" title="发起审批" action="doNewProcess()" display="false" /> <menuitem id="btnOpenProcess" actionid="72" title="审批过程" action="doOpenProcess()" display="false"/> <menuitem id="btnTjApprove" actionid="81" title="提交审批" action="doProcessLaunch()" display="false" /> <menuitem id="btnTgApprove" actionid="82" title="审批通过" action="doProcessPass()" display="false" /> <menuitem id="btnBhApprove" actionid="83" title="审批驳回" action="doProcessIgnore()" display="false" /> </shortcut>--> </shortcuts> </control> <control id="appGrid"> <datasource entity="y_Contact" keyname="YTypeCode"> <sql> <![CDATA[ SELECT YTypeCode, RencentTypeCode FROM dbo.y_Contact WHERE (1=1) AND (2=2); ]]> </sql> <order field="YTypeCode" descending="false" /> </datasource> <grid ondblclick="openModiWin();" onready="" onclick="trClick();"> <row> <attributes> </attributes> <cell datatype="varchar" width="100" field="YTypeCode" title="经营业态" orderby="YTypeCode" sortable="true" exportfield="YTypeCode" ></cell> <cell datatype="varchar" width="100" field="RencentTypeCode" title="租赁类型" orderby="RencentTypeCode" sortable="true" exportfield="RencentTypeCode" ></cell> </row> <!-- <summary>--> <!-- <cell field="Summary1" title="本页合计一" titlewidth="50" align="right" format="#,##0.00" />--> <!-- <cell sumtotalfield="Summary1" title="所有数据合计一" titlewidth="50" align="right" format="#,##0.00" />--> <!-- </summary>--> </grid> </control> </controls> </page>
2.4 Eidt xml
Edit 修改状态
<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)--------------------------------> --------------------- y_RentOrder---------------------- ,RentGUID ,RencentName ,RencentAmount ,QSDate ,IsEnable ,Remark ,RentOrderType ,CompanyType ,ProjType ,KSName ,UserName ,UserGUID ,RentGUID,RencentName,RencentAmount,QSDate,IsEnable,Remark,RentOrderType,CompanyType,ProjType,KSName,UserName,UserGUID <item type="hidden" name="RentGUID" field="RentGUID" title="租赁意向书GUID" /> <item type="hidden" name="UserGUID" field="UserGUID" title="用户GUID" /> <item type="text" name="RencentName" field="RencentName" title="名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="128" defaultvalue="" onchange="" /></item> <item type="number" name="RencentAmount" field="RencentAmount" title="金额" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt="" onreturnvaluechange="" ondblclick="" /></item> <item type="datetime" name="QSDate" field="QSDate" title="签署时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item> <item type="radio" name="IsEnable" field="IsEnable" title="是否启用" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item> <item type="memo" name="Remark" field="Remark" title="备注" req="0" colspan="2" createapi="1" updateapi="1"> <attribute rows="3" maxlength="0"/></item> <item type="select" field="RentOrderType" title="租赁类型" name="RentOrderType" onchange="" sql="SELECT ParamCode as [value],ParamValue as text FROM myBizParamOption WHERE ParamName='y_RentOrderType' AND ParamLevel = 1 ORDER BY ParamCode" createapi="1" updateapi="0" > <option value=""></option> </item> <item type="select" field="CompanyType" title="公司类型" name="CompanyType" onchange="" sql="SELECT ParamCode as [value],ParamValue as text FROM myBizParamOption WHERE ParamName='y_CompanyType' AND ScopeGUID=[当前公司] AND ParamLevel = 1 ORDER BY ParamCode" createapi="1" updateapi="0" > <option value=""></option> </item> <item type="select" field="ProjType" title="项目类型" name="ProjType" onchange="" createapi="1" updateapi="0" > <option value=""></option> <function assembly="Mysoft.Slxt.Business" invokeclass="Mysoft.Slxt.Business.PublicMng" invokefunction="GetParamFromCache" textfield="Text" valuefield="Value"> <param>y_ProjType</param> <param>项目</param> </function> </item> <item type="hyperlink" field="KSName" title="客商名称" textfield="ParentName" colspan="2" href="/xxx.aspx?mode=3&oid=" target="_blank" onclick="alert(this.oid);event.returnValue=true" defaultvalue="1;2" defaulttext="Link 1;Link 2" height="20"/> <item type="text" name="appForm_DefectValue" field="UserName" title="用户名称" req="1" createapi="1" updateapi="1" iconwidth="25" assistanticon="/_imgs/btn_on_lookup.gif" iconclick="selectUserName()"> <attribute onclick="selectUserName();" /></item> --------------------- y_Contact---------------------- ,YTypeCode ,RencentTypeCode ,YTypeCode,RencentTypeCode <item type="text" name="YTypeCode" field="YTypeCode" title="经营业态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange="" /></item> <item type="text" name="RencentTypeCode" field="RencentTypeCode" title="租赁类型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange="" /></item>
Edit 新增状态
<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)--------------------------------> <?xml version="1.0" encoding="Utf-8" ?> <page funcid="02020901"> <controls> <control id="appFormMenu"> <menus> <menu id="m1" title="文件"> <menuitem id="mClose" title="关闭" action="window.close();" /> </menu> <menu id="m2" title="帮助"> <menuitem id="mClose" title="帮助" action="window.document.fireEvent('onhelp');" /> <menuitem id="mClose" title="关于明源地产ERP" action="openAbout();" /> </menu> </menus> <shortcuts> <shortcut id="btnSave" actionid="01,02" title="保存" tip="保存" action="save()" icon="/images/Save_16_blue.gif" display="true" /> <shortcut id="btnSaveAndClose" actionid="01,02" title="保存&关闭" tip="保存&关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/> <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&新增" tip="保存&新增" action="saveAndNew();" icon="/images/SaveNew_16_blue.gif" display="true"/> <!-- <shortcut id="scSpace2" title="|" display="false" />--> <!-- <shortcut actionid="71" id="btnNewProcess" title="发起审批" action="doNewProcess();" icon="/cbgl/images/tjsp_16.gif" display="false"/>--> <!-- <shortcut actionid="72" id="btnOpenProcess" title="审批过程" action="doOpenProcess();" icon="/cbgl/images/ckspgc_16.gif" display="false" />--> <!-- <shortcut actionid="81" id="btnTjApprove" title="提交审批" action="doProcessLaunch();" icon="/cbgl/images/tjsp_16.gif" display="false" />--> <!-- <shortcut actionid="82" id="btnTgApprove" title="审批通过" action="doProcessPass();" icon="/cbgl/images/sptg_16.gif" display="false" />--> <!-- <shortcut actionid="83" id="btnBhApprove" title="审批驳回" action="doProcessIgnore();" icon="/cbgl/images/spbh_16.gif" display="false" />--> <!-- <shortcut id="btnsDefect" title="研判" icon="/cbgl/images/Examine_16_blue.gif" display="true" > <menuitem actionid="06" id="btnDefectStart" title="发起研判" tip="发起研判" display="true"/> <menuitem actionid="06" id="btnDefectProcess" title="研判过程" tip="研判过程" display="true"/> </shortcut>--> <shortcut title="|" /> <shortcut title="关闭" tip="关闭" action="window.close();" icon="/images/Close_16_blue.gif" /> </shortcuts> </control> <control id="appNavBar"> <nav> <navitem id="tab_main" title="基本信息" icon="/hyxt/images/Info_16_wihte.gif" onclick="event.returnValue=false" isshowonadd="true" iscreateiframe="true" display="true"> </navitem> <navitem title="相关文档" icon="/cbgl/images/Document_16_wihte.gif" url="/cbgl/PUB/Tab_DocList.aspx?DocType=%u5408%u540C%u53D8%u66F4" display="false"> <params> <param name="oid" value="appForm.oid.value" /> <param name="funcid" value="__funcid.value" /> <param name="mode" value="__mode.value" /> </params> </navitem> </nav> </control> <control id="appForm"> <datasource entity="y_RentOrder" keyname="RentGUID"> <sql> <![CDATA[ SELECT RentGUID, RencentName, RencentAmount, QSDate, IsEnable, Remark, RentOrderType, CompanyType, ProjType, KSName, UserName, UserGUID FROM dbo.y_RentOrder WHERE (1=1) AND (2=2); ]]> </sql> </datasource> <form showtab="true"> <tab title="基本信息"> <section title="基本信息" showtitle="true" showbar="true" cols="2" titlewidth="100" secid="Sec1"> <item type="hidden" name="oid" field="RentGUID" title="租赁意向书GUID" /> <item type="hidden" name="UserGUID" field="UserGUID" title="用户GUID" /> <item type="text" name="RencentName" field="RencentName" title="名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="128" defaultvalue="" onchange="" /></item> <item type="number" name="RencentAmount" field="RencentAmount" title="金额" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt="" onreturnvaluechange="" ondblclick="" /></item> <item type="datetime" name="QSDate" field="QSDate" title="签署时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item> <item type="radio" name="IsEnable" field="IsEnable" title="是否启用" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item> <item type="memo" name="Remark" field="Remark" title="备注" req="0" colspan="2" createapi="1" updateapi="1"> <attribute rows="3" maxlength="0"/></item> <item type="select" field="RentOrderType" title="租赁类型" name="RentOrderType" onchange="" sql="SELECT ParamCode as [value],ParamValue as text FROM myBizParamOption WHERE ParamName='y_RentOrderType' AND ParamLevel = 1 ORDER BY ParamCode" createapi="1" updateapi="0" > <option value=""></option> </item> <item type="select" field="CompanyType" title="公司类型" name="CompanyType" onchange="" sql="SELECT ParamCode as [value],ParamValue as text FROM myBizParamOption WHERE ParamName='y_CompanyType' AND ScopeGUID=[当前公司] AND ParamLevel = 1 ORDER BY ParamCode" createapi="1" updateapi="0" > <option value=""></option> </item> <item type="select" field="ProjType" title="项目类型" name="ProjType" onchange="" createapi="1" updateapi="0" > <option value=""></option> <function assembly="Mysoft.Slxt.Business" invokeclass="Mysoft.Slxt.Business.PublicMng" invokefunction="GetParamFromCache" textfield="Text" valuefield="Value"> <param>y_ProjType</param> <param>项目</param> </function> </item> <item type="hyperlink" field="KSName" title="客商名称" textfield="ParentName" colspan="2" href="/xxx.aspx?mode=3&oid=" target="_blank" onclick="alert(this.oid);event.returnValue=true" defaultvalue="1;2" defaulttext="Link 1;Link 2" height="20"/> <item type="text" name="appForm_DefectValue" field="UserName" title="用户名称" req="1" createapi="1" updateapi="1" iconwidth="25" assistanticon="/_imgs/btn_on_lookup.gif" iconclick="selectUserName()"> <attribute onclick="selectUserName();" /></item> </section> </tab> </form> </control> </controls> </page> <?xml version="1.0" encoding="Utf-8" ?> <page funcid="02020901"> <controls> <control id="appFormMenu"> <menus> <menu id="m1" title="文件"> <menuitem id="mClose" title="关闭" action="window.close();" /> </menu> <menu id="m2" title="帮助"> <menuitem id="mClose" title="帮助" action="window.document.fireEvent('onhelp');" /> <menuitem id="mClose" title="关于明源地产ERP" action="openAbout();" /> </menu> </menus> <shortcuts> <shortcut id="btnSave" actionid="01,02" title="保存" tip="保存" action="save()" icon="/images/Save_16_blue.gif" display="true" /> <shortcut id="btnSaveAndClose" actionid="01,02" title="保存&关闭" tip="保存&关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/> <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&新增" tip="保存&新增" action="saveAndNew();" icon="/images/SaveNew_16_blue.gif" display="true"/> <!-- <shortcut id="scSpace2" title="|" display="false" />--> <!-- <shortcut actionid="71" id="btnNewProcess" title="发起审批" action="doNewProcess();" icon="/cbgl/images/tjsp_16.gif" display="false"/>--> <!-- <shortcut actionid="72" id="btnOpenProcess" title="审批过程" action="doOpenProcess();" icon="/cbgl/images/ckspgc_16.gif" display="false" />--> <!-- <shortcut actionid="81" id="btnTjApprove" title="提交审批" action="doProcessLaunch();" icon="/cbgl/images/tjsp_16.gif" display="false" />--> <!-- <shortcut actionid="82" id="btnTgApprove" title="审批通过" action="doProcessPass();" icon="/cbgl/images/sptg_16.gif" display="false" />--> <!-- <shortcut actionid="83" id="btnBhApprove" title="审批驳回" action="doProcessIgnore();" icon="/cbgl/images/spbh_16.gif" display="false" />--> <!-- <shortcut id="btnsDefect" title="研判" icon="/cbgl/images/Examine_16_blue.gif" display="true" > <menuitem actionid="06" id="btnDefectStart" title="发起研判" tip="发起研判" display="true"/> <menuitem actionid="06" id="btnDefectProcess" title="研判过程" tip="研判过程" display="true"/> </shortcut>--> <shortcut title="|" /> <shortcut title="关闭" tip="关闭" action="window.close();" icon="/images/Close_16_blue.gif" /> </shortcuts> </control> <control id="appNavBar"> <nav> <navitem id="tab_main" title="基本信息" icon="/hyxt/images/Info_16_wihte.gif" onclick="event.returnValue=false" isshowonadd="true" iscreateiframe="true" display="true"> </navitem> <navitem title="相关文档" icon="/cbgl/images/Document_16_wihte.gif" url="/cbgl/PUB/Tab_DocList.aspx?DocType=%u5408%u540C%u53D8%u66F4" display="false"> <params> <param name="oid" value="appForm.oid.value" /> <param name="funcid" value="__funcid.value" /> <param name="mode" value="__mode.value" /> </params> </navitem> </nav> </control> <control id="appForm"> <datasource entity="y_Contact" keyname="YTypeCode"> <sql> <![CDATA[ SELECT YTypeCode, RencentTypeCode FROM dbo.y_Contact WHERE (1=1) AND (2=2); ]]> </sql> </datasource> <form showtab="true"> <tab title="基本信息"> <section title="基本信息" showtitle="true" showbar="true" cols="2" titlewidth="100" secid="Sec1"> <item type="text" name="YTypeCode" field="YTypeCode" title="经营业态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange="" /></item> <item type="text" name="RencentTypeCode" field="RencentTypeCode" title="租赁类型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange="" /></item> </section> </tab> </form> </control> </controls> </page>
2.5 XML解析说明
解析:
根据不同的类型生成对应的
Grid.xml
Edit.xml
生成对应的代码如下
2.6 工具解析
修改时候是生成修改时对应的代码,类似代码片段,不会生成完整的代码集。
新增的时候主要输入个对应模块的funcid 因为这个时候回生成完整的editxml 和gridxml。
有啥问题可以在这留言,觉的该工具有用的话记得在公司多转下邮件,让更多人可以早点回去陪女朋友。不说了,说多了都是泪。