/// <summary>
/// 获取模板信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="type">模板类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.MNotepadServiceInfo> GetNotepads(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CompanyStructure.NotepadServiceType?type, EyouSoft.Model.CompanyStructure.MNotepadServiceSearchInfo searchInfo)
{
if (companyId < 1)
{
return(null);
}
return(dal.GetNotepads(companyId, pageSize, pageIndex, ref recordCount, type, searchInfo));
}
/// <summary>
/// 获取模板信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="type">模板类型</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.MNotepadServiceInfo> GetNotepads(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.EnumType.CompanyStructure.NotepadServiceType?type, EyouSoft.Model.CompanyStructure.MNotepadServiceSearchInfo searchInfo)
{
IList <EyouSoft.Model.CompanyStructure.MNotepadServiceInfo> items = new List <EyouSoft.Model.CompanyStructure.MNotepadServiceInfo>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_NotepadService";
string primaryKey = "Id";
string orderByString = "Id DESC";
string fields = "*";
#region 拼接查询条件
cmdQuery.AppendFormat(" CompanyId={0} ", companyId);
if (type.HasValue)
{
cmdQuery.AppendFormat(" AND Type={0} ", (byte)type.Value);
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
items.Add(new EyouSoft.Model.CompanyStructure.MNotepadServiceInfo()
{
CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
CreateTime = rdr.GetDateTime(rdr.GetOrdinal("CreateTime")),
Id = rdr.GetInt32(rdr.GetOrdinal("Id")),
OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
Text = rdr["Text"].ToString(),
Type = (EyouSoft.Model.EnumType.CompanyStructure.NotepadServiceType)rdr.GetByte(rdr.GetOrdinal("Type"))
});
}
}
return(items);
}
