/// <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); }