用C#实现对MSSqlServer数据库的增删改查---Server层(WaterLevelRecordServer.cs、DeviceRecordServer.cs)...-优快云博客

抛开现实的残酷与无奈，对技术孜孜不倦的追求，从专注到执着，从疯狂到忘我，始终坚信代码可以改变世界，更能改变自己的人生。

WaterLevelRecordServer.cs

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using SMOS.DAL.Device;
 6 using SMOS.Model.Device;
 7 
 8 namespace SMOS.Server.Impl.Device
 9 {
10     public class WaterLevelRecordServer:DeviceRecordServer
11     {
12         private WaterLevelRecordDao WaterLevelRecordDao = new WaterLevelRecordDao();
13         /// <summary>
14         /// 获取水位计最后一条记录
15         /// </summary>
16         /// <param name="deviceID">设备ID</param>
17         /// <returns>水位计记录信息</returns>
18         public override object GetLastRecordInfo(int deviceID)
19         {
20             return WaterLevelRecordDao.GetLastWaterLevelRecordInfo(deviceID);           
21         }
22         /// <summary>
23         /// 获取水位计记录信息列表
24         /// </summary>
25         /// <param name="deviceID">设备ID</param>
26         /// <returns>水位计记录信息</returns>
27         public override IList<object> GetRecordInfos(int deviceID)
28         {
29             return WaterLevelRecordDao.GetWaterLevelRecordInfos(deviceID).ToList<object>();
30         }
31         /// <summary>
32         /// 获取水位计时间段内记录信息列表
33         /// </summary>
34         /// <param name="deviceID">设备ID</param>
35         /// <param name="startTime">开始时间</param>
36         /// <param name="endTime">截止时间</param>
37         /// <returns>水位计记录信息</returns>
38         public override IList<object> GetRecordInfos(int deviceID, DateTime startTime, DateTime endTime)
39         {
40             return WaterLevelRecordDao.GetWaterLevelRecordInfos(deviceID, startTime, endTime).ToList<Object>();
41         }
42         /// <summary>
43         /// 添加水位计记录信息
44         /// </summary>
45         /// <param name="recordInfo">记录信息</param>
46         /// <returns>操作记录</returns>
47         public override int AddRecordInfo(object recordInfo)
48         {
49             return WaterLevelRecordDao.AddWaterLevelRecordInfo(recordInfo as WaterLevelRecordInfo);
50         }
51         /// <summary>
52         /// 更新水位计记录信息
53         /// </summary>
54         /// <param name="recordInfo">记录信息</param>
55         /// <returns>操作记录</returns>
56         public override int ModifyRecordInfo(object recordInfo)
57         {
58             return WaterLevelRecordDao.ModifyWaterLevelRecordInfo(recordInfo as WaterLevelRecordInfo);
59         }
60         /// <summary>
61         /// 删除水位计记录信息
62         /// </summary>
63         /// <param name="recordInfo">记录信息</param>
64         /// <returns>操作记录</returns>
65         public override int DelRecordInfo(object recordInfo)
66         {
67             return WaterLevelRecordDao.DelWaterLevelRecordInfo(recordInfo as WaterLevelRecordInfo);
68         }
69 
70     }
71 }

DeviceRecordServer.cs

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using SMOS.IServer.Device;
 6 
 7 namespace SMOS.Server.Impl.Device
 8 {
 9     public abstract class DeviceRecordServer : IDeviceRecordServer
10     {
11         public abstract object GetLastRecordInfo(int deviceID);
12         public abstract IList<object> GetRecordInfos(int deviceID);
13         public abstract IList<object> GetRecordInfos(int deviceID, DateTime startTime, DateTime endTime);
14         public abstract int AddRecordInfo(object recordInfo);
15         public abstract int ModifyRecordInfo(object recordInfo);
16         public abstract int DelRecordInfo(object recordInfo);
17     }
18 }