/// <summary>
/// 删除文件及记录
/// </summary>
/// <param name="uploadType">图片字段</param>
/// <param name="fileBase64"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public AjaxResult DeleteFileToServer(string uploadType, string id, string fileName)
{
fileName = fileName.Replace(new ImagesData().ServicePath, "");
var imageObj = new ImagesData()
{
ImageName = fileName
};
if (fileName.IsNullOrEmpty())
{
return(Error("文件为空"));
}
//FastDFSHelper.RemoveFile(fileName);
dynamic obj = null;
var _ProductBusiness = new ProductBusiness();
var _product_tagBusiness = new product_tagBusiness();
var _DictionaryBusiness = new DictionaryBusiness();
var _product_IntroductionBusiness = new product_IntroductionBusiness();
switch (uploadType)
{
case "images":
case "logo":
case "photooffarmers":
case "commodity_photo":
obj = (product)_ProductBusiness.GetEntity(id.ToInt());
break;
case "img_url":
obj = (product_tag)_product_tagBusiness.GetEntity(id);
break;
case "dicimages":
obj = (dictionary)_DictionaryBusiness.GetEntity(id);
break;
default:
obj = (product_Introduction)_product_IntroductionBusiness.GetEntity(uploadType);
break;
}
string tempName = string.Empty;
if (obj != null)
{
switch (uploadType)
{
case "images": //产品图片
tempName = obj.images;
obj.images = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"images"
});
break;
case "logo": //logo
tempName = obj.logo;
obj.logo = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"logo"
});
break;
case "photooffarmers": //农户照片
tempName = obj.photooffarmers;
obj.photooffarmers = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"photooffarmers"
});
break;
case "commodity_photo": //扶贫商品照片
tempName = obj.commodity_photo;
obj.commodity_photo = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"commodity_photo"
});
break;
case "img_url": //热门城市logo
tempName = obj.img_url;
obj.img_url = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_product_tagBusiness.UpdateAny(obj, new List <string>()
{
"img_url"
});
break;
case "dicimages": //数据字典照片
tempName = obj.images;
obj.images = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_DictionaryBusiness.UpdateAny(obj, new List <string>()
{
"images"
});
break;
default:
tempName = obj.picture;
obj.picture = tempName.Replace(fileName + ",", "").Replace("," + fileName, "").Replace(fileName, "");
_product_IntroductionBusiness.UpdateAny(obj, new List <string>()
{
"picture"
});
break;
}
}
return(Success(imageObj));
}
/// <summary>
/// 上传文件到文件系统服务器
/// </summary>
/// <param name="uploadType">图片字段</param>
/// <param name="fileBase64"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public AjaxResult UploadFileToServer(string uploadType, string id, string multiple, string fileBase64, string fileName)
{
string name = FastDFSHelper.UploadFile(fileBase64, fileName);
if (name.IsNullOrEmpty())
{
return(Error("上传失败"));
}
dynamic obj = null;
var _ProductBusiness = new ProductBusiness();
var _product_tagBusiness = new product_tagBusiness();
var _DictionaryBusiness = new DictionaryBusiness();
var _product_IntroductionBusiness = new product_IntroductionBusiness();
switch (uploadType)
{
case "images":
case "logo":
case "photooffarmers":
case "commodity_photo":
obj = (product)_ProductBusiness.GetEntity(id.ToInt());
break;
case "img_url":
obj = (product_tag)_product_tagBusiness.GetEntity(id);
break;
case "dicimages":
obj = (dictionary)_DictionaryBusiness.GetEntity(id);
break;
default:
obj = (product_Introduction)_product_IntroductionBusiness.GetTheData(uploadType);
break;
}
if (obj != null)
{
switch (uploadType)
{
case "images": //产品图片
obj.images = multiple == "0" ? name : (string.IsNullOrEmpty(obj.images) ? name : obj.images + "," + name);
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"images"
});
break;
case "logo": //logo
obj.logo = multiple == "0" ? name : (string.IsNullOrEmpty(obj) ? name : obj.logo + "," + name);
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"logo"
});
break;
case "photooffarmers": //农户照片
obj.photooffarmers = multiple == "0" ? name : (string.IsNullOrEmpty(obj.photooffarmers) ? name : obj.photooffarmers + "," + name);
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"photooffarmers"
});
break;
case "commodity_photo": //扶贫商品照片
obj.commodity_photo = multiple == "0" ? name : (string.IsNullOrEmpty(obj.commodity_photo) ? name : obj.commodity_photo + "," + name);
_ProductBusiness.UpdateAny(obj, new List <string>()
{
"commodity_photo"
});
break;
case "img_url": //热门城市logo
obj.img_url = multiple == "0" ? name : (string.IsNullOrEmpty(obj.img_url) ? name : obj.img_url + "," + name);
_product_tagBusiness.UpdateAny(obj, new List <string>()
{
"img_url"
});
break;
case "dicimages": //数据字典照片
obj.images = multiple == "0" ? name : (string.IsNullOrEmpty(obj.images) ? name : obj.images + "," + name);
_DictionaryBusiness.UpdateAny(obj, new List <string>()
{
"images"
});
break;
default:
obj.picture = multiple == "0" ? name : (string.IsNullOrEmpty(obj.picture) ? name : obj.picture + "," + name);
_product_IntroductionBusiness.UpdateAny(obj, new List <string>()
{
"picture"
});
break;
}
}
return(Success(new ImagesData()
{
ImageName = name
}));
}
/// <summary>
/// 首页数据
/// </summary>
/// <param name="days"></param>
/// <param name="pagination"></param>
/// <returns></returns>
public MainData GetMainData(int days, Pagination pagination)
{
var currentTime = DateTime.Now.ToCstTime().ToString("yyyy-MM-dd");
var yesterdayTime = DateTime.Now.ToCstTime().AddDays(-1).ToString("yyyy-MM-dd");
var data = new MainData();
var listPays = new payBusiness().GetIQueryable().Where(x => x.status == 1).ToList(); //支付记录
var listProduct = new ProductBusiness().GetIQueryable().ToList(); //产品清单
var listMembers = new membersBusiness().GetIQueryable().ToList(); //用户记录
var listOrders = new orderBusiness().GetIQueryable().Where(x => x.status == 1).ToList().Where(x => listPays.Find(a => a.order_id == x.Id) != null).ToList(); //订单 -支付完成的订单
//浏览数
data.T_VisitsNum = 0;
data.Y_VisitsNum = 0;
data.A_VisitsNum = 0;
//注册用户数
data.T_RegisteredUsers = listMembers.Where(x => x.registration_time?.ToString("yyyy-MM-dd") == currentTime).Count();
data.Y_RegisteredUsers = listMembers.Where(x => x.registration_time?.ToString("yyyy-MM-dd") == yesterdayTime).Count();
data.A_RegisteredUsers = listMembers.Where(x => x.registration_time != null).Count();
//团长新增数
data.T_NewHead = listMembers.Where(x => x.header_time?.ToString("yyyy-MM-dd") == currentTime).Count();
data.Y_NewHead = listMembers.Where(x => x.header_time?.ToString("yyyy-MM-dd") == yesterdayTime).Count();
data.A_NewHead = listMembers.Where(x => x.header_time != null).Count();
//参团数
data.T_Participants = listOrders.Where(x => x.create_time.ToString("yyyy-MM-dd") == currentTime).Sum(x => x.num);
data.Y_Participants = listOrders.Where(x => x.create_time.ToString("yyyy-MM-dd") == yesterdayTime).Sum(x => x.num);
data.A_Participants = listOrders.Where(x => x.create_time != null).Sum(x => x.num);
//交易额
data.T_TradingVolume = listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == currentTime).Sum(x => x.money);
data.Y_TradingVolume = listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == yesterdayTime).Sum(x => x.money);
data.A_TradingVolume = listPays.Where(x => x.pay_time != null).Sum(x => x.money);
decimal value = 0;
for (int i = days - 1; i >= 0; i--)
{
value += listPays.Where(x => x.pay_time?.ToString("yyyy-MM-dd") == DateTime.Now.ToCstTime().AddDays(-i).ToString("yyyy-MM-dd")).Sum(x => x.money);
data.xAxisData.Add(DateTime.Now.ToCstTime().AddDays(-i).ToString("MM/dd"));
data.yAxisData.Add(value);
}
List <SaleRank> ProductSaleRank = new List <SaleRank>();
var listProductSaleRank = listOrders.GroupBy(x => x.product_id);
foreach (var item in listProductSaleRank)
{
ProductSaleRank.Add(new SaleRank()
{
name = listProduct.Find(x => x.Id == int.Parse(item.Key))?.title, num = item.Sum(x => x.num)
});
}
data.ProductSaleRank = pagination.BuildTableResult_DataGrid(ProductSaleRank.GetPagination(pagination).ToList());
List <SaleRank> TeamSaleRank = new List <SaleRank>();
var listTeamSaleRank = listOrders.Where(x => x.share_id != null).GroupBy(x => x.share_id);
foreach (var item in listTeamSaleRank)
{
TeamSaleRank.Add(new SaleRank()
{
name = listMembers.Find(x => x.oppen_id == item.Key)?.nick_name, num = item.Sum(x => x.num)
});
}
data.TeamSaleRank = pagination.BuildTableResult_DataGrid(TeamSaleRank.GetPagination(pagination).ToList());
return(data);
}