分享原创可复用且非侵入性代码生成工具(for .net)

入行IT十年了,这是本人第一次网上’献丑‘。迫于工作压力,花了大半年时间写了这个生成器以辅助开发。如有价值请多多给予建议,谢谢

好了,废话少说,开动!

 QA.

1.为什么要用代码生成器?

  当然是为了快速开发,且保证代码的一致性,便于维护。

2.代码生成器没缺点吗?

  当然有缺点了,就是它不能代替人,如果鼠标一按就生成整个系统!那我们程序员是在一边喝咖啡还是背包走人?幸好代码生成器不会那么智能..

3.代码生成器生成的代码是一锤子买卖?

  可以不是一锤子买卖,反复修改生成器的元数据,可以持久享受代码生成器的好处。

4.文中这个代码生成器有什么特点?

  1)理论上如果熟悉这个代码生成器的原理,任何人可以定制出自己希望的常用模式代码(为什么叫模式,指个人或团队实现功能的代码编写模式/习惯性代码等等),

目前生成的代码是针对的.NET平台下的ASP.NET MVC3+ EF+WCF+Web代码。

  2)非侵入性,代码可以完全定制以适应当前架构需要,而不是架构适应生成器。

  3)难度系数比较高,需要掌握antlr 文法分析+基础的java控制台编程知识+winform.net.但回报可能会远远大于付出。

5.这个工具,有人在实际中用吗?

  作者和所在开发团队在使用。效果非常好,大大的减少了开发成本和测试维护成本。

6.开源吗?

  计划中,由于个人工作太忙,等有空闲时间进行重构整理,以免仓促而误人子弟。

0.概要介绍

设计阶段:在文本编辑器里面编辑xml模型和数据模型元数据,工具会自动校验和分析,并生成相应代码和sql。

持久阶段:1. 设计阶段生成表后,工具从数据库获取最新表/视图,可以生成相应的增删改查功能也页面等等。

       2. 支持自定义参数化查询(语法采用标准sql,支持单表/多表/高级查询),自数据层到服务层,web层的生成。

     3. 反向工程:支持数据库表到设计阶段的数据模型元数据的同步,使设计永不过时并复用。

       4. 支持生成数据词典。

生成器窗口:

 

红色区域可以望文生义,不用赘述。

双击错误列表可以打开相应文件并使光标定位到错误点

1.设计阶段

  包括对xml和数据库设计的设计。

  

  1.1 Xml的Dom代码生成

  1.1.1 xml语法规则如下:

  

1.1.2 生成dom操作代码:

