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
View Code

 

新增生成的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 );*/
View Code

 

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>;
View Code

 

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>
View Code

 

 

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&amp;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>
View Code

 

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="保存&amp;关闭" tip="保存&amp;关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/>
                        <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&amp;新增" tip="保存&amp;新增" 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&amp;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="保存&amp;关闭" tip="保存&amp;关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/>
                        <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&amp;新增" tip="保存&amp;新增" 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>
View Code

 

 

2.5 XML解析说明

解析:

 

根据不同的类型生成对应的

Grid.xml

 

Edit.xml

 

 

  

  生成对应的代码如下

 

2.6 工具解析

修改时候是生成修改时对应的代码,类似代码片段,不会生成完整的代码集。

 

 新增的时候主要输入个对应模块的funcid 因为这个时候回生成完整的editxml 和gridxml。

 

 

 

 

有啥问题可以在这留言,觉的该工具有用的话记得在公司多转下邮件,让更多人可以早点回去陪女朋友。不说了,说多了都是泪。

 

工具地址

 

posted @ 2016-10-31 15:21  晓明的哥哥  阅读(2688)  评论(3编辑  收藏  举报