/
NormalLisReport.cs
170 lines (152 loc) · 4.51 KB
/
NormalLisReport.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
using System;
using System.Collections.Generic;
using System.Data;
namespace RuRo.BLL
{
/// <summary>
/// NormalLisReport
/// </summary>
public partial class NormalLisReport
{
private readonly RuRo.DAL.NormalLisReport dal = new RuRo.DAL.NormalLisReport();
public NormalLisReport()
{ }
#region BasicMethod
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return dal.GetMaxId();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Id)
{
return dal.Exists(Id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.NormalLisReport model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(RuRo.Model.NormalLisReport model)
{
return dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int Id)
{
return dal.Delete(Id);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool DeleteList(string Idlist)
{
return dal.DeleteList(Idlist);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RuRo.Model.NormalLisReport GetModel(int Id)
{
return dal.GetModel(Id);
}
/// <summary>
/// 得到一个对象实体,从缓存中
/// </summary>
public RuRo.Model.NormalLisReport GetModelByCache(int Id)
{
string CacheKey = "NormalLisReportModel-" + Id;
object objModel = RuRo.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(Id);
if (objModel != null)
{
int ModelCache = RuRo.Common.ConfigHelper.GetConfigInt("ModelCache");
RuRo.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch { }
}
return (RuRo.Model.NormalLisReport)objModel;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
return dal.GetList(Top, strWhere, filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<RuRo.Model.NormalLisReport> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<RuRo.Model.NormalLisReport> DataTableToList(DataTable dt)
{
List<RuRo.Model.NormalLisReport> modelList = new List<RuRo.Model.NormalLisReport>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
RuRo.Model.NormalLisReport model;
for (int n = 0; n < rowsCount; n++)
{
model = dal.DataRowToModel(dt.Rows[n]);
if (model != null)
{
modelList.Add(model);
}
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public int GetRecordCount(string strWhere)
{
return dal.GetRecordCount(strWhere);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
return dal.GetListByPage(strWhere, orderby, startIndex, endIndex);
}
#endregion BasicMethod
}
}