当前位置: 首页 > Web前端 > JavaScript

解决JSON数据中日期值的格式化

时间:2023-03-26 20:35:56 JavaScript

在设计ActiveReportsJS报表时,往往会设置时间类型。比如短时间、长时间、短日期、长日期等。由于时间类型在json中是以字符串的形式存储的,那么在设计报表的时候需要使用Format函数设置时间的时候,只是需要先将字符串转换成时间类型,然后再设置时间格式。下面不多说,直接上手演示1.首先进行时间转换,将Json中存储的字符串类型数据转换为时间类型\使用“DateTime.Parse()”转换时间类型DateTime.Parse([,])2.打开报表设计器,将数据源数据集绑定到数据源:\OrderDate表示时间`[{"OrderID":10248,"CustomerId":"VINET","CompanyName":"ShantaiEnterprise","OrderDate":"1996/01/3110:00:00","Freight":32.38,"ProductID":42,"ProductPr"ice"Name":"BrownRice"“,:9.8,“量化”:10,“折扣”:0,“金额”:98,“discountAmt”:0,“netamount”:98},{“orderid”:10248:10248,“customerid”:“vinet”:“vinet”,"CompanyName":"山泰企业","OrderDate":"1996/10/3107:00:00","Freight":32.38,"ProductID":72,"Productr"UnitP"iceName":"yogurt",:34.8,"Quantity":5,"Discount":0,"Amount":174,"DiscountAmt”:0,"Netamount":174},{"Orderid":10248,"Customerid":"VINET","CompanyName":"山泰企业","OrderDate":"1996/10/3100:00:00:00”,“FREIGHT”:32.38,“Productid”:17,“Productname”:“Pork”,“UnitPrice”:14,“Quantity”:12,“Discount”:0,“amount”:168,“Discountamt”:"0,"Netamount":168},{"Orderid":10249,"CUSTORID":"Tomsp","CompanyName":"DongdiWang","OrderDate":"1996/07/0500:00:00“,“货运”:11.61,“productid”:14,“productname”:“the沙茶”,“unitprice”:18.6,“数量”:9,“折扣”:0,“金额”:167.4,“discountAmt”:0,"NetAmount":167.4}]`3.数据源数据集绑定后,将相应的字段绑定到表单上4.转换时间类型{DateTime.Parse(OrderDate,"YYYY/MM/DDHH:米m:ss")}5.设置Format格式6.预览结果