仓库看板后台提交

YL

2021-05-13 ef64fca176cd33702a999981c7f91e1b77a1adb3

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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
using MyWebApi.DLL.BLL;
using MyWebApi.Models;
using MyWebApi.Tools;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using System.Web.Http.Cors;
using WebApi.OutputCache.V2;
 
namespace MyWebApi.Controllers
{
 
 
    [EnableCors(origins: "*", headers: "*", methods: "*")]
    [RoutePrefix(prefix: "api/loaddata")]
    public class LoadDataController : ApiController
    {
        string LineCode = System.Configuration.ConfigurationManager.AppSettings["LineCode"];//流水线编码
        string LineCodeList = System.Configuration.ConfigurationManager.AppSettings["LineCodeList"];//流水线看板今日全部流水线编码:产线1、产线2、产线3、产线4、产线5、产线6
        string HouseCode = System.Configuration.ConfigurationManager.AppSettings["HouseCode"];//仓库编码
        /// <summary>
        /// 流水线看板图型展示数据
        /// </summary>
        /// <returns></returns>
        [Route(template: "LineData")]
        [HttpGet]
 
        #region[流水线看板图型展示数据]
        public HttpResponseMessage LineData()
        {
 
            List<DataTable> list = LoadDataBLL.LineData(LineCode, LineCodeList);
            HttpResponseMessage response = Request.CreateResponse();
            response.StatusCode = HttpStatusCode.OK;
            response.Content = new StringContent(JsonConvert.SerializeObject(new { code = 200, data = list }), System.Text.Encoding.UTF8);
            return response;
        }
        #endregion
 
        #region [流水线看板列表展示数据]
        /// <summary>
        /// 流水线看板列表展示数据
        /// </summary>
        /// <param name="limit"></param>
        /// <param name="offset"></param>
        /// <returns></returns>
        [Route(template: "LineTableData")]
        [HttpGet]
        public HttpResponseMessage LineTableData(int limit,int offset)
        {
            int count = 0;
            int pageSize = limit;     //页码大小
            int pageNumber = offset;  //页码默认页码为0
            int startNum = pageSize * (pageNumber - 1) + 1;  //起始记录rowNum
            int endNum = pageSize * pageNumber;   //结束记录 rowNum 
 
            List<LineWork> list = new List<LineWork>();
            list = LoadDataBLL.LineTableData(LineCode,startNum, endNum, out count);
            Dictionary<object, object> dList = new Dictionary<object, object>();
            dList.Add("total", count);
            dList.Add("rows", list);
 
            //HttpResponseMessage response = Request.CreateResponse();
            //response.StatusCode = HttpStatusCode.OK;
            //response.Content = new StringContent(JsonConvert.SerializeObject(new { code = 200, data = dList }), System.Text.Encoding.UTF8);
            //return response;
 
            var timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd" };
            HttpResponseMessage response = Request.CreateResponse();
            response.StatusCode = HttpStatusCode.OK;
            response.Content = new StringContent(JsonConvert.SerializeObject(dList, Formatting.Indented, timeConverter));
            return response;
        }
        #endregion
 
        #region[仓库看板看板码表数据]
        [Route(template: "HouseTopData")]
        [HttpGet]
        public HttpResponseMessage HouseTopData()
        {
            DataTable dt = LoadDataBLL.HouseTopData(HouseCode);
            HttpResponseMessage response = Request.CreateResponse();
            response.StatusCode = HttpStatusCode.OK;
            response.Content = new StringContent(JsonConvert.SerializeObject(new { code = 200, data = dt }), System.Text.Encoding.UTF8);
            return response;
        }
        #endregion
 
        #region[仓库看板看板详情数据]
        [Route(template: "HouseDataTable")]
        [HttpGet]
        public HttpResponseMessage HouseDataTable()
        {
            DataTable dt = LoadDataBLL.HouseDataTable(HouseCode);
            HttpResponseMessage response = Request.CreateResponse();
            response.StatusCode = HttpStatusCode.OK;
            response.Content = new StringContent(JsonConvert.SerializeObject(new { code = 200, data = dt }), System.Text.Encoding.UTF8);
            return response;
        }
        #endregion
    }
}