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"];//仓库看板仓库编码
|
string CallHouseCode = System.Configuration.ConfigurationManager.AppSettings["CallHouseCode"];//叫料看板仓库编码
|
/// <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
|
|
|
#region[叫料看板上列表数据]
|
[Route(template: "CallTableTopData")]
|
[HttpGet]
|
public HttpResponseMessage CallTableTopData(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<CallTopTable> list = new List<CallTopTable>();
|
list = LoadDataBLL.CallTableTopData(CallHouseCode,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: "CallTableBottomData")]
|
[HttpGet]
|
public HttpResponseMessage CallTableBottomData(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<CallBottomTable> list = new List<CallBottomTable>();
|
list = LoadDataBLL.CallTableBottomData(CallHouseCode,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[叫料看板图型展示数据]
|
public HttpResponseMessage CallData()
|
{
|
|
List<DataTable> list = LoadDataBLL.CallData(CallHouseCode);
|
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
|
|
|
/// <summary>
|
/// 地图看板数据
|
/// </summary>
|
/// <returns></returns>
|
[Route(template: "MapTableData")]
|
[HttpGet]
|
public HttpResponseMessage MapTableData()
|
{
|
|
List<DataTable> list = new List<DataTable>();
|
list = LoadDataBLL.MyMap();
|
var timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd" };
|
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;
|
}
|
}
|
}
|
