所有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','','uniqueidentifier','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','money','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','datetime','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','tinyint','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','text','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' ); 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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','uniqueidentifier','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' );
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','','varchar','' , '' , '' ,'y_Contact','租赁合同','', '' , '' ); 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','','varchar','' , '' , '' ,'y_Contact','租赁合同','', '' , '' );
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','','uniqueidentifier','' , '' , '' ,'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 ('0db2ae1b-f0f6-462c-9f2e-63c2af75e742','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','名称' ,'RencentName','','varchar','' , '' , '' ,'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 ('96c430b1-f135-4d8a-b435-6b4780ceebf8','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','金额' ,'RencentAmount','','money','' , '' , '' ,'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 ('993f2e2b-f598-40fb-8215-74e73e978801','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','签署时间' ,'QSDate','','datetime','' , '' , '' ,'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 ('489aa9d5-abb3-4169-adf9-d2570b4e21b4','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','是否启用' ,'IsEnable','','tinyint','' , '' , '' ,'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 ('5aa1a919-4e03-432e-9093-da6004cd5bf7','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','备注' ,'Remark','','text','' , '' , '' ,'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 ('1d3e108a-8d61-4774-841e-776d13c88a9e','0fefeb07-9b8e-44cc-95da-0de7f5a7ade7','租赁类型' ,'RentOrderType','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','varchar','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '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','','uniqueidentifier','' , '' , '' ,'y_RentOrder','租赁意向书','', '' , '' );
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='' AND ActionCode=00
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '查看租赁意向书', NULL, NULL, NULL, NULL );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=01
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '新增租赁意向书', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=02
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '修改租赁意向书', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=03
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '删除租赁意向书', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='' AND ActionCode=91
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '打印租赁意向书', NULL, NULL, NULL, NULL );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=92
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '导出租赁意向书', 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','','varchar','' , '' , '' ,'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 ('dac7c6f5-4667-42f1-9f2c-48dc3332014a','95fdbc5d-7ff6-484f-b08f-049544db12b3','租赁类型' ,'RencentTypeCode','','varchar','' , '' , '' ,'y_Contact','租赁合同','', '' , '' );
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='' AND ActionCode=00
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '查看租赁合同', NULL, NULL, NULL, NULL );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=01
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '新增租赁合同', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=02
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '修改租赁合同', NULL, 'Mysoft.Map.Data.MyDB', 'SaveXml', 'Mysoft.Map.Core' );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=03
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '删除租赁合同', NULL, NULL, NULL, NULL ); DELETE FROM myAction WHERE ObjectType='' AND ActionCode=91
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '打印租赁合同', NULL, NULL, NULL, NULL );
DELETE FROM myAction WHERE ObjectType='' AND ActionCode=92
Insert into myAction (ObjectType,ActionGUID,ActionCode,ActionName,Comments,InvokeClass,InvokeFunction,Assembly)
values ( '', NEWID(), '', '导出租赁合同', 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。
有啥问题可以在这留言，觉的该工具有用的话记得在公司多转下邮件，让更多人可以早点回去陪女朋友。不说了，说多了都是泪。