public JsonResult Recordlist(int page, int rows)
{
ShopQuery query = new ShopQuery()
{
BrandId = CurrentSellerManager.ShopId,
PageNo = page,
PageSize = rows
};
ObsoletePageModel <ShopRenewRecord> accounts = _iShopService.GetShopRenewRecords(query);
IList <ShopRecordModel> models = new List <ShopRecordModel>();
foreach (var item in accounts.Models.ToArray())
{
ShopRecordModel model = new ShopRecordModel();
model.Id = (int)item.Id;
model.OperateType = item.OperateType.ToDescription();
model.OperateDate = item.OperateDate.ToString("yyyy-MM-dd HH:mm");
model.Operate = item.Operator;
model.Content = item.OperateContent;
model.Amount = item.Amount;
models.Add(model);
}
return(Json(new { rows = models, total = accounts.Total }));
}
public void GetShopsTest()
{
ShopQuery queryModel = new ShopQuery
{
ShopName = "店铺"
};
var service = Instance <IShopService> .Create;
var shops = service.GetShops(queryModel);
string s = "";
}
/// <summary>
/// 获取店铺信息（以分页的形式展示）
/// </summary>
/// <param name="shopQueryModel">ShopQuery对象</param>
/// <returns></returns>
public static QueryPageModel <Shop> GetShops(ShopQuery shopQueryModel)
{
var data = Service.GetShops(shopQueryModel);
return(new QueryPageModel <Shop>()
{
Models = data.Models.Map <List <Shop> >(),
Total = data.Total
});
}
public JsonResult List(long?shopGradeId, int?shopStatus, int page, int rows, string shopName, string companyName, string shopAccount, string type = "")
{
ShopInfo.ShopAuditStatus?nullable;
ShopQuery shopQuery = new ShopQuery();
shopQuery.PageSize = rows;
shopQuery.PageNo = page;
shopQuery.ShopName = shopName;
shopQuery.ShopAccount = shopAccount;
shopQuery.CompanyName = companyName;
shopQuery.ShopGradeId = shopGradeId;
shopQuery.Type = type;
ShopQuery shopQuery1 = shopQuery;
int? nullable1 = shopStatus;
if (nullable1.HasValue)
{
nullable = new ShopInfo.ShopAuditStatus?((ShopInfo.ShopAuditStatus)nullable1.GetValueOrDefault());
}
else
{
nullable = null;
}
shopQuery1.Status = nullable;
PageModel <ShopInfo> shops = ServiceHelper.Create <IShopService>().GetShops(shopQuery);
ServiceHelper.Create <ICategoryService>();
IShopService shopService = ServiceHelper.Create <IShopService>();
IEnumerable <ShopModel> array =
from item in shops.Models.ToArray()
select new ShopModel()
{
Id = item.Id,
Account = item.ShopAccount,
CompanyName = item.CompanyName,
EndDate = (type == "Auditing" ? "--" : (item.EndDate.HasValue ? item.EndDate.Value.ToString("yyyy-MM-dd") : "")),
Name = item.ShopName,
ShopGrade = (shopService.GetShopGrade(item.GradeId) == null ? "" : shopService.GetShopGrade(item.GradeId).Name),
Status = item.ShowShopAuditStatus.ToDescription(),
IsSelf = item.IsSelf,
CreateDate = item.CreateDate,
Disabled = item.Disabled
};
DataGridModel <ShopModel> dataGridModel = new DataGridModel <ShopModel>()
{
rows = array,
total = shops.Total
};
return(Json(dataGridModel));
}
public JsonResult List(long?shopGradeId, int?shopStatus, int page, int rows, string shopName, string shopAccount, string type = "")
{
var queryModel = new ShopQuery()
{
Status = (Himall.Model.ShopInfo.ShopAuditStatus?)shopStatus,
PageSize = rows,
PageNo = page,
ShopAccount = shopAccount,
ShopName = shopName,
ShopGradeId = shopGradeId
};
if (type == "Auditing")
{
if (shopStatus == null)
{
queryModel.Status = Himall.Model.ShopInfo.ShopAuditStatus.WaitAudit;
queryModel.MoreStatus.Add(Himall.Model.ShopInfo.ShopAuditStatus.WaitConfirm);
}
}
var shops = ShopApplication.GetShops(queryModel);
var shopGrades = ShopApplication.GetShopGrades();
var shopAccounts = ShopApplication.GetShopAccounts(shops.Models.Select(p => p.Id));
var models = shops.Models.Select(item =>
{
var shopGrade = shopGrades.FirstOrDefault(p => p.Id == item.GradeId);
var shopAccountModel = shopAccounts.FirstOrDefault(p => p.ShopId == item.Id);
return(new ShopModel()
{
Id = item.Id,
Account = item.ShopAccount,
EndDate = type == "Auditing" ? "--" : item.EndDate.HasValue ? item.EndDate.Value.ToString("yyyy-MM-dd") : "",
Name = item.ShopName,
ShopGrade = shopGrade != null ? shopGrade.Name : "",
Status = item.EndDate < DateTime.Now ? "已过期" : item.ShowShopAuditStatus.ToDescription(),
IsSelf = item.IsSelf,
BusinessType = item.BusinessType == null ? Himall.CommonModel.ShopBusinessType.Enterprise : item.BusinessType.Value,
Balance = shopAccountModel != null ? shopAccountModel.Balance : 0
});
});
var dataGrid = new DataGridModel <ShopModel>()
{
rows = models, total = shops.Total
};
return(Json(dataGrid));
}
public JsonResult GetPlatfromMessage()
{
ProductQuery productQuery = new ProductQuery()
{
PageSize = 10000,
PageNo = 1,
AuditStatus = new ProductInfo.ProductAuditStatus[] { ProductInfo.ProductAuditStatus.WaitForAuditing },
SaleStatus = new ProductInfo.ProductSaleStatus?(ProductInfo.ProductSaleStatus.OnSale)
};
ProductQuery productQuery1 = productQuery;
int num = ServiceHelper.Create <IProductService>().GetProducts(productQuery1).Models.Count();
ShopQuery shopQuery = new ShopQuery()
{
Status = new ShopInfo.ShopAuditStatus?(0),
PageSize = 10000,
PageNo = 1
};
int num1 = (
from s in ServiceHelper.Create <IShopService>().GetShops(shopQuery).Models
where (int)s.ShopStatus == 2 || (int)s.ShopStatus == 5 || (int)s.ShopStatus == 3
select s).Count();
long? nullable = null;
int num2 = ServiceHelper.Create <IBrandService>().GetShopBrandApplys(nullable, new int?(0), 1, 10000, "").Models.Count();
ComplaintQuery complaintQuery = new ComplaintQuery()
{
Status = new OrderComplaintInfo.ComplaintStatus?(OrderComplaintInfo.ComplaintStatus.Dispute),
PageSize = 10000,
PageNo = 1
};
ComplaintQuery complaintQuery1 = complaintQuery;
int num3 = ServiceHelper.Create <IComplaintService>().GetOrderComplaints(complaintQuery1).Models.Count();
RefundQuery refundQuery = new RefundQuery()
{
ConfirmStatus = new OrderRefundInfo.OrderRefundConfirmStatus?(OrderRefundInfo.OrderRefundConfirmStatus.UnConfirm),
AuditStatus = new OrderRefundInfo.OrderRefundAuditStatus?(OrderRefundInfo.OrderRefundAuditStatus.Audited),
PageSize = 10000,
PageNo = 1
};
RefundQuery refundQuery1 = refundQuery;
int num4 = ServiceHelper.Create <IRefundService>().GetOrderRefunds(refundQuery1).Models.Count();
int num5 = num + num1 + num2 + num3 + num4;
return(Json(new { ProductWaitForAuditing = num, ShopWaitAudit = num1, BrandAudit = num2, ComplaintDispute = num3, RefundWaitAudit = num4, AllMessageCount = num5 }, JsonRequestBehavior.AllowGet));
}
public JsonResult List(ShopQuery query, string type = "")
{
if (type == "Auditing")
{
query.Status = ShopInfo.ShopAuditStatus.WaitAudit;
query.MoreStatus.Add(ShopInfo.ShopAuditStatus.WaitConfirm);
}
var shops = ShopApplication.GetShops(query);
var shopGrades = ShopApplication.GetShopGrades();
var shopAccounts = ShopApplication.GetShopAccounts(shops.Models.Select(p => p.Id).ToList());
var models = shops.Models.Select(item =>
{
var shopGrade = shopGrades.FirstOrDefault(p => p.Id == item.GradeId);
var shopAccountModel = shopAccounts.FirstOrDefault(p => p.ShopId == item.Id);
var shopbranchs = ShopBranchApplication.GetShopBranchByShopId(item.Id);
return(new ShopModel()
{
Id = item.Id,
Account = item.ShopAccount,
EndDate = type == "Auditing" ? "--" : item.EndDate.HasValue ? item.EndDate.Value.ToString("yyyy-MM-dd") : "",
Name = item.ShopName,
ShopGrade = shopGrade != null ? shopGrade.Name : "",
Status = (item.EndDate < DateTime.Now && item.ShowShopAuditStatus == ShopInfo.ShopAuditStatus.Open) ? "已过期" : item.ShowShopAuditStatus.ToDescription(),
IsSelf = item.IsSelf,
BusinessType = item.BusinessType == null ? CommonModel.ShopBusinessType.Enterprise : item.BusinessType.Value,
Balance = shopAccountModel != null ? shopAccountModel.Balance : 0,
ShopBranchCount = shopbranchs.Count()
});
});
var dataGrid = new DataGridModel <ShopModel>()
{
rows = models, total = shops.Total
};
return(Json(dataGrid));
}
public ActionResult Index(string keywords = "", long categoryId = 0, long brandId = 0, int orderBy = 0, int pageNo = 1, int pageSize = 40)
{
ShopQuery queryModel = new ShopQuery
{
ShopName = keywords,
CategoryId = categoryId,
BrandId = brandId,
PageNo = pageNo,
PageSize = pageSize,
OrderBy = orderBy,
Status = ShopInfo.ShopAuditStatus.Open
};
var shopService = _iShopService;
var model = shopService.GetShops(queryModel);
var shops = model.Models.ToList();
var defaultValue = "5.00";
Dictionary <long, string> brands = new Dictionary <long, string>();
Dictionary <long, string> categorys = new Dictionary <long, string>();
foreach (var m in shops)
{
//销量
m.Sales = shopService.GetSales(m.Id);
var shopStatisticOrderComments = _iShopService.GetShopStatisticOrderComments(m.Id);
var productAndDescription = shopStatisticOrderComments.Where(c => c.CommentKey == StatisticOrderCommentsInfo.EnumCommentKey.ProductAndDescription).FirstOrDefault();
var sellerServiceAttitude = shopStatisticOrderComments.Where(c => c.CommentKey == StatisticOrderCommentsInfo.EnumCommentKey.SellerServiceAttitude).FirstOrDefault();
var sellerDeliverySpeed = shopStatisticOrderComments.Where(c => c.CommentKey == StatisticOrderCommentsInfo.EnumCommentKey.SellerDeliverySpeed).FirstOrDefault();
//宝贝与描述
m.ProductAndDescription = productAndDescription != null?string.Format("{00:F}", productAndDescription.CommentValue) : defaultValue;
//卖家服务态度
m.SellerServiceAttitude = sellerServiceAttitude != null?string.Format("{00:F}", sellerServiceAttitude.CommentValue) : defaultValue;
//卖家发货速度
m.SellerDeliverySpeed = sellerDeliverySpeed != null?string.Format("{00:F}", sellerDeliverySpeed.CommentValue) : defaultValue;
foreach (var b in m.Himall_ShopBrands) //获取品牌
{
if (!brands.ContainsKey(b.BrandId))
{
brands.Add(b.BrandId, b.Himall_Brands.Name);
}
}
foreach (var p in m.Himall_Products.Where(d => d.SaleStatus == ProductInfo.ProductSaleStatus.OnSale && d.AuditStatus == ProductInfo.ProductAuditStatus.Audited)) //获取类目
{
if (!categorys.ContainsKey(p.CategoryId))
{
categorys.Add(p.CategoryId, p.Himall_Categories.Name);
}
if (m.IsSelf == true)
{
if (!brands.ContainsKey(p.BrandId))
{
var branddata = _iBrandService.GetBrand(p.BrandId);
if (branddata != null)
{
brands.Add(branddata.Id, branddata.Name);
}
}
m.SellerDeliverySpeed = "5.00";
m.SellerServiceAttitude = "5.00";
m.ProductAndDescription = "5.00";
}
}
}
PagingInfo info = new PagingInfo
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = model.Total
};
ViewBag.pageInfo = info;
ViewBag.QueryModel = queryModel;
ViewBag.Brands = brands;
ViewBag.Categorys = categorys;
return(View(shops));
}
public static int GetShopCount(ShopQuery query)
{
return(BaseApplicaion <IShopService> .Service.GetShopCount(query));
}
public ActionResult Index(string keywords = "", long categoryId = 0, long brandId = 0, int orderBy = 0, int pageNo = 1, int pageSize = 40)
{
var query = new ShopQuery
{
ShopName = keywords,
CategoryId = categoryId,
BrandId = brandId,
PageNo = pageNo,
PageSize = pageSize,
Status = Entities.ShopInfo.ShopAuditStatus.Open
};
if (orderBy == 1)
{
query.Sort = "OrderCount";
}
var result = new ShopSearchViewModel
{
Keywords = keywords,
CategoryId = categoryId,
BrandId = brandId,
Shops = new List <Shop>(),
OrderBy = orderBy,
IsSaleCountOnOff = SiteSettingApplication.SiteSettings.ProductSaleCountOnOff == 1
};
var shopData = _iShopService.GetShops(query);
var shops = shopData.Models;
if (shopData.Total == 0)
{
return(View(result));
}
result.Pager = new PagingInfo
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = shopData.Total
};
result.Total = shopData.Total;
var statisticList = ShopApplication.GetStatisticOrderComment(shops.Select(p => p.Id).ToList());
var productQuery = new ProductQuery
{
PageNo = 1,
PageSize = 4,
OnSale = true,
IsAsc = false,
Sort = "displaysale",
};
foreach (var item in shops)
{
var shop = new Shop();
shop.Id = item.Id;
shop.ShopName = item.ShopName;
//销量
shop.SaleCount = (int)ShopApplication.GetShopDisplaySales(item.Id);
var statistic = statisticList.FirstOrDefault(p => p.ShopId == item.Id);
//宝贝与描述
shop.ProductAndDescription = string.Format("{00:F}", statistic.ProductAndDescription);
//卖家服务态度
shop.SellerServiceAttitude = string.Format("{00:F}", statistic.SellerServiceAttitude);
//卖家发货速度
shop.SellerDeliverySpeed = string.Format("{00:F}", statistic.SellerDeliverySpeed);
//查询商品
productQuery.ShopId = item.Id;
var products = ProductManagerApplication.GetProducts(productQuery);
shop.ProductCount = products.Total;
shop.Products = products.Models.Select(p => new Product {
Id = p.Id,
Image = MallIO.GetProductSizeImage(p.ImagePath, 1, (int)ImageSize.Size_150),
Price = p.MinSalePrice,
CategoryId = p.CategoryId,
}).ToList();
shop.Logo = item.Logo;
result.Shops.Add(shop);
}
//经营品牌
var shopBrands = ShopApplication.GetShopBrands(shops.Select(p => p.Id).ToList());
result.Brands = shopBrands.GroupBy(p => p.BrandId).ToDictionary(k => k.Key, v => v.FirstOrDefault().BrandName);
//经营类型
var CategoryIds = result.Shops.SelectMany(s => s.Products.Select(p => p.CategoryId));
result.Categorys = CategoryApplication.GetCategories()
.Where(p => CategoryIds.Contains(p.Id))
.ToDictionary(k => k.Id, v => v.Name);
return(View(result));
}
public ShopController(ShopLocalContext _context)
{
context = _context;
shopQuery = new ShopQuery(context);
}
public ActionResult Index(string keywords = "", long categoryId = 0L, long brandId = 0L, int orderBy = 0, int pageNo = 1, int pageSize = 40)
{
ShopQuery shopQuery = new ShopQuery()
{
ShopName = keywords,
CategoryId = categoryId,
BrandId = brandId,
PageNo = pageNo,
PageSize = pageSize,
OrderBy = orderBy
};
ShopQuery shopQuery1 = shopQuery;
IShopService shopService = ServiceHelper.Create <IShopService>();
PageModel <ShopInfo> shops = shopService.GetShops(shopQuery1);
List <ShopInfo> list = shops.Models.ToList();
string str = "5";
Dictionary <long, string> nums = new Dictionary <long, string>();
Dictionary <long, string> nums1 = new Dictionary <long, string>();
foreach (ShopInfo sales in list)
{
sales.Sales = shopService.GetSales(sales.Id);
IQueryable <StatisticOrderCommentsInfo> shopStatisticOrderComments = ServiceHelper.Create <IShopService>().GetShopStatisticOrderComments(sales.Id);
StatisticOrderCommentsInfo statisticOrderCommentsInfo = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 1
select c).FirstOrDefault();
StatisticOrderCommentsInfo statisticOrderCommentsInfo1 = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 9
select c).FirstOrDefault();
StatisticOrderCommentsInfo statisticOrderCommentsInfo2 = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 9
select c).FirstOrDefault();
sales.ProductAndDescription = (statisticOrderCommentsInfo != null ? string.Format("{0:F}", statisticOrderCommentsInfo.CommentValue) : str);
sales.SellerServiceAttitude = (statisticOrderCommentsInfo1 != null ? string.Format("{0:F}", statisticOrderCommentsInfo1.CommentValue) : str);
sales.SellerDeliverySpeed = (statisticOrderCommentsInfo2 != null ? string.Format("{0:F}", statisticOrderCommentsInfo2.CommentValue) : str);
foreach (ShopBrandsInfo himallShopBrand in sales.Himall_ShopBrands)
{
if (nums.ContainsKey(himallShopBrand.BrandId))
{
continue;
}
nums.Add(himallShopBrand.BrandId, himallShopBrand.Himall_Brands.Name);
}
foreach (ProductInfo himallProduct in sales.Himall_Products)
{
if (nums1.ContainsKey(himallProduct.CategoryId))
{
continue;
}
nums1.Add(himallProduct.CategoryId, himallProduct.Himall_Categories.Name);
}
}
PagingInfo pagingInfo = new PagingInfo()
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = shops.Total
};
ViewBag.pageInfo = pagingInfo;
ViewBag.QueryModel = shopQuery1;
ViewBag.Brands = nums;
ViewBag.Categorys = nums1;
return(View(list));
}
public PageModel <ShopInfo> GetShops(ShopQuery shopQueryModel)
{
IQueryable <ShopInfo> gradeId = context.ShopInfo.AsQueryable <ShopInfo>();
long?shopGradeId = shopQueryModel.ShopGradeId;
if ((shopGradeId.GetValueOrDefault() <= 0 ? false : shopGradeId.HasValue))
{
gradeId =
from item in gradeId
where item.GradeId == shopQueryModel.ShopGradeId.Value
select item;
}
if (shopQueryModel.BrandId > 0)
{
gradeId =
from item in gradeId
where item.Himall_ShopBrands.Any((ShopBrandsInfo a) => a.BrandId == shopQueryModel.BrandId)
select item;
}
if (shopQueryModel.CategoryId > 0)
{
gradeId =
from item in gradeId
where item.Himall_Products.Any((ProductInfo a) => a.CategoryId == shopQueryModel.CategoryId)
select item;
}
if (!string.IsNullOrWhiteSpace(shopQueryModel.ShopName))
{
gradeId =
from item in gradeId
where item.ShopName.Contains(shopQueryModel.ShopName)
select item;
}
if (!string.IsNullOrWhiteSpace(shopQueryModel.ShopAccount))
{
gradeId =
from item in gradeId
where context.ManagerInfo.Any((ManagerInfo m) => m.UserName.Equals(shopQueryModel.ShopAccount) && m.ShopId != 0 && m.RoleId == 0)
select item;
}
if (shopQueryModel.Status.HasValue && shopQueryModel.Status.Value != 0)
{
ShopInfo.ShopAuditStatus value = shopQueryModel.Status.Value;
DateTime dateTime = DateTime.Now.Date.AddSeconds(-1);
ShopInfo.ShopAuditStatus shopAuditStatu = value;
if (shopAuditStatu == ShopInfo.ShopAuditStatus.HasExpired)
{
gradeId =
from d in gradeId
where (int)d.ShopStatus == 7 && (d.EndDate < dateTime)
select d;
}
else
{
gradeId = (shopAuditStatu != ShopInfo.ShopAuditStatus.Open ?
from d in gradeId
where (int)d.ShopStatus == (int)value
select d :
from d in gradeId
where (int)d.ShopStatus == 7 && (d.EndDate > dateTime)
select d);
}
}
Func <IQueryable <ShopInfo>, IOrderedQueryable <ShopInfo> > func = null;
if (shopQueryModel.OrderBy == 1)
{
DbSet <OrderInfo> orderInfo = context.OrderInfo;
func = (IQueryable <ShopInfo> d) =>
from o in d
orderby orderInfo.Where((OrderInfo p) => p.ShopId == o.Id && (int)p.OrderStatus == 5).Count() descending
select o;
}
else
{
func = (IQueryable <ShopInfo> d) =>
from o in d
orderby o.ShopStatus descending
select o;
}
int num = gradeId.Count();
gradeId = gradeId.GetPage(out num, shopQueryModel.PageNo, shopQueryModel.PageSize, func);
foreach (ShopInfo list in gradeId.ToList())
{
ManagerInfo managerInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.ShopId.Equals(list.Id));
list.ShopAccount = (managerInfo == null ? "" : managerInfo.UserName);
}
return(new PageModel <ShopInfo>()
{
Models = gradeId,
Total = num
});
}
public PageModel <ShopInfo> GetAuditingShops(ShopQuery shopQueryModel)
{
return(null);
}
