public List <ObModelInfo> GetList(ObModelQuery query, out ListAttrInfo listAttr, out string msg)
{
List <ObModelInfo> list = null;
try
{
if (!query.CheckPagingAttrs(MIN_PAGESIZE, MAX_PAGESIZE, out msg))
{
listAttr = null;
return(null);
}
ObModelDA da = new ObModelDA();
list = da.SelectList(query, out listAttr);
if (list == null)
{
msg = "获取" + ENTITY_STR + "列表为空";
listAttr = null;
return(null);
}
}
catch (Exception ex)
{
msg = "获取" + ENTITY_STR + "列表异常";
Logger.Error(ex, msg);
listAttr = null;
return(null);
}
return(list);
}
public void List(ActionRequest req, ActionResponse res)
{
string msg = "";
ListAttrInfo la;
try
{
if (!Session.IsAdmin) //权限判断，是管理员
{
res.Error(VERIFY_ERROR);
return;
}
ObModelQuery qry = req.GetModelByNameOrFirst <ObModelQuery>(QUERY);
List <ObModelInfo> list = GetList(qry, out la, out msg);
if (list == null)
{
res.Error(msg);
return;
}
ActionResult ar = res.AddResult(ENTITY_RES, ENTITY_FIELDS);
ar.AddModels <ObModelInfo>(list);
ActionResult arAttr = res.AddResult(LISTATTR, LISTATTR_FIELDS);
arAttr.AddModel(la);
//获取关联结果集
if (qry.GetRelation.IsTrue())
{
ActionResult arRe = res.AddResult(RELATION_RES, RELATION_FIELDS);
if (list.Count > 0)
{
//获取ObModel的obId串
List <long> obIds = new List <long>();
for (int i = 0, j = list.Count; i < j; i++)
{
obIds.Add(list[i].ObId.Value);
}
//调用ObRelation实体对应的BL类中的获取列表方法
// ObRelationInfo 中属性 ObId 对应 ObModelInfo 的 ObId
// RelationQuery 中属性 ObIds 对应 ObModelInfo 的 ObId （多个）
/*
* RelationBL rbl = new RelationBL();
* RelationQuery rqry = new RelationQuery();
* ListAttrInfo rla = new ListAttrInfo();
* rqry.PageNo = 1;
* rqry.PageSize = list.Count; //
* rqry.ObIds.Set(obIds);
* List<ObRelationInfo> rList = rbl.GetList(rqry, out rla, out msg);
* arRe.AddModels<ObRelationInfo>(rList);
*/
}
else
{
arRe.AddModels <ObRelationInfo>(new List <ObRelationInfo>());
}
}
}
catch (Exception ex)
{
msg = "ys.obModel.list 接口调用异常";
Logger.Error(ex, msg);
res.Error(msg);
}
}
internal List <ObModelInfo> SelectList(ObModelQuery query, out ListAttrInfo listAttr)
{
//初始化
ObModelInfo om = new ObModelInfo();
IDbHandler dbh = om.CreateHandler(); //创建数据库操作句柄接口
dbh.SetFields(om.Fields); //设置返回的实体字段
//[BEGIN]::组装Where条件语句
//组装日期时间条件
string startTime; //开始时间
string endTime; //结束时间
string dtFormat = "yyyy-MM-dd HH:mm:ss";
if (!query.StartTime.IsNull && (!query.StartTime.IsMinValue))
{
startTime = query.StartTime.Value.ToString(dtFormat);
dbh.Where(om.ObCreated.Compare(">=", startTime));
}
if (!query.EndTime.IsNull && (!query.EndTime.IsMinValue))
{
endTime = query.EndTime.Value.ToString(dtFormat);
dbh.Where(om.ObCreated.Compare("<=", endTime));
}
//组装记录ID串条件
if (!query.Ids.IsNull && query.Ids.Count > 0)
{
dbh.Where(om.ObId.In(query.Ids.Value));
}
//组装关键字条件
if (!query.Keyword.IsNullOrWhiteSpace)
{
dbh.Where(om.ObName.Like(query.Keyword.Value));
}
//组装复合条件（如果需要）
/*
* if (!query.Keyword.IsNullOrWhiteSpace)
* {
* string keyword = query.Keyword.Value;
* CompoundCondition ccd = new CompoundCondition(); //复合条件类
* ccd.And(om.ObName.Like(keyword))
* .Or(om.ObDescri.Like(keyword));
* dbh.Where(ccd);
* }
*/
//
if (!query.Level.IsNull)
{
dbh.Where(om.ObLevel.Equals(query.Level));
}
//组装记录状态条件
if (!query.Enabled.IsNull)
{
dbh.Where(om.ObEnabled.Equals(query.Enabled.Value));
}
//组装JOIN条件
if (!query.GetRelation.IsTrue())
{
ObRelationInfo ori = new ObRelationInfo();
dbh.SetFields(ori.Fields); //设置返回的关联实体字段
dbh.Join(ori).On(om.ObId.Equals(ori.ObId)); //关联条件
}
//组装排序条件（放在Where子句最后，分页时，必须有OrderBy）
if (!query.OrderBy.IsNull && query.OrderBy.Count > 0)
{
OrderInfo[] oiArray = query.OrderBy.GetArray();
//拼装的order by条件，case条件字段值需要和ObModelQuery查询实体的OrderByFields属性一致
foreach (OrderInfo oi in oiArray)
{
switch (oi.FieldAlias)
{
case "obLevel":
dbh.OrderBy(om.ObLevel, oi.OrderType);
break;
case "obName":
dbh.OrderBy(om.ObName, oi.OrderType);
break;
case "obEnabled":
dbh.OrderBy(om.ObEnabled, oi.OrderType);
break;
case "obMoney":
dbh.OrderBy(om.ObMoney, oi.OrderType);
break;
case "obScore":
dbh.OrderBy(om.ObScore, oi.OrderType);
break;
case "obCreated":
dbh.OrderBy(om.ObCreated, oi.OrderType);
break;
case "obId":
default:
dbh.OrderBy(om.ObId, oi.OrderType);
break;
}
}
}
else
{
//默认排序条件
dbh.OrderBy(om.ObId, OrderType.DESC);
}
//[END]::组装Where条件语句
List <ObModelInfo> list = new List <ObModelInfo>();
DataReader dr = dbh.Select(query, out listAttr);
//获取结果集方法一（自动关闭读取器）
list = dr.ReadList <ObModelInfo>();
//获取结果集方法二（手动关闭读取器，更灵活）
while (dr.Read())
{
ObModelInfo ei = new ObModelInfo();
dr.ReadTo(ei);
list.Add(ei);
}
dr.Close();
return(list);
}