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