/// <summary>
/// 查询获取单项业务的列表
/// </summary>
/// <param name="search">查询的实体类</param>
/// <param name="pagesize">每页显示的条数</param>
/// <param name="pageindex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public IList <MSingleService> GetSingleServiceList(MSeachSingleService search,
int pagesize,
int pageindex,
ref int recordCount)
{
//权限控制
bool _isOnlySelf;
if (search == null || string.IsNullOrEmpty(search.CompanyId))
{
throw new System.Exception("bll error:查询实体为null或string.IsNullOrEmpty(查询实体.CompanyId)==true。");
}
int[] deptIds = this.GetDataPrivs(EyouSoft.Model.EnumType.PrivsStructure.Menu2.单项业务_单项业务, out _isOnlySelf);
return(dal.GetSingleServiceList(search, pagesize, pageindex, ref recordCount, this.LoginUserId, deptIds, _isOnlySelf));
}
/// <summary>
/// 查询获取单项业务的列表
/// </summary>
/// <param name="search">查询的实体类</param>
/// <param name="pagesize">每页显示的条数</param>
/// <param name="pageindex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="loginId">当前登录人编号</param>
/// <param name="deptIds">部门编号</param>
/// <param name="isOnlySeft">是否查看全部</param>
/// <returns></returns>
public IList <MSingleService> GetSingleServiceList(MSeachSingleService search, int pagesize, int pageindex, ref int recordCount, string loginId, int[] deptIds, bool isOnlySeft)
{
IList <EyouSoft.Model.TourStructure.MSingleService> list = null;
string fields = "TourId,TourStatus,OperatorId,OrderId,OrderCode,CompanyId,BuyCompanyName,SellerName,DeptId,ContactName,ContactTel,Adults,Operator,IssueTime,PlanProject,TourPlaner,TourType,IsDelete,LDate,CancelReson,HeTongId,HeTongCode";
StringBuilder query = new StringBuilder();
//TourType=6（单项业务）
query.AppendFormat("TourType='{0}' and IsDelete='{1}' ", (int)TourType.单项服务, 0);
//团队状态搜索条件未添加
query.AppendFormat(" AND TourStatus IN(0,3,9,10,11,12) ");
if (!string.IsNullOrEmpty(search.CompanyId))
{
query.AppendFormat(" and CompanyId='{0}' ", search.CompanyId);
}
if (!string.IsNullOrEmpty(search.OrderCode))
{
query.AppendFormat(" and OrderCode like '%{0}%' ", search.OrderCode);
}
if (search.BeginLDate.HasValue)
{
query.AppendFormat(" and IssueTime>'{0}' ", search.BeginLDate.Value.AddDays(-1));
}
if (search.EndLDate.HasValue)
{
query.AppendFormat(" and IssueTime<'{0}' ", search.EndLDate.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(search.BuyCompanyName))
{
query.AppendFormat(" and BuyCompanyName like '%{0}%' ", search.BuyCompanyName);
}
if (!string.IsNullOrEmpty(search.BuyCompanyId))
{
query.AppendFormat(" and BuyCompanyId='{0}' ", search.BuyCompanyId);
}
if (!string.IsNullOrEmpty(search.Operator))
{
query.AppendFormat(" and Operator='{0}' ", search.Operator);
}
if (!string.IsNullOrEmpty(search.OperatorId))
{
query.AppendFormat(" and OperatorId='{0}' ", search.OperatorId);
}
if (search.TourStatus.HasValue)
{
query.AppendFormat(" and TourStatus='{0}' ", (int)search.TourStatus.Value);
}
if (isOnlySeft)
{
query.AppendFormat(" and SellerId='{0}' ", loginId);
}
else
{
if (deptIds != null)
{
query.AppendFormat(" and DeptId in ({0})", GetIdsByArr(deptIds));
}
}
if (search.SWeiTuoRiQi.HasValue)
{
query.AppendFormat(" and LDate>'{0}' ", search.SWeiTuoRiQi.Value.AddDays(-1));
}
if (search.EWeiTuoRiQi.HasValue)
{
query.AppendFormat(" and LDate<'{0}' ", search.EWeiTuoRiQi.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(search.XiaoShouYuanId))
{
query.AppendFormat(" and SellerId='{0}' ", search.XiaoShouYuanId);
}
else if (!string.IsNullOrEmpty(search.XiaoShouYuanName))
{
query.AppendFormat(" and SellerName LIKE '%{0}%' ", search.XiaoShouYuanName);
}
if (!string.IsNullOrEmpty(search.JiDiaoYuanId))
{
query.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_TourPlaner AS A WHERE A.TourId=view_SingleService.TourId AND A.PlanerId='{0}') ", search.JiDiaoYuanId);
}
else if (!string.IsNullOrEmpty(search.JiDiaoYunaName))
{
query.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_TourPlaner AS A WHERE A.TourId=view_SingleService.TourId AND A.Planer LIKE '%{0}%') ", search.JiDiaoYunaName);
}
using (IDataReader dr = DbHelper.ExecuteReader(_db
, pagesize
, pageindex
, ref recordCount
, "view_SingleService"
, "TourId"
, fields.ToString()
, query.ToString()
, "IssueTime desc"))
{
if (dr != null)
{
list = new List <MSingleService>();
while (dr.Read())
{
MSingleService service = new MSingleService();
service.TourId = dr.GetString(dr.GetOrdinal("TourId"));
service.TourStatus = (TourStatus)dr.GetByte(dr.GetOrdinal("TourStatus"));
service.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
service.OrderId = dr.GetString(dr.GetOrdinal("OrderId"));
service.OrderCode = !dr.IsDBNull(dr.GetOrdinal("OrderCode")) ? dr.GetString(dr.GetOrdinal("OrderCode")) : string.Empty;
service.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
service.BuyCompanyName = dr.IsDBNull(dr.GetOrdinal("BuyCompanyName")) == false ? dr["BuyCompanyName"].ToString() : string.Empty;
service.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) == false ? dr["ContactName"].ToString() : string.Empty;
service.ContactTel = dr.IsDBNull(dr.GetOrdinal("ContactTel")) == false ? dr["ContactTel"].ToString() : string.Empty;
service.Adults = dr.GetInt32(dr.GetOrdinal("Adults"));
service.Operator = dr.IsDBNull(dr.GetOrdinal("Operator")) == false ? dr["Operator"].ToString() : string.Empty;
service.SellerName = !dr.IsDBNull(dr.GetOrdinal("SellerName")) ? dr.GetString(dr.GetOrdinal("SellerName")) : string.Empty;
//计调项
string plan = dr.IsDBNull(dr.GetOrdinal("PlanProject")) == false?dr.GetString(dr.GetOrdinal("PlanProject")) : string.Empty;
if (!string.IsNullOrEmpty(plan))
{
service.PlanProjectType = GetPlanProjectByXML(plan);
}
string planers = dr.IsDBNull(dr.GetOrdinal("TourPlaner")) == false?dr.GetString(dr.GetOrdinal("TourPlaner")) : string.Empty;
//计调员
if (!string.IsNullOrEmpty(planers))
{
service.Planers = GetPlanerByXML(planers);
}
service.WeiTuoRiQi = dr.GetDateTime(dr.GetOrdinal("LDate"));
service.QuXiaoYuanYin = dr["CancelReson"].ToString();
service.HeTongId = dr["HeTongId"].ToString();
service.HeTongCode = dr["HeTongCode"].ToString();
list.Add(service);
}
}
}
return(list);
}
