优化

王 垚

2022-09-06 ef207546d2ccc247f2af1aa74118ee9442655bbc

 MyWebApi/Controllers/LoadDataController.cs

@@ -24,6 +24,8 @@
    {
        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>
@@ -78,5 +80,162 @@
            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: "EquipMentData")]
        [HttpGet]
        public HttpResponseMessage EquipMentData(string CallHouseCode, int limit, int offset)
        {
            List<CallTopTable> list = new List<CallTopTable>();
            list = LoadDataBLL.EquipMentData();
            Dictionary<object, object> dList = new Dictionary<object, object>();
            dList.Add("total", 1);
            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


        //public static List<CallTopTable> EquipMentData()
        //{
        //    //执行存储过程@lineCodeList
        //    // 存储过程名称
        //    string strProcName = "select 20 as HICMOBillNO , '60%' as HNUMBER ,12 as HNAME, 4 HMODEL ,2 as HQTY ,1 as HLEFT  ,1 as HSTATUS";
        //    //创建参数
        //    //parameters[0].Direction = ParameterDirection.Output;
        //    DataTable dt = DBHelper.GetTable(strProcName);
        //    if (dt != null && dt.Rows.Count > 0)
        //    {
        //        return dt.AsEnumerable().Select(t => new CallTopTable(t)).ToList();
        //    }
        //    return new List<CallTopTable>();
        //}


        #region[叫料看板上列表数据]
        [Route(template: "CallTableTopData")]
        [HttpGet]
        public HttpResponseMessage CallTableTopData(string CallHouseCode, 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;
        }
    }
}