/// <summary>
/// 查询酒店常旅客，得到常旅客列表
/// </summary>
/// <param name="CompanyId">公司ID</param>
/// <param name="VisitorName">常旅客姓名</param>
/// <param name="VisitorType">常旅客类型</param>
/// <param name="PageSize">每页显示的记录</param>
/// <param name="PageIndex">页码</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> GetHotelVistorList(string CompanyId, string VisitorName, EyouSoft.Model.TicketStructure.TicketVistorType?VisitorType, int PageSize, int PageIndex, ref int RecordCount)
{
var searchInfo = new EyouSoft.Model.TicketStructure.MVisitorSearchInfo()
{
Type = EyouSoft.Model.TicketStructure.TicketDataType.酒店常旅客,
VType = VisitorType,
Name = VisitorName
};
return(_GetVisitors(PageSize, PageIndex, ref RecordCount, CompanyId, true, searchInfo));
}
/// <summary>
/// 酒店-匹配常旅客姓名，根据姓名模糊查询常旅客集合
/// </summary>
/// <param name="VistorName">常旅客姓名</param>
/// <param name="CompanyId">公司ID</param>
/// <returns></returns>
public IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> GetHotelListByName(string VistorName, string CompanyId)
{
var searchInfo = new EyouSoft.Model.TicketStructure.MVisitorSearchInfo()
{
Type = EyouSoft.Model.TicketStructure.TicketDataType.酒店常旅客,
Name = VistorName
};
int recordCount = 0;
return(_GetVisitors(0, 0, ref recordCount, CompanyId, false, searchInfo));
}
/// <summary>
/// 获取常旅客信息集合
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="isPaging">是否分页</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
private IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> _GetVisitors(int pageSize, int pageIndex, ref int recordCount, string companyId, bool isPaging, EyouSoft.Model.TicketStructure.MVisitorSearchInfo searchInfo)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
return(idal.GetVisitors(pageSize, pageIndex, ref recordCount, companyId, isPaging, searchInfo));
}
/// <summary>
/// 获取常旅客信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> GetVisitors(string companyId, EyouSoft.Model.TicketStructure.MVisitorSearchInfo searchInfo)
{
int recordCount = 0;
return(_GetVisitors(0, 0, ref recordCount, companyId, false, searchInfo));
}
/// <summary>
/// 获取常旅客信息集合
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> GetVisitors(int pageSize, int pageIndex, ref int recordCount, string companyId, EyouSoft.Model.TicketStructure.MVisitorSearchInfo searchInfo)
{
return(_GetVisitors(pageSize, pageIndex, ref recordCount, companyId, true, searchInfo));
}
/// <summary>
/// 获取常旅客信息集合
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="isPaging">是否分页</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> GetVisitors(int pageSize, int pageIndex, ref int recordCount, string companyId, bool isPaging, EyouSoft.Model.TicketStructure.MVisitorSearchInfo searchInfo)
{
IList <EyouSoft.Model.TicketStructure.TicketVistorInfo> items = new List <EyouSoft.Model.TicketStructure.TicketVistorInfo>();
string tableName = "tbl_TicketVistorInfo";
string fileds = "*";
string orderby = " IssueTime ASC";
StringBuilder query = new StringBuilder();
#region 拼接查询
query.AppendFormat(" CompanyId='{0}' ", companyId);
if (searchInfo != null)
{
if (searchInfo.Type.HasValue)
{
query.AppendFormat(" AND [DataType]='{0}' ", (int)searchInfo.Type.Value);
}
if (!string.IsNullOrEmpty(searchInfo.Name))
{
if (IsLetter(searchInfo.Name))
{
query.AppendFormat(" AND EnglishName LIKE '%{0}%' ", searchInfo.Name);
}
else
{
query.AppendFormat(" AND ChinaName LIKE '%{0}%' ", searchInfo.Name);
}
}
if (searchInfo.VType.HasValue)
{
query.AppendFormat(" AND VistorType='{0}' ", (int)searchInfo.VType);
}
if (!string.IsNullOrEmpty(searchInfo.KeyWord))
{
query.AppendFormat(
" AND isnull(ChinaName,'') + isnull(EnglishName,'') + isnull(Mobile,'') like '%{0}%' ",
searchInfo.KeyWord);
}
}
#endregion
using (IDataReader dr = isPaging ? DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, "ID", fileds, query.ToString(), orderby)
: DbHelper.ExecuteReader(_db, tableName, fileds, query.ToString(), orderby))
{
while (dr.Read())
{
var item = new EyouSoft.Model.TicketStructure.TicketVistorInfo();
InputModelValue(item, dr);
items.Add(item);
}
}
return(items);
}
