no message

zhaojs

2023-09-27 74098f1401afe40f961d1d167bb18dd0a71c4d59

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
using CommonUtil;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Operater.DAL;
using Operater.DbModel;
using Operater.DTO;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
 
namespace Api.Operater.Controllers
{
    [Route(TopConstants.API_ROUTE)]
    public class DataStaticController : BaseController
    {
        /// <summary>
        /// 获取当天数据
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public IActionResult GetTodayData()
        {
            GetTodayDataResponse response = new GetTodayDataResponse
            {
                YzPayAmount = 0,
                YzTradeCount = 0,
                YcTradeAmount = 0,
                ProfitPay = 0
            };
            string tradeStr = $"select count(1) as count,sum(payment) as payment,sum(real_pay) as realpay from yz_tradeinfo where create_time>='{DateTime.Now.ToString("yyyy-MM-dd 00:00:00")}'";
            DataTable tradeDt = new YzOrderinfoDAL().SearchBySqlDataTable("", tradeStr);
            if (!tradeDt.IsNull() && tradeDt.Rows.Count > 0)
            {
                response.YzTradeCount = tradeDt.Rows[0]["count"].ToString().IsNullOrEmpty() ? 0 : int.Parse(tradeDt.Rows[0]["count"].ToString());
                response.YcTradeAmount = tradeDt.Rows[0]["payment"].ToString().IsNullOrEmpty() ? 0 : decimal.Parse(tradeDt.Rows[0]["payment"].ToString());
                response.YzPayAmount = tradeDt.Rows[0]["realpay"].ToString().IsNullOrEmpty() ? 0 : decimal.Parse(tradeDt.Rows[0]["realpay"].ToString());
            }
 
            //利润
            string relaStr = $"SELECT ali_tid as tid FROM yz_orderinfo where create_time>='{DateTime.Now.ToString("yyyy-MM-dd 00:00:00")}' and ali_trade_status='1'";
            string staticCount = $"select sum(sum_product_payment+shipping_fee) as payment from ali_tradeinfo where tid in({relaStr})";
            DataTable aliFeeDt = new YzOrderinfoDAL().SearchBySqlDataTable("", staticCount);
            if (!aliFeeDt.IsNull())
            {
 
                decimal aliFee = aliFeeDt.Rows[0]["payment"].ToString().IsNullOrEmpty() ? 0 : decimal.Parse(aliFeeDt.Rows[0]["payment"].ToString());
                response.ProfitPay = response.YzPayAmount - aliFee;
            }
            return Success(response);
        }
 
        /// <summary>
        /// 获取时间范围内的统计数据
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [HttpPost]
        public IActionResult GetStaticData([FromBody] GetStaticDataRequest request)
        {
            var expression = Expressionable.Create<DataStatic>().AndIF(!request.StartTime.IsNull(),t =>t.StaticTime>=request.StartTime)
                                                                .AndIF(!request.EndTime.IsNull(), t => t.StaticTime <= request.EndTime)
                                                                        .ToExpression();
            var taskList = new DataStaticDAL().ListGet(expression, t => t.StaticTime, DbEnum.OrderType.Desc);
            return Success(taskList);
        }
    }
}