/
NormalLisItems.cs
163 lines (145 loc) · 4.41 KB
/
NormalLisItems.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
using System;
using System.Collections.Generic;
using System.Data;
namespace RuRo.BLL
{
/// <summary>
/// NormalLisItems
/// </summary>
public partial class NormalLisItems
{
private readonly RuRo.DAL.NormalLisItems dal = new RuRo.DAL.NormalLisItems();
public NormalLisItems()
{ }
#region BasicMethod
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RuRo.Model.NormalLisItems model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(RuRo.Model.NormalLisItems 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.NormalLisItems GetModel(int Id)
{
return dal.GetModel(Id);
}
/// <summary>
/// 得到一个对象实体,从缓存中
/// </summary>
public RuRo.Model.NormalLisItems GetModelByCache(int Id)
{
string CacheKey = "NormalLisItemsModel-" + 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.NormalLisItems)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.NormalLisItems> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<RuRo.Model.NormalLisItems> DataTableToList(DataTable dt)
{
List<RuRo.Model.NormalLisItems> modelList = new List<RuRo.Model.NormalLisItems>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
RuRo.Model.NormalLisItems 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);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
}
}