/// <summary> /// 获取医生列表 /// </summary> /// <param name="context"></param> /// <returns></returns> private string GetDoctorList(HttpContext context) { string categoryId = context.Request["categoryId"]; string currCategoryid = context.Request["currcategoryid"]; string tags = context.Request["tags"]; List <WXMallProductInfo> productList = new List <WXMallProductInfo>(); if (!string.IsNullOrEmpty(categoryId)) { string categoryIds = bllMall.GetCateAndChildIds(Convert.ToInt32(categoryId)); currCategoryid = bllMall.GetCateAndChildIds(Convert.ToInt32(currCategoryid)); categoryIds += "," + currCategoryid; productList = bllMall.GetList <WXMallProductInfo>(string.Format(" WebsiteOwner='{0}' And CategoryId in({1}) And ArticleCategoryType='BookingDoctorFuYou' And Stock>0 And IsDelete=0", bllMall.WebsiteOwner, categoryIds)); foreach (var item in productList) { item.PDescription = ""; } } //标签 if (!string.IsNullOrEmpty(tags)) { foreach (var tag in tags.Split(',')) { var data = bllMall.GetList <WXMallProductInfo>(string.Format(" WebsiteOwner='{0}' And Stock>0 And ArticleCategoryType='BookingDoctorFuYou' And IsDelete=0 And Tags like '%{1}%'", bllMall.WebsiteOwner, tag)); foreach (var item in data) { item.PDescription = ""; productList.Add(item); } } } productList = productList.DistinctBy(p => p.PID).ToList(); apiResp.status = true; apiResp.result = productList; return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp)); }
/// <summary> /// 医生列表 /// </summary> /// <param name="context"></param> /// <returns></returns> private string DoctorList(HttpContext context) { int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); string keyWord = context.Request["keyWord"]; string categoryId = context.Request["CategoryId"]; string isOnSale = context.Request["IsOnSale"]; string type = context.Request["type"]; StringBuilder sbWhere = new StringBuilder(string.Format("WebsiteOwner='{0}' And IsDelete=0 ", bllMall.WebsiteOwner)); if (!string.IsNullOrEmpty(type)) { sbWhere.AppendFormat("And ArticleCategoryType='{0}'", type); } else { sbWhere.AppendFormat("And ArticleCategoryType='BookingDoctor'"); } if (!string.IsNullOrEmpty(keyWord)) { sbWhere.AppendFormat(" And (PName like '%{0}%' Or ExArticleTitle_2 like '%{0}%' Or ExArticleTitle_4 like '%{0}%')", keyWord); } if (!string.IsNullOrEmpty(categoryId) && (!categoryId.Equals("0"))) { string categoryIds = bllMall.GetCateAndChildIds(Convert.ToInt32(categoryId)); sbWhere.AppendFormat(" And CategoryId in ({0})", categoryIds); } int totalCount = bllMall.GetCount <WXMallProductInfo>(sbWhere.ToString()); List <WXMallProductInfo> dataList = new List <WXMallProductInfo>(); dataList = bllMall.GetLit <WXMallProductInfo>(pageSize, pageIndex, sbWhere.ToString(), "Sort DESC, InsertDate DESC"); for (int i = 0; i < dataList.Count; i++) { dataList[i].PDescription = null; } return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = dataList })); }