/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="param">查询参数:json字符串格式：{StoreId:value1,BigClass:value2,GuiGe:value3,UnitNo:value4,MatNo:value5}</param>
/// <returns></returns>
public ActionResult GetDataList(string param, Pagination pagination)
{
new SystemCache().SetCache("stock_query", param == null?"":param, new TimeSpan(3, 0, 0));
var dataList = _sto_StockBusiness.GetDataList(param, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
public ActionResult GetStockOutList(string StoreId, string OutNo, string B_OutDate, string E_OutDate, Pagination pagination)
{
new SystemCache().SetCache("stockout_query", new { StoreId, OutNo, B_OutDate, E_OutDate }, new TimeSpan(3, 0, 0));
var dataList = _sto_StockOutBusiness.GetStockOutList(StoreId, OutNo, B_OutDate, E_OutDate, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据库所有表
/// </summary>
/// <param name="linkId">数据库连接Id</param>
/// <returns></returns>
public ActionResult GetDbTableList(string linkId)
{
Pagination pagination = new Pagination
{
PageIndex = 1,
PageRows = int.MaxValue,
RecordCount = int.MaxValue
};
return(Content(pagination.BuildTableResult_DataGrid(_rapidDevelopmentBus.GetDbTableList(linkId)).ToJson()));
}
/// <summary>
/// 获取日志列表
/// </summary>
/// <param name="logContent">日志内容</param>
/// <param name="logType">日志类型</param>
/// <param name="opUserName">操作人用户名</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="pagination">分页参数</param>
/// <returns></returns>
public ActionResult GetLogList(
string logContent,
string logType,
string opUserName,
DateTime?startTime,
DateTime?endTime,
Pagination pagination)
{
var dataList = _base_SysLogBusiness.GetLogList(logContent, logType, opUserName, startTime, endTime, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
public IActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = base_UserBusiness.GetDataList(condition, keyword, pagination);
return(Ok(new AjaxResult
{
Success = true,
Msg = "",
Data = pagination.BuildTableResult_DataGrid(dataList),
ErrorCode = 0
}));
}
/// <summary>
/// 获取日志列表
/// </summary>
/// <param name="logContent">日志内容</param>
/// <param name="logType">日志类型</param>
/// <param name="opUserName">操作人用户名</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="pagination">分页参数</param>
/// <returns></returns>
public ActionResult GetLogList(
Pagination pagination,
string logContent,
string level,
string logType,
string opUserName,
DateTime?startTime,
DateTime?endTime)
{
var dataList = _sysLogBus.GetLogList(pagination, logContent, logType, level, opUserName, startTime, endTime);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取日志列表
/// </summary>
/// <param name="logContent">日志内容</param>
/// <param name="logType">日志类型</param>
/// <param name="opUserName">操作人用户名</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="pagination">分页参数</param>
/// <returns></returns>
public ActionResult GetLogList(
string logContent,
string logType,
string opUserName,
DateTime?startTime,
DateTime?endTime,
Pagination <Base_SysLog> pagination)
{
this._UserDepDepartmentService.getUserDepartmentInfoByUserID(opUserName);
var dataList = _base_SysLogBusiness.GetLogList(logContent, logType, opUserName, startTime, endTime, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(int?special_status, string product_id, string product_name, string product_area, string start_time1, string start_time2, string create_time1, string create_time2, Pagination pagination)
{
var dataList = _orderBusiness.GetDataList(special_status, Operator.UserId, product_id, product_name, product_area, start_time1, start_time2, create_time1, create_time2, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public IActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _pbdmOrganRepository.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string coupons_name, Pagination pagination)
{
var dataList = _product_couponsBusiness.GetDataList(coupons_name, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="title">门票标题</param>
/// <param name="notice">购买须知</param
/// <param name="brief">产品简介</param>
/// <param name="refund_type">退票类型</param>
/// <param name="status">上线状态</param>
/// <returns></returns>
public ActionResult GetDataList(string title, string notice, string brief, int?refund_type, int?status, Pagination pagination)
{
var dataList = _ticketsBusiness.GetDataList(title, notice, brief, refund_type, status, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _pro_MaterialRequisitionItemBusiness.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string product_type_id, string title, DateTime?create_time1, DateTime?create_time2, Pagination pagination, string enable_flag)
{
var dataList = _productBusiness.GetDataList(3, product_type_id, title, string.Empty, create_time1, create_time2, pagination, enable_flag);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 返回数据表格数据
/// 注：Easyui的DataGrid
/// </summary>
/// <param name="dataList">数据列表</param>
/// <param name="pagination">分页参数</param>
/// <returns></returns>
public ActionResult DataTable_Easyui(object dataList, Pagination pagination)
{
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _base_AppSecretBusiness.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取利润排行数据
/// </summary>
/// <param name="product_type"></param>
/// <returns></returns>
public ActionResult GetProductProfitDetail(string product_type, Pagination pagination)
{
var dataList = _productBusiness.GetProductProfitDetail(product_type, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _sto_StockSettlementItemBusiness.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="title">产品/门票名称</param>
/// <returns></returns>
public ActionResult GetDataList(int marketingType, string title, Pagination pagination)
{
var dataList = _product_marketingBusiness.GetDataList(marketingType, title, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(int?flag_type, string product_type_id, string parent_id, Pagination pagination)
{
var dataList = _product_tagBusiness.GetProductTagModel(flag_type, product_type_id, parent_id, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string code, Pagination pagination)
{
var dataList = _dictionaryBusiness.GetDataList(code, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
public ActionResult GetDataList(Pagination pagination, string keyword)
{
var dataList = _appSecretBus.GetDataList(pagination, keyword);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _articleBusiness.GetDataList(condition, keyword, pagination).Select(m => new { m.Id, m.Title }).ToList();
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public ActionResult GetDataList(string condition, string keyword, Pagination pagination)
{
var dataList = _oms_OrdDetailService.GetDataList(condition, keyword, pagination);
return(Content(pagination.BuildTableResult_DataGrid(dataList).ToJson()));
}
/// <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);
}
