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"];//仓库编码 /// /// 流水线看板图型展示数据 /// /// [Route(template: "LineData")] [HttpGet] #region[流水线看板图型展示数据] public HttpResponseMessage LineData() { List 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 [流水线看板列表展示数据] /// /// 流水线看板列表展示数据 /// /// /// /// [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 list = new List(); list = LoadDataBLL.LineTableData(LineCode,startNum, endNum, out count); Dictionary dList = new Dictionary(); 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 } }