1.1.3 生成的代码

  1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Text;
  5 using System.Xml;
  6 using CodeHelper.Xml.Extension;
  7 using CodeHelper.Xml;
  8 
  9 namespace CodeHelper.Workflow.Designer.Core.Config
 10 {
 11 
 12     public class WorkflowDefine
 13     : DataNode
 14     {
 15         public WorkflowDefine
 16         ()
 17             : base()
 18         {
 19         }
 20 
 21         public WorkflowDefine
 22         (XmlNode dom)
 23             : base(dom)
 24         {
 25         }
 26 
 27         public WorkflowDefine
 28         (Document document)
 29             : base(document)
 30         {
 31         }
 32 
 33         public override string XML_TAG_NAME
 34         {
 35             get
 36             {
 37                 return "WorkflowDefine";
 38             }
 39             set
 40             {
 41                 throw new Exception("cannot set");
 42             }
 43         }
 44 
 45         public event ProperyChanged<string> OnId_ProperyChanged;
 46         public override string Id
 47         {
 48             get
 49             {
 50                 if (this.Dom.Attributes["Id"] == null)
 51                     return default(string);
 52                 return this.Dom.Attributes["Id"].Value.ToT<string>();
 53             }
 54             set
 55             {
 56                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
 57                   .FirstOrDefault(x => x.Name == "Id");
 58                 var oldValue = default(string);
 59                 var newValue = value;
 60                 if (attr == null)
 61                 {
 62                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Id"));
 63                 }
 64                 else
 65                 {
 66                     oldValue = this.Dom.Attributes["Id"].Value.ToT<string>();
 67                 }
 68 
 69                 if (value != null)
 70                     attr.Value = value.ToString();
 71 
 72                 if (OnId_ProperyChanged != null && oldValue != newValue)
 73                 {
 74                     OnId_ProperyChanged(oldValue, newValue);
 75                 }
 76                 this.FireAnyProperyChanged("Id", oldValue, newValue);
 77             }
 78         }
 79         public event ProperyChanged<string> OnName_ProperyChanged;
 80         public string Name
 81         {
 82             get
 83             {
 84                 if (this.Dom.Attributes["Name"] == null)
 85                     return default(string);
 86                 return this.Dom.Attributes["Name"].Value.ToT<string>();
 87             }
 88             set
 89             {
 90                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
 91                   .FirstOrDefault(x => x.Name == "Name");
 92                 var oldValue = default(string);
 93                 var newValue = value;
 94                 if (attr == null)
 95                 {
 96                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Name"));
 97                 }
 98                 else
 99                 {
100                     oldValue = this.Dom.Attributes["Name"].Value.ToT<string>();
101                 }
102 
103                 if (value != null)
104                     attr.Value = value.ToString();
105 
106                 if (OnName_ProperyChanged != null && oldValue != newValue)
107                 {
108                     OnName_ProperyChanged(oldValue, newValue);
109                 }
110                 this.FireAnyProperyChanged("Name", oldValue, newValue);
111             }
112         }
113         public event ProperyChanged<string> OnDescription_ProperyChanged;
114         public string Description
115         {
116             get
117             {
118                 if (this.Dom.Attributes["Description"] == null)
119                     return default(string);
120                 return this.Dom.Attributes["Description"].Value.ToT<string>();
121             }
122             set
123             {
124                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
125                   .FirstOrDefault(x => x.Name == "Description");
126                 var oldValue = default(string);
127                 var newValue = value;
128                 if (attr == null)
129                 {
130                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Description"));
131                 }
132                 else
133                 {
134                     oldValue = this.Dom.Attributes["Description"].Value.ToT<string>();
135                 }
136 
137                 if (value != null)
138                     attr.Value = value.ToString();
139 
140                 if (OnDescription_ProperyChanged != null && oldValue != newValue)
141                 {
142                     OnDescription_ProperyChanged(oldValue, newValue);
143                 }
144                 this.FireAnyProperyChanged("Description", oldValue, newValue);
145             }
146         }
147         public event ProperyChanged<string> OnVariable_ProperyChanged;
148         public string Variable
149         {
150             get
151             {
152                 if (this.Dom.Attributes["Variable"] == null)
153                     return default(string);
154                 return this.Dom.Attributes["Variable"].Value.ToT<string>();
155             }
156             set
157             {
158                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
159                   .FirstOrDefault(x => x.Name == "Variable");
160                 var oldValue = default(string);
161                 var newValue = value;
162                 if (attr == null)
163                 {
164                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Variable"));
165                 }
166                 else
167                 {
168                     oldValue = this.Dom.Attributes["Variable"].Value.ToT<string>();
169                 }
170 
171                 if (value != null)
172                     attr.Value = value.ToString();
173 
174                 if (OnVariable_ProperyChanged != null && oldValue != newValue)
175                 {
176                     OnVariable_ProperyChanged(oldValue, newValue);
177                 }
178                 this.FireAnyProperyChanged("Variable", oldValue, newValue);
179             }
180         }
181 
182         public FieldDef CreateFieldDef()
183         {
184             return this.Dom.CreateNode<FieldDef>();
185         }
186 
187         public NodeList<FieldDef> Fields
188         {
189             get
190             {
191                 NodeList<FieldDef> fields = null;
192                 XmlNode fields_node = null;
193 
194                 foreach (XmlNode node in this.Dom.ChildNodes)
195                 {
196                     if (node.Name == "Fields")
197                     {
198                         fields_node = node;
199                         fields = new NodeList<FieldDef>(node);
200                         break;
201                     }
202                 }
203 
204                 if (fields_node != null)
205                 {
206                     foreach (XmlNode node in fields_node.ChildNodes)
207                     {
208                         fields.AddChild(new FieldDef(node));
209                     }
210                 }
211                 else
212                 {
213                     fields = this.Dom.CreateNode<NodeList<FieldDef>>("Fields");
214 
215                     this.AddChild(fields);
216                 }
217                 return fields;
218             }
219             set
220             {
221                 throw new Exception("cannot set");
222             }
223         }
224         public ClassDef CreateClassDef()
225         {
226             return this.Dom.CreateNode<ClassDef>();
227         }
228 
229         public NodeList<ClassDef> Classes
230         {
231             get
232             {
233                 NodeList<ClassDef> classes = null;
234                 XmlNode classes_node = null;
235 
236                 foreach (XmlNode node in this.Dom.ChildNodes)
237                 {
238                     if (node.Name == "Classes")
239                     {
240                         classes_node = node;
241                         classes = new NodeList<ClassDef>(node);
242                         break;
243                     }
244                 }
245 
246                 if (classes_node != null)
247                 {
248                     foreach (XmlNode node in classes_node.ChildNodes)
249                     {
250                         classes.AddChild(new ClassDef(node));
251                     }
252                 }
253                 else
254                 {
255                     classes = this.Dom.CreateNode<NodeList<ClassDef>>("Classes");
256 
257                     this.AddChild(classes);
258                 }
259                 return classes;
260             }
261             set
262             {
263                 throw new Exception("cannot set");
264             }
265         }
266         public InitDef CreateInitDef()
267         {
268             return this.Dom.CreateNode<InitDef>();
269         }
270 
271         public InitDef Init
272         {
273             get
274             {
275                 foreach (XmlNode node in this.Dom.ChildNodes)
276                 {
277                     if (node.Name == "InitDef" &&
278                         node.Attributes["variable"] != null &&
279                         node.Attributes["variable"].Value == "Init")
280                     {
281                         return new InitDef(node);
282                     }
283                 }
284                 return null;
285             }
286             set
287             {
288                 if (this.Init != null)
289                 {
290                     this.Init.RemoveSelf();
291                 }
292 
293                 var attr = this.Dom.OwnerDocument.CreateAttribute("variable");
294                 attr.Value = "Init";
295                 value.Dom.Attributes.Append(attr);
296 
297                 this.Dom.AppendChild(value.Dom);
298             }
299         }
300         public StartStateDef CreateStartStateDef()
301         {
302             return this.Dom.CreateNode<StartStateDef>();
303         }
304 
305         public StartStateDef StartState
306         {
307             get
308             {
309                 foreach (XmlNode node in this.Dom.ChildNodes)
310                 {
311                     if (node.Name == "StartStateDef" &&
312                         node.Attributes["variable"] != null &&
313                         node.Attributes["variable"].Value == "StartState")
314                     {
315                         return new StartStateDef(node);
316                     }
317                 }
318                 return null;
319             }
320             set
321             {
322                 if (this.StartState != null)
323                 {
324                     this.StartState.RemoveSelf();
325                 }
326 
327                 var attr = this.Dom.OwnerDocument.CreateAttribute("variable");
328                 attr.Value = "StartState";
329                 value.Dom.Attributes.Append(attr);
330 
331                 this.Dom.AppendChild(value.Dom);
332             }
333         }
334         public TerminateStateDef CreateTerminateStateDef()
335         {
336             return this.Dom.CreateNode<TerminateStateDef>();
337         }
338 
339         public TerminateStateDef TerminateState
340         {
341             get
342             {
343                 foreach (XmlNode node in this.Dom.ChildNodes)
344                 {
345                     if (node.Name == "TerminateStateDef" &&
346                         node.Attributes["variable"] != null &&
347                         node.Attributes["variable"].Value == "TerminateState")
348                     {
349                         return new TerminateStateDef(node);
350                     }
351                 }
352                 return null;
353             }
354             set
355             {
356                 if (this.TerminateState != null)
357                 {
358                     this.TerminateState.RemoveSelf();
359                 }
360 
361                 var attr = this.Dom.OwnerDocument.CreateAttribute("variable");
362                 attr.Value = "TerminateState";
363                 value.Dom.Attributes.Append(attr);
364 
365                 this.Dom.AppendChild(value.Dom);
366             }
367         }
368         public StateDef CreateStateDef()
369         {
370             return this.Dom.CreateNode<StateDef>();
371         }
372 
373         public NodeList<StateDef> States
374         {
375             get
376             {
377                 NodeList<StateDef> states = null;
378                 XmlNode states_node = null;
379 
380                 foreach (XmlNode node in this.Dom.ChildNodes)
381                 {
382                     if (node.Name == "States")
383                     {
384                         states_node = node;
385                         states = new NodeList<StateDef>(node);
386                         break;
387                     }
388                 }
389 
390                 if (states_node != null)
391                 {
392                     foreach (XmlNode node in states_node.ChildNodes)
393                     {
394                         states.AddChild(new StateDef(node));
395                     }
396                 }
397                 else
398                 {
399                     states = this.Dom.CreateNode<NodeList<StateDef>>("States");
400 
401                     this.AddChild(states);
402                 }
403                 return states;
404             }
405             set
406             {
407                 throw new Exception("cannot set");
408             }
409         }
410         public ParallelDef CreateParallelDef()
411         {
412             return this.Dom.CreateNode<ParallelDef>();
413         }
414 
415         public NodeList<ParallelDef> Parallels
416         {
417             get
418             {
419                 NodeList<ParallelDef> parallels = null;
420                 XmlNode parallels_node = null;
421 
422                 foreach (XmlNode node in this.Dom.ChildNodes)
423                 {
424                     if (node.Name == "Parallels")
425                     {
426                         parallels_node = node;
427                         parallels = new NodeList<ParallelDef>(node);
428                         break;
429                     }
430                 }
431 
432                 if (parallels_node != null)
433                 {
434                     foreach (XmlNode node in parallels_node.ChildNodes)
435                     {
436                         parallels.AddChild(new ParallelDef(node));
437                     }
438                 }
439                 else
440                 {
441                     parallels = this.Dom.CreateNode<NodeList<ParallelDef>>("Parallels");
442 
443                     this.AddChild(parallels);
444                 }
445                 return parallels;
446             }
447             set
448             {
449                 throw new Exception("cannot set");
450             }
451         }
452         public SubFlowStateDef CreateSubFlowStateDef()
453         {
454             return this.Dom.CreateNode<SubFlowStateDef>();
455         }
456 
457         public NodeList<SubFlowStateDef> SubFlowStates
458         {
459             get
460             {
461                 NodeList<SubFlowStateDef> subFlowStates = null;
462                 XmlNode subFlowStates_node = null;
463 
464                 foreach (XmlNode node in this.Dom.ChildNodes)
465                 {
466                     if (node.Name == "SubFlowStates")
467                     {
468                         subFlowStates_node = node;
469                         subFlowStates = new NodeList<SubFlowStateDef>(node);
470                         break;
471                     }
472                 }
473 
474                 if (subFlowStates_node != null)
475                 {
476                     foreach (XmlNode node in subFlowStates_node.ChildNodes)
477                     {
478                         subFlowStates.AddChild(new SubFlowStateDef(node));
479                     }
480                 }
481                 else
482                 {
483                     subFlowStates = this.Dom.CreateNode<NodeList<SubFlowStateDef>>("SubFlowStates");
484 
485                     this.AddChild(subFlowStates);
486                 }
487                 return subFlowStates;
488             }
489             set
490             {
491                 throw new Exception("cannot set");
492             }
493         }
494     }
495 
496     public class StartStateDef
497     : DataNode
498     {
499         public StartStateDef
500         ()
501             : base()
502         {
503         }
504 
505         public StartStateDef
506         (XmlNode dom)
507             : base(dom)
508         {
509         }
510 
511         public StartStateDef
512         (Document document)
513             : base(document)
514         {
515         }
516 
517         public override string XML_TAG_NAME
518         {
519             get
520             {
521                 return "StartStateDef";
522             }
523             set
524             {
525                 throw new Exception("cannot set");
526             }
527         }
528 
529         public event ProperyChanged<string> OnId_ProperyChanged;
530         public override string Id
531         {
532             get
533             {
534                 if (this.Dom.Attributes["Id"] == null)
535                     return default(string);
536                 return this.Dom.Attributes["Id"].Value.ToT<string>();
537             }
538             set
539             {
540                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
541                   .FirstOrDefault(x => x.Name == "Id");
542                 var oldValue = default(string);
543                 var newValue = value;
544                 if (attr == null)
545                 {
546                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Id"));
547                 }
548                 else
549                 {
550                     oldValue = this.Dom.Attributes["Id"].Value.ToT<string>();
551                 }
552 
553                 if (value != null)
554                     attr.Value = value.ToString();
555 
556                 if (OnId_ProperyChanged != null && oldValue != newValue)
557                 {
558                     OnId_ProperyChanged(oldValue, newValue);
559                 }
560                 this.FireAnyProperyChanged("Id", oldValue, newValue);
561             }
562         }
563         public event ProperyChanged<string> OnName_ProperyChanged;
564         public string Name
565         {
566             get
567             {
568                 if (this.Dom.Attributes["Name"] == null)
569                     return default(string);
570                 return this.Dom.Attributes["Name"].Value.ToT<string>();
571             }
572             set
573             {
574                 var attr = this.Dom.Attributes.OfType<XmlAttribute>()
575                   .FirstOrDefault(x => x.Name == "Name");
576                 var oldValue = default(string);
577                 var newValue = value;
578                 if (attr == null)
579                 {
580                     attr = this.Dom.Attributes.Append(this.Dom.OwnerDocument.CreateAttribute("Name"));
581                 }
582                 else
583                 {
584                     oldValue = this.Dom.Attributes["Name"].Value.ToT<string>();
585                 }
586 
587                 if (value != null)
588                     attr.Value = value.ToString();
589 
590                 if (OnName_ProperyChanged != null && oldValue != newValue)
591                 {
592                     OnName_ProperyChanged(oldValue, newValue);
593                 }
594                 this.FireAnyProperyChanged("Name", oldValue, newValue);
595             }
596         }
597 
598     }
599 
600     //此处省略3000行...
601 }
View Code


