智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
zrg
2025-02-28 7cce3c1dbda47d04067ab78a6eebcdbbca9ba246 
 WebAPI/Controllers/SCGL/Sc_PackUnionBillController.cs


@@ -78,24 +78,24 @@


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = count;


                    objJsonResult.Message = "返回记录成功！";


                    objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" }));  //序列化DataSet中的时间格式，然后再反序列化回来


                    objJsonResult.list = columnNameList;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "暂无记录！";


                    objJsonResult.data = null;


                    objJsonResult.list = columnNameList;


                    return objJsonResult;


                }


                //if (ds.Tables[0].Rows.Count > 0)


                //{


                objJsonResult.code = "1";


                objJsonResult.count = count;


                objJsonResult.Message = "返回记录成功！";


                objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" }));  //序列化DataSet中的时间格式，然后再反序列化回来


                objJsonResult.list = columnNameList;


                return objJsonResult;


                //}


                //else


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "暂无记录！";


                //    objJsonResult.data = null;


                //    objJsonResult.list = columnNameList;


                //    return objJsonResult;


                //}


            }


            catch (Exception ex)


            {


@@ -268,6 +268,7 @@


            try


            {


                ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain"+sWhere+ "order by hmainid desc", "h_v_Sc_StationInBillListMain");


               


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "返回记录成功！";


@@ -289,7 +290,7 @@


        #region 标准工时导出Excel表格数据


        [Route("Sc_PackUnionBill/Sc_StationInBillSetExcel")]


        [HttpGet]


        public HttpResponseMessage Sc_StationInBillSetExcel()


        public HttpResponseMessage Sc_StationInBillSetExcel(string sWhere)


        {


            HSSFWorkbook workbook = new HSSFWorkbook();


            ISheet sheet = workbook.CreateSheet("sheet1");


@@ -300,14 +301,15 @@


            row.CreateCell(1).SetCellValue("流转卡号");


            row.CreateCell(2).SetCellValue("进出站所用时间");


            row.CreateCell(3).SetCellValue("工时");


            row.CreateCell(4).SetCellValue("不良数量");


            row.CreateCell(5).SetCellValue("报废数量");


            row.CreateCell(6).SetCellValue("进站数量");


            row.CreateCell(7).SetCellValue("出站数量");


            row.CreateCell(8).SetCellValue("出站时间");


            row.CreateCell(9).SetCellValue("进站时间");


            row.CreateCell(10).SetCellValue("制单人");


            row.CreateCell(11).SetCellValue("制单日期");


            row.CreateCell(4).SetCellValue("工序名");


            row.CreateCell(5).SetCellValue("不良数量");


            row.CreateCell(6).SetCellValue("报废数量");


            row.CreateCell(7).SetCellValue("进站数量");


            row.CreateCell(8).SetCellValue("出站数量");


            row.CreateCell(9).SetCellValue("出站时间");


            row.CreateCell(10).SetCellValue("进站时间");


            row.CreateCell(11).SetCellValue("制单人");


            row.CreateCell(12).SetCellValue("制单日期");


            //精确控制列宽


            sheet.SetColumnWidth(1, 5000);


            sheet.SetColumnWidth(2, 5000);


@@ -319,8 +321,11 @@


            sheet.SetColumnWidth(8, 5000);


            sheet.SetColumnWidth(9, 5000);


            sheet.SetColumnWidth(10, 5000);


            sheet.SetColumnWidth(11, 5000);


            sheet.SetColumnWidth(12, 5000);


            sheet.SetColumnWidth(13, 5000);




            DataSet ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain order by hmainid desc", "h_v_Sc_StationInBillListMain");


            DataSet ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain" + sWhere + " order by hmainid desc", "h_v_Sc_StationInBillListMain");


            for (var i = 0; i < ds.Tables[0].Rows.Count; i++)


            {


                IRow row1 = sheet.CreateRow(i + 1);


@@ -328,14 +333,15 @@


                row1.CreateCell(1).SetCellValue(ds.Tables[0].Rows[i]["流转卡号"].ToString());


                row1.CreateCell(2).SetCellValue(ds.Tables[0].Rows[i]["进出站所用时间"].ToString());


                row1.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["工时"].ToString());


                row1.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["不良数量"].ToString());


                row1.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["报废数量"].ToString());


                row1.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["进站数量"].ToString());


                row1.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["出站数量"].ToString());


                row1.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["出站时间"].ToString());


                row1.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["进站时间"].ToString());


                row1.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["制单人"].ToString());


                row1.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["制单日期"].ToString());


                row1.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["工序名"].ToString());


                row1.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["不良数量"].ToString());


                row1.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["报废数量"].ToString());


                row1.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["进站数量"].ToString());


                row1.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["出站数量"].ToString());


                row1.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["出站时间"].ToString());


                row1.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["进站时间"].ToString());


                row1.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["制单人"].ToString());


                row1.CreateCell(12).SetCellValue(ds.Tables[0].Rows[i]["制单日期"].ToString());


            }


            System.IO.MemoryStream ms = new System.IO.MemoryStream();


            workbook.Write(ms);


@@ -345,7 +351,7 @@


            response.Content = new StreamContent(ms);




            response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");


            var fileName = "标准工时_.xls";


            var fileName = "标准工时.xls";




            response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")


            {