Lucas.Orm框架应用举例

1. public static void Insert()
2.         {
3.             //声明一个实体类，并赋值，自动增长列不需要赋值
4.             Model.UserInfo userinfo = new Lucas.Orm.Test.Model.UserInfo();
5.             userinfo.Username =  DateTime.Now.ToString(); ;
6.             userinfo.Password = "passwod";
7.             userinfo.CreateDate = DateTime.Today;
10.             try
11.             {
12.                 bool flag = Persist.Insert(userinfo);
13.                 if (flag)
14.                 {
15.                     //userid为自动增长列 ，返回自动增长列
16.                     Console.WriteLine("UserId={0}", userinfo.UserId);
17.                 }
18.             }
19.             catch (Exception ex)
20.             {
21.                 Console.WriteLine(ex.Message);
22.             }
23.             Console.Read();
24.         }
25.         /// <summary>
26.         /// 修改记录
27.         /// </summary>
28.         public static void Update()
29.         {
31.             Model.UserInfo userinfo = new Lucas.Orm.Test.Model.UserInfo();
32.             userinfo.UserId = 4;
33.             userinfo.Username = "lucas";
34.             userinfo.Password = "123456";
35.             userinfo.CreateDate = DateTime.Today;
36.             try
37.             {
38.                 bool flag = Persist.Update(userinfo);
39.                 Console.Write(flag);
40.             }
41.             catch (Exception ex)
42.             {
43.                 Console.WriteLine(ex.Message);
44.             }
45.             Console.Read();
46.         }
47.         /// <summary>
48.         /// 删除记录
49.         /// </summary>
50.         public static void Delete()
51.         {
52.             Model.UserInfo userinfo = new Lucas.Orm.Test.Model.UserInfo();
53.             userinfo.UserId = 4;
54.             try
55.             {
56.                 bool flag = Persist.Delete(userinfo);
57.                 Console.Write(flag);
58.             }
59.             catch (Exception ex)
60.             {
61.                 Console.WriteLine(ex.Message);
62.             }
63.             Console.Read();
64.         }
65.         public static void Delete1()
66.         {
67.             KeyValueCollection primarykeys = new KeyValueCollection();
68.             primarykeys.Add("userid", 3);
69.             if (Persist.Delete<Model.UserInfo>(primarykeys))
70.             {
71.                 Console.WriteLine("删除成功！");
72.             }
73.             else
74.             {
75.                 Console.WriteLine("删除失败！");
76.             }
78.         }
79.         /// <summary>
80.         /// 获取实体
81.         /// </summary>
82.         public static void Get()
83.         {
84.             KeyValueCollection primarykeys = new KeyValueCollection();
85.             primarykeys.Add("userid", 3);
86.             List<Model.UserInfo> list = Persist.Get<Model.UserInfo>(primarykeys);
87.             Console.WriteLine("userid:{0}", list[0].UserId);
88.             Console.WriteLine("username:{0}", list[0].Username);
89.             Console.WriteLine("password:{0}", list[0].Password);
90.             Console.WriteLine("createdate:{0}", list[0].CreateDate);
91.             Console.Read();
92.         }
93.         /// <summary>
94.         /// 自定义条件查询
95.         /// </summary>
96.         public static void Get1()
97.         {
98.             string where = "userid in (5,6)";
99.             List<Model.UserInfo> list = Persist.Get<Model.UserInfo>(where);
100.             foreach (Model.UserInfo userInfo in list)
101.             {
102.                 Console.WriteLine("userid:{0}", userInfo.UserId);
103.                 Console.WriteLine("username:{0}", userInfo.Username);
104.                 Console.WriteLine("password:{0}", userInfo.Password);
105.                 Console.WriteLine("createdate:{0}", userInfo.CreateDate);
106.                 Console.WriteLine("-----------------------");
107.             }
108.             Console.Read();
109.         }
110.         /// <summary>
111.         /// 分页查询
112.         /// </summary>
113.         public static void Get2()
114.         {
115.             int pageSize = 15;
116.             int pageNo = 1;
117.             List<Model.UserInfo> list = Persist.Get<Model.UserInfo>(pageSize, pageNo);
118.             foreach (Model.UserInfo userInfo in list)
119.             {
120.                 Console.WriteLine("userid:{0}", userInfo.UserId);
121.                 Console.WriteLine("username:{0}", userInfo.Username);
122.                 Console.WriteLine("password:{0}", userInfo.Password);
123.                 Console.WriteLine("createdate:{0}", userInfo.CreateDate);
124.                 Console.WriteLine("-----------------------");
125.             }
126.             Console.Read();
128.         }
129.         /// <summary>
130.         /// 带条件的分页查询
131.         /// </summary>
132.         public static void Get3()
133.         {
134.             string where = "username like '%lu%'";
135.             int pageSize = 15;
136.             int pageNo = 1;
137.             List<Model.UserInfo> list = Persist.Get<Model.UserInfo>(where, pageSize, pageNo);
138.             foreach (Model.UserInfo userInfo in list)
139.             {
140.                 Console.WriteLine("userid:{0}", userInfo.UserId);
141.                 Console.WriteLine("username:{0}", userInfo.Username);
142.                 Console.WriteLine("password:{0}", userInfo.Password);
143.                 Console.WriteLine("createdate:{0}", userInfo.CreateDate);
144.                 Console.WriteLine("-----------------------");
145.             }
146.             Console.Read();
147.         }
148.         /// <summary>
149.         /// 查询统计
150.         /// </summary>
151.         public static void Count()
152.         {
153.             int count = Persist.Count<Model.UserInfo>();
154.             Console.Write("UserInfo表中共有{0}条记录", count);
155.             Console.Read();
156.         }