1.2 数据表及关系设计

1.2.1 数据语法如下:

1.2.2 生成数据库sql

1.2.3 生成的sql

 1 IF OBJECT_ID(N'People',N'U') IS NOT NULL
 2 DROP TABLE [dbo].[People];
 3 CREATE TABLE [dbo].[People](
 4 [Id] int NOT NULL,
 5 [Name] nvarchar(200) ,
 6 [UserId] int ,
 7 [SchoolId] int ,
 8 [Status] int ,
 9  CONSTRAINT [PK_People] PRIMARY KEY CLUSTERED 
10 (
11     [Id] ASC
12 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF
13     , ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
14 ) ON [PRIMARY]
15 
16 GO
View Code

 

1.3 持久化阶段

1.3.1 新建连接串

1.3.2 刷新链接,获取数据库所有的表和视图信息

刷新结果:

1.3.3 弹出生成操作

1.3.4 实体层生成

1.3.4.1 生成的EF实体类:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using Domain.Entities;
 6 using Domain.AggregateRoot;
 7 
 8 namespace AAA
 9 {
10 
11     public class People : Entity, IAggregateRoot
12     {
13         public People()
14         {
15         }
16         public People(System.Int32 id)
17             : base(id)
18         {
19         }
20         /// <summary>
21         ///
22         /// </summary>
23         public DateTime? CreateTime
24         { get; set; }
25 
26         /// <summary>
27         ///
28         /// </summary>
29         public String Name
30         { get; set; }
31 
32         /// <summary>
33         ///
34         /// </summary>
35         public Int32? SchoolId
36         { get; set; }
37 
38         /// <summary>
39         ///
40         /// </summary>
41         public Int32? Status
42         { get; set; }
43 
44         /// <summary>
45         ///
46         /// </summary>
47         public DateTime? UpdateTime
48         { get; set; }
49 
50         /// <summary>
51         ///
52         /// </summary>
53         public Int32? UserId
54         { get; set; }
55 
56         /// <summary>
57         ///
58         /// </summary>
59         public virtual User User
60         { get; set; }
61 
62         /// <summary>
63         ///
64         /// </summary>
65         public virtual School School
66         { get; set; }
67 
68         public void AssignFrom(People other)
69         {
70             this.CreateTime = other.CreateTime;
71             this.Name = other.Name;
72             this.SchoolId = other.SchoolId;
73             this.Status = other.Status;
74             this.UpdateTime = other.UpdateTime;
75             this.UserId = other.UserId;
76         }
77     }
78 }
View Code

1.3.4.2 生成的EF映射类:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using Domain.Repository;
 6 
 7 namespace AAA
 8 {
 9 
10     public interface IPeopleRepository : IRepository<People>, IDisposable
11     {
12         List<People> GetList(List<Guid> id_list);
13     }
14 }
View Code

弹出生成Repository操作:

1.3.4.3 Repository接口代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using Domain.Repository;
 6 
 7 namespace AAA
 8 {
 9 
10     public interface IPeopleRepository : IRepository<People>, IDisposable
11     {
12         List<People> GetList(List<Guid> id_list);
13     }
14 }
View Code

1.3.4.4 Specification规约代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using Domain.Specification;
 6 
 7 namespace AAA
 8 {
 9 
10     public static class PeopleSpecification
11     {
12         public static ISpecification<People> GetList(List<Guid> id_list)
13         {
14             return new DirectSpecification<People>(x => id_list.Contains(x.Id));
15         }
16     }
17 }
View Code

1.3.4.5 Repository实现代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using Data;
 6 using Data.Repository;
 7 
 8 namespace AAA
 9 {
10 
11     public class PeopleRepository : Repository<People>, IPeopleRepository
12     {
13         public PeopleRepository(IQueryableUnitOfWork unitOfWork)
14             : base(unitOfWork)
15         {
16         }
17 
18         public List<People> GetList(List<Guid> id_list)
19         {
20             return this.GetAll(PeopleSpecification.GetList(id_list)).ToList();
21         }
22 
23         public void Dispose()
24         {
25             //throw new NotImplementedException();
26         }
27     }
28 }
View Code

1.3.5 Service层生成

1.3.5.1 弹出生成WCF操作:

1.3.5.2 生成DTO代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Runtime.Serialization;
 6 
 7 namespace AAA
 8 {
 9 
10     [DataContract]
11     public class PeopleDto
12     {
13         /// <summary>
14         ///
15         /// </summary>
16         [DataMember]
17         public DateTime? CreateTime
18         { get; set; }
19 
20         /// <summary>
21         ///
22         /// </summary>
23         [DataMember]
24         public Int32 Id
25         { get; set; }
26 
27         /// <summary>
28         ///
29         /// </summary>
30         [DataMember]
31         public String Name
32         { get; set; }
33 
34         /// <summary>
35         ///
36         /// </summary>
37         [DataMember]
38         public Int32? SchoolId
39         { get; set; }
40 
41         /// <summary>
42         ///
43         /// </summary>
44         [DataMember]
45         public Int32? Status
46         { get; set; }
47 
48         /// <summary>
49         ///
50         /// </summary>
51         [DataMember]
52         public DateTime? UpdateTime
53         { get; set; }
54 
55         /// <summary>
56         ///
57         /// </summary>
58         [DataMember]
59         public Int32? UserId
60         { get; set; }
61 
62     }
63 }
View Code

1.3.5.3 生成实体转DTO代码:(建议用automap替代)

 1  public static PeopleDto ConvertToPeopleDto(People entity)
 2  {
 3     return new PeopleDto{
 4       Id = entity.Id,
 5       Name = entity.Name,
 6       SchoolId = entity.SchoolId,
 7       Status = entity.Status,
 8       UserId = entity.UserId,
 9     };
10  }
View Code

1.3.5.4 生成DTO转实体代码:(建议用automap替代)

1  public static People ConvertToPeople(PeopleDto entityDto)
2  {
3     return new People(entityDto.Id){
4       Name = entityDto.Name,
5       SchoolId = entityDto.SchoolId,
6       Status = entityDto.Status,
7       UserId = entityDto.UserId,
8     };
9  }
View Code

1.3.5.5 生成基本Servie代码:(基础增删改查)

  1         #region App Service Interface
  2 
  3         ReturnInfoDto AddPeople(PeopleDto peopleDto);
  4 
  5         ReturnInfoDto UpdatePeople(PeopleDto peopleDto);
  6 
  7         ReturnInfoDto<PeopleDto> GetPeople(Guid id);
  8 
  9         ReturnInfoDto<List<PeopleDto>> GetPeopleList(List<Guid> id_list);
 10 
 11         ReturnInfoDto DeletePeople(Guid id);
 12 
 13         ReturnInfoDto DeletePeople(List<Guid> id_list);
 14 
 15         #endregion
 16 
 17         #region App Service Implement
 18 
 19         public ReturnInfoDto AddPeople(PeopleDto peopleDto)
 20         {
 21             var rtnInfo = new ReturnInfoDto();
 22             rtnInfo.Message = string.Empty;
 23             rtnInfo.IsSuccess = false;
 24             try
 25             {
 26                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
 27                 {
 28                     var peopleDB = new PeopleRepository(unitOfWork);
 29                     var people = DataConverter.ConvertToPeople(peopleDto);
 30                     peopleDB.Add(people);
 31                     unitOfWork.Commit();
 32                 }
 33             }
 34             catch (Exception ex)
 35             {
 36                 rtnInfo.Message = ex.Message;
 37                 return rtnInfo;
 38             }
 39 
 40             rtnInfo.IsSuccess = true;
 41             return rtnInfo;
 42         }
 43 
 44         public ReturnInfoDto UpdatePeople(PeopleDto peopleDto)
 45         {
 46             var rtnInfo = new ReturnInfoDto();
 47             rtnInfo.Message = string.Empty;
 48             rtnInfo.IsSuccess = false;
 49             try
 50             {
 51                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
 52                 {
 53                     var peopleDB = new PeopleRepository(unitOfWork);
 54                     var info = peopleDB.Get(peopleDto.Id);
 55                     if (info == null)
 56                     {
 57                         rtnInfo.Message = "the data is not in system.";
 58                         return rtnInfo;
 59                     }
 60                     var other = DataConverter.ConvertToPeople(peopleDto);
 61                     info.AssignFrom(other);
 62                     peopleDB.Modify(info);
 63                     unitOfWork.Commit();
 64                 }
 65             }
 66             catch (Exception ex)
 67             {
 68                 rtnInfo.Message = ex.Message;
 69                 return rtnInfo;
 70             }
 71 
 72             rtnInfo.IsSuccess = true;
 73             return rtnInfo;
 74         }
 75 
 76         public ReturnInfoDto<PeopleDto> GetPeople(Guid id)
 77         {
 78             var rtnInfo = new ReturnInfoDto<PeopleDto>();
 79             rtnInfo.Message = string.Empty;
 80             rtnInfo.IsSuccess = false;
 81             try
 82             {
 83                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
 84                 {
 85                     var peopleDB = new PeopleRepository(unitOfWork);
 86                     var people = peopleDB.Get(id);
 87                     if(people != null)
 88                     {
 89                         rtnInfo.Data = DataConverter.ConvertToPeopleDto(people);
 90                     }
 91                 }
 92             }
 93             catch (Exception ex)
 94             {
 95                 rtnInfo.Message = ex.Message;
 96                 return rtnInfo;
 97             }
 98 
 99             rtnInfo.IsSuccess = true;
100             return rtnInfo;
101         }
102 
103         public ReturnInfoDto<List<PeopleDto>> GetPeopleList(List<Guid> id_list)
104         {
105             var rtnInfo = new ReturnInfoDto<List<PeopleDto>>();
106             rtnInfo.Message = string.Empty;
107             rtnInfo.IsSuccess = false;
108             rtnInfo.Data = new List<PeopleDto>();
109             try
110             {
111                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
112                 {
113                     var peopleDB = new PeopleRepository(unitOfWork);
114                     var list = peopleDB.GetList(id_list);
115                     if(list != null && list.Count > 0 )
116                     {
117                         list.ForEach( x => rtnInfo.Data.Add(DataConverter.ConvertToPeopleDto(x)));
118                     }
119                 }
120             }
121             catch (Exception ex)
122             {
123                 rtnInfo.Message = ex.Message;
124                 return rtnInfo;
125             }
126 
127             rtnInfo.IsSuccess = true;
128             return rtnInfo;
129         }
130 
131         public ReturnInfoDto DeletePeople(Guid id)
132         {
133             var rtnInfo = new ReturnInfoDto();
134             rtnInfo.Message = string.Empty;
135             rtnInfo.IsSuccess = false;
136             try
137             {
138                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
139                 {
140                     var peopleDB = new PeopleRepository(unitOfWork);
141                     var people = peopleDB.Get(id);
142                     if(people == null )
143                     {
144                         rtnInfo.Message = "the data is not in system.";
145                         return rtnInfo;
146                     }
147                     //people.Available = false;
148                     //peopleDB.Modify(people);
149                     peopleDB.Remove(people);
150                     unitOfWork.Commit();
151                 }
152             }
153             catch (Exception ex)
154             {
155                 rtnInfo.Message = ex.Message;
156                 return rtnInfo;
157             }
158 
159             rtnInfo.IsSuccess = true;
160             return rtnInfo;
161         }
162 
163         public ReturnInfoDto DeletePeople(List<Guid> id_list)
164         {
165             var rtnInfo = new ReturnInfoDto();
166             rtnInfo.Message = string.Empty;
167             rtnInfo.IsSuccess = false;
168             try
169             {
170                 using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
171                 {
172                     var peopleDB = new PeopleRepository(unitOfWork);
173                     var people_list = peopleDB.GetList(id_list);
174                     foreach (var people in people_list)
175                     {
176                         //people.Available = false;
177                         //peopleDB.Modify(people);
178                         peopleDB.Remove(people);
179                     }
180                     unitOfWork.Commit();
181                 }
182             }
183             catch (Exception ex)
184             {
185                 rtnInfo.Message = ex.Message;
186                 return rtnInfo;
187             }
188 
189             rtnInfo.IsSuccess = true;
190             return rtnInfo;
191         }
192 
193         #endregion
194 
195         #region Distribute Service Interface
196 
197         [OperationContract]
198         [WithoutAuthorization]
199         [FaultContractAttribute(typeof(UnAuthorization))]
200         ReturnInfoDto AddPeople(PeopleDto peopleDto);
201 
202         [OperationContract]
203         [WithoutAuthorization]
204         [FaultContractAttribute(typeof(UnAuthorization))]
205         ReturnInfoDto UpdatePeople(PeopleDto peopleDto);
206 
207         [OperationContract]
208         [WithoutAuthorization]
209         [FaultContractAttribute(typeof(UnAuthorization))]
210         ReturnInfoDto<PeopleDto> GetPeople(Guid id);
211 
212         [OperationContract]
213         [WithoutAuthorization]
214         [FaultContractAttribute(typeof(UnAuthorization))]
215         ReturnInfoDto<List<PeopleDto>> GetPeopleList(List<Guid> id_list);
216 
217         [OperationContract]
218         [WithoutAuthorization]
219         [FaultContractAttribute(typeof(UnAuthorization))]
220         ReturnInfoDto DeletePeople(Guid id);
221 
222         [OperationContract]
223         [WithoutAuthorization]
224         [FaultContractAttribute(typeof(UnAuthorization))]
225         ReturnInfoDto DeletePeopleList(List<Guid> id_list);
226 
227         #endregion
228 
229         #region Distribute Service Implement
230 
231         public ReturnInfoDto AddPeople(PeopleDto peopleDto)
232         {
233             return _appService.AddPeople(peopleDto);
234         }
235 
236         public ReturnInfoDto UpdatePeople(PeopleDto peopleDto)
237         {
238             return _appService.UpdatePeople(peopleDto);
239         }
240 
241         public ReturnInfoDto<PeopleDto> GetPeople(Guid id)
242         {
243             return _appService.GetPeople( id );
244         }
245 
246         public ReturnInfoDto<List<PeopleDto>> GetPeopleList(List<Guid> id_list)
247         {
248             return _appService.GetPeopleList( id_list );
249         }
250 
251         public ReturnInfoDto DeletePeople(Guid id)
252         {
253             return _appService.DeletePeople( id );
254         }
255 
256         public ReturnInfoDto DeletePeopleList(List<Guid> id_list)
257         {
258             return _appService.DeletePeople( id_list );
259         }
260 
261         #endregion
262 
263         #region Service Layer
264 
265         public ReturnInfo AddPeople(PeopleInfo peopleInfo)
266         {
267             var result = new ReturnInfo();
268 
269             try
270             {
271                 var dto = DataConverter.ConvertToPeopleDto(peopleInfo);
272                 var rslt = serviceClient.Invoke<ReturnInfoDto>(x => x.AddPeople(dto));
273                 result.IsSuccess = rslt.IsSuccess;
274                 result.Message = rslt.Message;
275                 
276             }
277             catch (Exception e)
278             {
279                 LogHelper.Error(e);
280                 result.IsSuccess = false;
281                 result.Message = "call service error";
282             }
283 
284             return result;
285         }
286 
287         public ReturnInfo UpdatePeople(PeopleInfo peopleInfo)
288         {
289             var result = new ReturnInfo();
290 
291             try
292             {
293                 var dto = DataConverter.ConvertToPeopleDto(peopleInfo);
294                 var rslt = serviceClient.Invoke<ReturnInfoDto>(x => x.UpdatePeople(dto));
295                 result.IsSuccess = rslt.IsSuccess;
296                 result.Message = rslt.Message;
297                 
298             }
299             catch (Exception e)
300             {
301                 LogHelper.Error(e);
302                 result.IsSuccess = false;
303                 result.Message = "call service error";
304             }
305 
306             return result;
307         }
308 
309         public ReturnInfo<PeopleInfo> GetPeople(Guid id)
310         {
311             var result = new ReturnInfo<PeopleInfo>();
312 
313             try
314             {
315                 var rslt = serviceClient.Invoke<ReturnInfoDto<PeopleDto>>(x => x.GetPeople(id));
316                 result.Data = DataConverter.ConvertToPeopleInfo(rslt.Data);
317                 result.IsSuccess = rslt.IsSuccess;
318                 result.Message = rslt.Message;
319                 
320             }
321             catch (Exception e)
322             {
323                 LogHelper.Error(e);
324                 result.IsSuccess = false;
325                 result.Message = "call service error";
326             }
327 
328             return result;
329         }
330 
331         public ReturnInfo<List<PeopleInfo>> GetPeopleList(List<Guid> id_list)
332         {
333             var result = new ReturnInfo<List<PeopleInfo>>();
334             result.Data = new List<PeopleInfo>();
335 
336             try
337             {
338                 var rslt = serviceClient.Invoke<ReturnInfoDto<List<PeopleDto>>>(x => x.GetPeopleList(id_list));
339                 result.IsSuccess = rslt.IsSuccess;
340                 result.Message = rslt.Message;
341                 if (rslt.IsSuccess )
342                 {
343                     if (rslt.Data != null && rslt.Data.Count > 0)
344                     {
345                         rslt.Data.ForEach(x => result.Data.Add(DataConverter.ConvertToPeopleInfo(x)));
346                     }
347                 }
348             }
349             catch (Exception e)
350             {
351                 LogHelper.Error(e);
352                 result.IsSuccess = false;
353                 result.Message = "call service error";
354             }
355 
356             return result;
357         }
358 
359         public ReturnInfo DeletePeople(Guid id)
360         {
361             var result = new ReturnInfo();
362 
363             try
364             {
365                 var rslt = serviceClient.Invoke<ReturnInfoDto>(x => x.DeletePeople(id));
366                 result.IsSuccess = rslt.IsSuccess;
367                 result.Message = rslt.Message;
368                 
369             }
370             catch (Exception e)
371             {
372                 LogHelper.Error(e);
373                 result.IsSuccess = false;
374                 result.Message = "call service error";
375             }
376 
377             return result;
378         }
379 
380         public ReturnInfo DeletePeople(List<Guid> id_list)
381         {
382             var result = new ReturnInfo();
383 
384             try
385             {
386                 var rslt = serviceClient.Invoke<ReturnInfoDto>(x => x.DeletePeopleList(id_list));
387                 result.IsSuccess = rslt.IsSuccess;
388                 result.Message = rslt.Message;
389                 
390             }
391             catch (Exception e)
392             {
393                 LogHelper.Error(e);
394                 result.IsSuccess = false;
395                 result.Message = "call service error";
396             }
397 
398             return result;
399         }
400 
401         #endregion
View Code

1.3.5.6 生成CCFlowService:此处省略(比较私有)

1.3.6 Web层生成

1.3.6.1 弹出ViewMode生成操作:

1.3.6.2 生成ViewModel代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Runtime.Serialization;
 6 
 7 namespace AAA
 8 {
 9 
10     public class PeopleInfo
11     {
12         /// <summary>
13         ///
14         /// </summary>
15         public DateTime? CreateTime
16         { get; set; }
17 
18         /// <summary>
19         ///
20         /// </summary>
21         public Int32 Id
22         { get; set; }
23 
24         /// <summary>
25         ///
26         /// </summary>
27         public String Name
28         { get; set; }
29 
30         /// <summary>
31         ///
32         /// </summary>
33         public Int32? SchoolId
34         { get; set; }
35 
36         /// <summary>
37         ///
38         /// </summary>
39         public Int32? Status
40         { get; set; }
41 
42         /// <summary>
43         ///
44         /// </summary>
45         public DateTime? UpdateTime
46         { get; set; }
47 
48         /// <summary>
49         ///
50         /// </summary>
51         public Int32? UserId
52         { get; set; }
53 
54     }
55 }
View Code

1.3.6.3 生成ViewModel转WCF DTO代码:(建议用automapper替代)

 1  public static PeopleDto ConvertToPeopleDto(PeopleInfo info)
 2  {
 3     return new PeopleDto{
 4       Id = info.Id,
 5       Name = info.Name,
 6       SchoolId = info.SchoolId,
 7       Status = info.Status,
 8       UserId = info.UserId,
 9     };
10  }
View Code

1.3.6.4 生成WCF DTO转ViewModel代码:(建议用automapper替代)

 1  public static PeopleInfo ConvertToPeopleInfo(PeopleDto dto )
 2  {
 3     return new PeopleInfo(){
 4       Id = dto.Id,
 5       Name = dto.Name,
 6       SchoolId = dto.SchoolId,
 7       Status = dto.Status,
 8       UserId = dto.UserId,
 9     };
10  }
View Code

1.3.6.5 弹出生成View操作:

1.3.6.6 生成编辑页面Model代码:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Runtime.Serialization;
 6 namespace AAA
 7 {
 8 
 9     public class PeopleInfo
10     {
11         /// <summary>
12         ///
13         /// </summary>
14         public DateTime? CreateTime
15         { get; set; }
16 
17         /// <summary>
18         ///
19         /// </summary>
20         public Int32 Id
21         { get; set; }
22 
23         /// <summary>
24         ///
25         /// </summary>
26         public String Name
27         { get; set; }
28 
29         /// <summary>
30         ///
31         /// </summary>
32         public Int32? SchoolId
33         { get; set; }
34 
35         /// <summary>
36         ///
37         /// </summary>
38         public Int32? Status
39         { get; set; }
40 
41         /// <summary>
42         ///
43         /// </summary>
44         public DateTime? UpdateTime
45         { get; set; }
46 
47         /// <summary>
48         ///
49         /// </summary>
50         public Int32? UserId
51         { get; set; }
52 
53     }
54 }
View Code

1.3.6.7 生成编辑页面代码:

  1 @model EditPeopleModel
  2 @{
  3     Layout = "~/Views/Shared/_SimpleLayout.cshtml";
  4 
  5     if(this.Model.Id.HasValue){
  6         ViewBag.Title = "Edit Item";
  7     }
  8     else{
  9         ViewBag.Title = "Add Item";
 10     }
 11 }
 12 
 13 @section js{
 14 <script src="../../Scripts/jquery.validate.js" type="text/javascript"></script>
 15 <script language = "javascript" type="text/javascript">
 16         function OnClose(refresh) {
 17             if (parent.MsgBox != undefined) {
 18 
 19                 if (refresh) {
 20                     if (parent.MsgBox.Callback != null) {
 21                         parent.MsgBox.Callback();
 22                         parent.MsgBox.Callback = null;
 23                     }
 24                 }
 25                 parent.MsgBox.Callback = null;
 26 
 27                 parent.MsgBox.Close();
 28 
 29             }
 30             else {
 31                 window.close();
 32             }
 33         }
 34         
 35         $(function () {
 36 
 37             if (parent.MsgBox != undefined) {
 38                 parent.MsgBox.CancelCallback = true;
 39             }
 40 
 41             $('#btnSaveAndClose').click(function () {
 42 
 43                 $('#IsSave').val(true);
 44 
 45                 $('#editForm').submit();
 46 
 47             });
 48 
 49             $('#btnCancel').click(function () {
 50 
 51                 OnClose();
 52 
 53             });
 54 
 55             if ($('#IsSave').val() == 'True') {
 56                 var msg = $('#ErrorMsg').val();
 57                 if (msg == '') {
 58                     jAlert('Save Success','Tip',function(){
 59                         OnClose(true);
 60                     });                    
 61                 }
 62                 else {
 63                     jAlert(msg);
 64                 }
 65             }
 66 
 67             $('#somecontrolId').attr('readonly','true').addClass('readonly');
 68 
 69             $('select').each(function(){
 70                             $(this).val($(this).attr('_value'));
 71             });
 72 
 73             var validator = $('#editForm').validate({
 74                 debug: true,       //调试模式取消submit的默认提交功能  
 75                 errorClass: 'error', //默认为错误的样式类为:error  
 76                 focusInvalid: false,
 77                 onkeyup: false,
 78                 submitHandler: function (form) {   //表单提交句柄,为一回调函数,带一个参数:form  
 79                     //alert('提交表单');
 80                     form.submit();   //提交表单  
 81                 },
 82                 rules: {           //定义验证规则,其中属性名为表单的name属性      
 83                     Name:{
 84                     },
 85                     SchoolId:{
 86                     },
 87                     Status:{
 88                     },
 89                     UserId:{
 90                     }
 91 
 92                 },
 93 
 94                 messages: {       //自定义验证消息  
 95                     PurchasePlan: {
 96                         //required: 'required !',
 97                         //minlength: $.format('用户名至少要{0}个字符!'),
 98                         //remote: $.format('{0}已经被占用')
 99                     },                   
100                 },
101                errorPlacement: function (error, element) {
102                     var noHtml = '<div class="notification error" for="' + error.attr('for') + '">' +
103                             "<a class=\"close\" ><img alt=\"close\" title=\"Close this notification\" src=\"/Content/images/cross_grey_small.png\"></a>" +
104                             '<div>' + error.html() + '</div>' + '</div>';
105                     var notification = element.parent().find('div');
106                     if (notification.length > 0) {
107                         notification.remove();
108                     }
109                     element.parent().find('span').hide();
110                     $(noHtml).appendTo(element.parent());
111                     error.html('');
112                     error.appendTo(element.parent());
113                 },
114                 highlight: function (element, errorClass) {  //针对验证的表单设置高亮  
115                     //$(element).addClass(errorClass);
116                 },
117                 success: function (element) {
118                     element.parent().find('span').show();
119                     element.parent().find('div.error,label.validateError').remove();
120                 }});
121         });
122     </script>
123 
124 }
125 
126 @section css{
127      
128     <style type="text/css">   
129     body
130     {
131         background: none;
132     }
133     .field
134     {
135         vertical-align: middle;
136         clear: both;
137         padding-left: 5px;
138         padding-top: 5px;
139         padding-bottom: 5px;
140     }
141     .field_name
142     {
143         width: 160px;
144         float: left;
145         padding-right: 10px;
146         padding-top: 10px;
147         margin: 0 auto;
148     }
149     .field_value
150     {
151         width: 260px;
152         float: left;
153     }
154     custom-combobox input
155     {
156         width: 120px;
157     }
158     .operation
159     {
160         margin-top: 20px;
161         padding-top: 20px;
162         clear: both;
163     }
164     input
165     {
166         width: 206px;
167     }
168     select
169     {
170         width: 220px;
171     }
172     .readonly
173     {
174         background-color: #e6e6e6;
175     }
176     </style>
177 
178 }
179 
180     <div class="tabmini-content">
181         <form method="post" id="editForm" class="form" action="/xxx/EditPeopleItem">
182 
183     <input type='hidden' id='Id' name='Id' value='@Model.Id' />
184     <input type='hidden' id='IsPostBack' name='IsPostBack' value='true' />    
185     <input type='hidden' id='IsSave' name='IsSave' value='@Model.IsSave' />
186     <input type='hidden' id='ErrorMsg' name='ErrorMsg' value='@Model.ErrorMsg' />
187 
188         <fieldset  class="ConfigArea">
189             <div class="field">
190                 <div class="field_name">
191                     <label>Name:</label>
192                 </div>
193                 <div class="field_value">
194                     <input type="text" name="Name" id="Name" value="@Model.Name"/>
195                 </div>
196             </div>
197             <div class="field">
198                 <div class="field_name">
199                     <label>SchoolId:</label>
200                 </div>
201                 <div class="field_value">
202                     <input type="text" name="SchoolId" id="SchoolId" value="@Model.SchoolId"/>
203                 </div>
204             </div>
205             <div class="field">
206                 <div class="field_name">
207                     <label>Status:</label>
208                 </div>
209                 <div class="field_value">
210                     <input type="text" name="Status" id="Status" value="@Model.Status"/>
211                 </div>
212             </div>
213             <div class="field">
214                 <div class="field_name">
215                     <label>UserId:</label>
216                 </div>
217                 <div class="field_value">
218                     <input type="text" name="UserId" id="UserId" value="@Model.UserId"/>
219                 </div>
220             </div>
221         <div class='operation'>
222             <a class='button blue' id='btnSaveAndClose'>Save&Close</a> <a class='button blue'
223                 id='btnCancel'>Cancel</a>
224         </div>
225         </fieldset>
226     </form>
227 </div>
View Code

1.3.6.8 弹出生成MVC代码操作:

1.3.6.9 生成Action代码:

 1     public ActionResult EditPeople(EditPeopleModel model)
 2     {
 3 
 4         //model.UserId = Motorola.ZCH49.OaSystem.WebSite.Models.User.GetCurrentUser(this).Id;
 5         model.Action();
 6         return View(model);
 7 
 8     }
 9 
10     [HttpPost]
11     public ActionResult DeletePeople(Guid id)
12     {
13         var model = new ReturnInfo();
14 
15         if (id == default(Guid))
16         {
17             model.Message = "no id";
18         }
19         else
20         {
21              model = EditPeopleModel.DeletePeople(id);
22         }
23         return Json(model, JsonRequestBehavior.AllowGet);
24         
25     }
26 
27     [HttpPost]
28     public ActionResult DeletePeople(List<Guid> idList)
29     {
30         var model = new ReturnInfo();
31 
32         if (idList == null || idList.Count == 0)
33         {
34             model.Message = "no id";
35         }
36         else
37         {
38              model = EditPeopleModel.DeletePeople(idList);
39         }
40         return Json(model, JsonRequestBehavior.AllowGet);
41         
42     }
View Code

1.3.7 视图的相关操作和表操作一样

1.4 自定义查询(解决常见查询动态参数化问题)

1.4.1 创建查询集(类似文件夹/目录概念,对查询进行管理)

1.4.2 创建查询

1.4.3 编辑查询

语法和语义同标准sql,主要用于动态的参数化查询,一下为一个常用查询的参数化(分页,各字段的排序,参数提取)

实例代码主要是EF查相关,其他的代码生成省略。

1.4.3.1 生成的查询条件类:

 1 using System;
 2 using System.Collections.Generic;
 3 
 4 namespace xxx
 5 {
 6     public class People_Query_Condition
 7     {
 8         public enum OrderByType
 9         {
10             CreateTime_Asc,
11             CreateTime_Desc,
12             Id_Asc,
13             Id_Desc,
14             Name_Asc,
15             Name_Desc,
16             SchoolId_Asc,
17             SchoolId_Desc,
18             Status_Asc,
19             Status_Desc,
20             UpdateTime_Asc,
21             UpdateTime_Desc,
22             UserId_Asc,
23             UserId_Desc,
24 
25         }
26 
27         public OrderByType? OrderBy { get; set; }
28 
29         public DateTime? CreateTime_Begin
30         { get; set; }
31 
32         public DateTime? CreateTime_End
33         { get; set; }
34 
35         public int? Id
36         { get; set; }
37 
38         public List<int> Ids
39         { get; set; }
40 
41         public string Name
42         { get; set; }
43 
44         public int? SchoolId
45         { get; set; }
46 
47         public int? Status
48         { get; set; }
49 
50         public int? UserId
51         { get; set; }
52 
53 
54         public int PageIndex { get; set; }
55         public int PageSize { get; set; }
56         public int RecordCount { get; set; }
57         public People_Query_Condition()
58         {
59             this.Ids = new List<int>();
60         }
61     }
62 }
View Code

1.4.3.2 生成的查询DTO类:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Runtime.Serialization;
 4 
 5 namespace xxx
 6 {
 7     [DataContract]
 8     public class People_Query_ConditionDto
 9     {
10         [DataContract]
11         public enum OrderByType
12         {
13             [EnumMember]
14             CreateTime_Asc,
15             [EnumMember]
16             CreateTime_Desc,
17             [EnumMember]
18             Id_Asc,
19             [EnumMember]
20             Id_Desc,
21             [EnumMember]
22             Name_Asc,
23             [EnumMember]
24             Name_Desc,
25             [EnumMember]
26             SchoolId_Asc,
27             [EnumMember]
28             SchoolId_Desc,
29             [EnumMember]
30             Status_Asc,
31             [EnumMember]
32             Status_Desc,
33             [EnumMember]
34             UpdateTime_Asc,
35             [EnumMember]
36             UpdateTime_Desc,
37             [EnumMember]
38             UserId_Asc,
39             [EnumMember]
40             UserId_Desc,
41 
42         }
43 
44         [DataMember]
45         public OrderByType? OrderBy { get; set; }
46 
47         [DataMember]
48         public DateTime? CreateTime_Begin
49         { get; set; }
50 
51         [DataMember]
52         public DateTime? CreateTime_End
53         { get; set; }
54 
55         [DataMember]
56         public int? Id
57         { get; set; }
58 
59         [DataMember]
60         public List<int> Ids
61         { get; set; }
62 
63         [DataMember]
64         public string Name
65         { get; set; }
66 
67         [DataMember]
68         public int? SchoolId
69         { get; set; }
70 
71         [DataMember]
72         public int? Status
73         { get; set; }
74 
75         [DataMember]
76         public int? UserId
77         { get; set; }
78 
79         [DataMember]
80         public int PageIndex { get; set; }
81         [DataMember]
82         public int PageSize { get; set; }
83         [DataMember]
84         public int RecordCount { get; set; }
85         public People_Query_ConditionDto()
86         {
87             this.Ids = new List<int>();
88         }
89     }
90 }
View Code

1.4.3.3 生成的EF规约代码:

  1 public static ISpecification<People> People_Query(People_Query_Condition condition)
  2 {
  3          ISpecification<People> id_spec = null;
  4          if (!condition.Id.HasValue)
  5          {
  6              id_spec =  new DirectSpecification<People>(x=> true);
  7          }
  8          else{
  9          id_spec = new DirectSpecification<People>(x=>
 10              x.Id == condition.Id
 11          );
 12         }
 13 
 14          ISpecification<People> ids_spec = null;
 15          if (condition.Ids == null || condition.Ids.Count == 0)
 16          {
 17              ids_spec =  new DirectSpecification<People>(x=> true);
 18          }
 19          else{
 20         }
 21 
 22          ISpecification<People> name_spec = null;
 23          if (string.IsNullOrWhiteSpace(condition.Name))
 24          {
 25               name_spec =  new DirectSpecification<People>(x=> true);
 26          }
 27          else{
 28              name_spec = new DirectSpecification<People>(x=>
 29                   x.Name.Contains(condition.Name)
 30              );
 31         }
 32 
 33          ISpecification<People> schoolId_spec = null;
 34          if (!condition.SchoolId.HasValue)
 35          {
 36              schoolId_spec =  new DirectSpecification<People>(x=> true);
 37          }
 38          else{
 39          schoolId_spec = new DirectSpecification<People>(x=>
 40              x.SchoolId == condition.SchoolId
 41          );
 42         }
 43 
 44          ISpecification<People> status_spec = null;
 45          if (!condition.Status.HasValue)
 46          {
 47              status_spec =  new DirectSpecification<People>(x=> true);
 48          }
 49          else{
 50          status_spec = new DirectSpecification<People>(x=>
 51              x.Status == condition.Status
 52          );
 53         }
 54 
 55          ISpecification<People> userId_spec = null;
 56          if (!condition.UserId.HasValue)
 57          {
 58              userId_spec =  new DirectSpecification<People>(x=> true);
 59          }
 60          else{
 61          userId_spec = new DirectSpecification<People>(x=>
 62              x.UserId == condition.UserId
 63          );
 64         }
 65 
 66          ISpecification<People> createTime_Begin_spec = null;
 67          if (!condition.CreateTime_Begin.HasValue)
 68          {
 69              createTime_Begin_spec =  new DirectSpecification<People>(x=> true);
 70          }
 71          else{
 72          createTime_Begin_spec = new DirectSpecification<People>(x=>
 73              x.CreateTime >= condition.CreateTime_Begin
 74          );
 75         }
 76 
 77          ISpecification<People> createTime_End_spec = null;
 78          if (!condition.CreateTime_End.HasValue)
 79          {
 80              createTime_End_spec =  new DirectSpecification<People>(x=> true);
 81          }
 82          else{
 83          createTime_End_spec = new DirectSpecification<People>(x=>
 84              x.CreateTime <= condition.CreateTime_End
 85          );
 86         }
 87 
 88          var name_spec = new DirectSpecification<People>(x=>
 89              (x.Name??"") != ""
 90          );
 91 
 92          ISpecification<People> id_ids = new AndSpecification<People>(id_spec,ids_spec); 
 93          ISpecification<People> id_ids_name = new AndSpecification<People>(id_ids,name_spec); 
 94          ISpecification<People> id_ids_name_schoolId = new AndSpecification<People>(id_ids_name,schoolId_spec); 
 95          ISpecification<People> id_ids_name_schoolId_status = new AndSpecification<People>(id_ids_name_schoolId,status_spec); 
 96          ISpecification<People> id_ids_name_schoolId_status_userId = new AndSpecification<People>(id_ids_name_schoolId_status,userId_spec); 
 97          ISpecification<People> id_ids_name_schoolId_status_userId_createTime_Begin = new AndSpecification<People>(id_ids_name_schoolId_status_userId,createTime_Begin_spec); 
 98          ISpecification<People> id_ids_name_schoolId_status_userId_createTime_Begin_createTime_End = new AndSpecification<People>(id_ids_name_schoolId_status_userId_createTime_Begin,createTime_End_spec); 
 99          ISpecification<People> id_ids_name_schoolId_status_userId_createTime_Begin_createTime_End_name = new AndSpecification<People>(id_ids_name_schoolId_status_userId_createTime_Begin_createTime_End,name_spec); 
100          return id_ids_name_schoolId_status_userId_createTime_Begin_createTime_End_name;
101 }
View Code

1.4.3.4 生成的EF存取代码:

 1 public PageOfReturn<People> People_Query( People_Query_Condition condition )
 2 {
 3      var data = this.GetAll( PeopleSpecification.People_Query(condition ));
 4      if( condition.OrderBy.HasValue )
 5      {
 6          switch(condition.OrderBy)
 7          {
 8          case People_Query_Condition.OrderByType.CreateTime_Asc:
 9              data = data.OrderBy(x=>x.CreateTime);
10              break;
11          case People_Query_Condition.OrderByType.CreateTime_Desc:
12              data = data.OrderByDescending(x=>x.CreateTime);
13              break;
14          case People_Query_Condition.OrderByType.Id_Asc:
15              data = data.OrderBy(x=>x.Id);
16              break;
17          case People_Query_Condition.OrderByType.Id_Desc:
18              data = data.OrderByDescending(x=>x.Id);
19              break;
20          case People_Query_Condition.OrderByType.Name_Asc:
21              data = data.OrderBy(x=>x.Name);
22              break;
23          case People_Query_Condition.OrderByType.Name_Desc:
24              data = data.OrderByDescending(x=>x.Name);
25              break;
26          case People_Query_Condition.OrderByType.SchoolId_Asc:
27              data = data.OrderBy(x=>x.SchoolId);
28              break;
29          case People_Query_Condition.OrderByType.SchoolId_Desc:
30              data = data.OrderByDescending(x=>x.SchoolId);
31              break;
32          case People_Query_Condition.OrderByType.Status_Asc:
33              data = data.OrderBy(x=>x.Status);
34              break;
35          case People_Query_Condition.OrderByType.Status_Desc:
36              data = data.OrderByDescending(x=>x.Status);
37              break;
38          case People_Query_Condition.OrderByType.UpdateTime_Asc:
39              data = data.OrderBy(x=>x.UpdateTime);
40              break;
41          case People_Query_Condition.OrderByType.UpdateTime_Desc:
42              data = data.OrderByDescending(x=>x.UpdateTime);
43              break;
44          case People_Query_Condition.OrderByType.UserId_Asc:
45              data = data.OrderBy(x=>x.UserId);
46              break;
47          case People_Query_Condition.OrderByType.UserId_Desc:
48              data = data.OrderByDescending(x=>x.UserId);
49              break;
50          default:
51              break;
52          }
53      }
54      var result = new PageOfReturn<People>();
55      result.RecordCount = data.Count();
56      result.PageIndex = condition.PageIndex;
57      result.PageSize = condition.PageSize;
58      result.PageRecords = data.Skip(condition.PageSize * (condition.PageIndex - 1)).Take(condition.PageSize).ToList();
59      return result;
60 }
View Code

1.4.3.5 其他层如Service,Web层。基本上代码少量改动一下就可以实现一个列表页面。实例代码省略

1.4.4 多表查询

1.4.4.1 生成的查询条件类:

 1 using System;
 2 using System.Collections.Generic;
 3 
 4 namespace xxx
 5 {
 6     public class GetPeopleInfo_Condition
 7     {
 8         public string SchoolName
 9         { get; set; }
10 
11         public int? Status
12         { get; set; }
13 
14 
15         public GetPeopleInfo_Condition()
16         {
17         }
18     }
19 }
View Code

1.4.4.2 生成的查询条件DTO类:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Runtime.Serialization;
 4 
 5 namespace xxx
 6 {
 7     [DataContract]
 8     public class GetPeopleInfo_ConditionDto
 9     {
10         [DataMember]
11         public string SchoolName
12         { get; set; }
13 
14         [DataMember]
15         public int? Status
16         { get; set; }
17 
18         public GetPeopleInfo_ConditionDto()
19         {
20         }
21     }
22 }
View Code

1.4.4.3 生成的结果类:

 1 using System;
 2 using System.Linq;
 3 using System.Data;
 4 using System.Collections.Generic;
 5 
 6 namespace xxx
 7 {
 8     public class PeopleInfo
 9     {
10         public DateTime? CreateTime
11         { get; set; }
12 
13         public int Id
14         { get; set; }
15 
16         public string Name
17         { get; set; }
18 
19         public int? SchoolId
20         { get; set; }
21 
22         public int? Status
23         { get; set; }
24 
25         public DateTime? UpdateTime
26         { get; set; }
27 
28         public int? UserId
29         { get; set; }
30 
31         public string SchoolName//来自表 School
32         { get; set; }
33 
34         public string UserEmail //来自表 C_Users
35         { get; set; }
36 
37     }
38 }
View Code

1.4.4.4 生成的EF代码(多表关联不再需要规约):

 1 public List<PeopleInfo> GetPeopleInfo( GetPeopleInfo_Condition condition )
 2 {
 3      using (var unitOfWork = UnitOfWorkFactory.Create(DbOption.OA))
 4      {
 5      var p_q = ctx.Set<People>().AsQueryable();
 6      if(condition.Status != null )
 7      {
 8      p_q = p_q.Where(x=>x.Status == condition.Status);
 9      }
10 
11      var s_q = ctx.Set<School>().AsQueryable();
12      if(condition.SchoolName != null )
13      {
14      s_q = s_q.Where(x=>x.Name == condition.SchoolName);
15      }
16 
17      var u_q = ctx.Set<User>().AsQueryable();
18      var q = p_q;
19 
20      var q_1 =     q.GroupJoin(s_q,p=>p.SchoolId,s=>s.Id,
21              (p,s)=>new { p,s = s.DefaultIfEmpty() })
22              .SelectMany(item=>item.s.Select(s=> new {item.p,s}));
23 
24      var q_2 =     q_1.GroupJoin(u_q,p=>p.p.UserId,u=>u.UserId,
25              (p,u)=>new { p,u = u.DefaultIfEmpty() })
26              .SelectMany(item=>item.u.Select(u=> new {item.p.p,item.p.s,u}));
27 
28      var q_final = q_2.Where(x=>
29          true);
30 
31      var list = q_final.Select(x=>new PeopleInfo(){
32          SchoolId = x.p.SchoolId,
33          Name = x.p.Name,
34          CreateTime = x.p.CreateTime,
35          UpdateTime = x.p.UpdateTime,
36          Id = x.p.Id,
37          Status = x.p.Status,
38          UserId = x.p.UserId,
39          SchoolName = x.SchoolName,
40          UserEmail = x.UserEmail,
41      });
42      return list.ToList();
43      }
44 }
View Code

1.4.5 高级查询

1.4.5.1 分组查询

1.4.5.2 选项查询

1.4.5.2.1 {'op','all'} 一个字段产生多个查询条件

1.4.5.2.2 对条件查询进行条件:在某些参数非空下区域内参数才有效

写这么多,感觉需要控制篇幅,查询告一段落~

1.5 反向工程(持久阶段元数据更新设计阶段元数据)

使设计永不过期

  ----------->

1.6 生成数据词典

  ----------->

终于码完了。

2. 总结:

  生成器基本上涉及了数据系统资源管理的方方面面(数据操作,应用层,服务层,展现层),能节约大量的开发时间。使工程师更注重业务知识,

举例来说,用来这套开发工具后,我们团队加班变得非常少,项目进度和预期的基本吻合。拙笔仓促,如有笔误和不妥请谅解,希望听到大家的意见和建议,thanks。

 

 

posted @ 2014-12-04 10:29 adam# 阅读(...) 评论(...) 编辑 收藏