/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="PageSize">每页显示条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总页数</param>
/// <param name="serModel">搜索实体</param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.MsgLog> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serMsgLog serModel)
{
return(dal.GetList(PageSize, PageIndex, ref RecordCount, serModel));
}
/// <summary>
/// 获取发送列表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="serModel"></param>
/// <param name="i"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.MsgLog> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serMsgLog serModel)
{
IList <Eyousoft_yhq.Model.MsgLog> list = new List <Eyousoft_yhq.Model.MsgLog>();
string tableName = "tbl_MsgLog";
string fileds = " msgID,TelCode,MsgText,ReResult,Issuetime ";
string orderByString = " msgID desc";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.TelCode))
{
query.AppendFormat(" and TelCode = '{0}' ", serModel.TelCode);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.MsgLog model = new Eyousoft_yhq.Model.MsgLog();
model.msgid = dr.GetInt32(dr.GetOrdinal("msgID"));
model.TelCode = dr.IsDBNull(dr.GetOrdinal("TelCode")) ? "" : dr.GetString(dr.GetOrdinal("TelCode"));
model.MsgText = dr.IsDBNull(dr.GetOrdinal("MsgText")) ? "" : dr.GetString(dr.GetOrdinal("MsgText"));
model.ReResult = dr.IsDBNull(dr.GetOrdinal("ReResult")) ? "" : dr.GetString(dr.GetOrdinal("ReResult"));
model.Issuetime = dr.GetDateTime(dr.GetOrdinal("ProductID"));
list.Add(model);
}
}
return(list);
}