public IList <ConsumerModel> GetPageList(DbConn conn, string name, int pageIndex, int pageSize, ref int count)
{
int tempCount = 0;
IList <ConsumerModel> list = new List <ConsumerModel>();
ConsumerModel cm = new ConsumerModel();
var result = SqlHelper.Visit((ps) =>
{
StringBuilder where = new StringBuilder(" WHERE 1=1 ");
if (!string.IsNullOrEmpty(name))
{
where.AppendFormat(" AND clientname LIKE '%{0}%'", name);
}
string sql = "SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) AS rownum,* FROM tb_consumer WITH(NOLOCK)";
string countSql = "SELECT COUNT(1) FROM tb_consumer WITH(NOLOCK) " + where.ToString();
object obj = conn.ExecuteScalar(countSql, null);
if (obj != DBNull.Value && obj != null)
{
tempCount = LibConvert.ObjToInt(obj);
}
string sqlPage = string.Concat("SELECT * FROM (", sql.ToString(), where.ToString(), ") A WHERE rownum BETWEEN ", ((pageIndex - 1) * pageSize + 1), " AND ", pageSize * pageIndex);
DataTable dt = conn.SqlToDataTable(sqlPage, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ConsumerModel model = cm.CreateModel(dr);
IList <tb_consumer_partition_model> consumerList = partitionDal.GetPartitionByConsumerId(conn, model.consumerclientid);
if (consumerList != null && consumerList.Count > 0)
{
IList <ConsumerPartition> partitionList = new List <ConsumerPartition>();
foreach (var item in consumerList)
{
ConsumerPartition m = new ConsumerPartition();
m.PartitionId = item.partitionid;
PartitionIDInfo partitionInfo = PartitionRuleHelper.GetPartitionIDInfo(item.partitionid);
string node = string.Empty;
if (partitionInfo.DataNodePartition < 10)
{
node = "0" + partitionInfo.DataNodePartition.Tostring();
}
else
{
node = partitionInfo.DataNodePartition.Tostring();
}
using (DbConn nodeConn = DbConfig.CreateConn(DataConfig.DataNodeParConn(node)))
{
nodeConn.Open();
tb_partition_model partitionModel = new tb_partition_dal().Get(conn, item.partitionid);
if (partitionModel != null)
{
m.IsOnline = partitionModel.isused;
}
string table = msgDal.GetMaxMqTable(nodeConn, node);
m.Msg = msgDal.GetMsgCount(nodeConn, table, 0);
m.NonMsg = msgDal.GetMsgCount(nodeConn, table, 1);
partitionList.Add(m);
}
}
model.PartitionList = partitionList;
}
list.Add(model);
}
}
return(list);
});
count = tempCount;
return(result);
}
