摘要: IF DIALOG.getFieldTouched("customer.cust_address") THEN IF DIALOG.getFieldTouched("customer.*") THEN IF DIALOG.getFieldTouched("*") THEN 当传递一个简单的星号(*) 阅读全文
posted @ 2022-07-13 14:43 AaronLi 阅读(831) 评论(0) 推荐(0)
摘要: SELECT to_char(TRUNC(SYSDATE,'mm'),'yyyy/mm/dd') FROM dual;SELECT to_char(last_day(SYSDATE),'yyyy/mm/dd') FROM dual 阅读全文
posted @ 2022-03-04 13:44 AaronLi 阅读(2317) 评论(0) 推荐(0)
摘要: DEFINE l_format LIKE type_t.chr100 阅读全文
posted @ 2021-11-24 09:16 AaronLi 阅读(234) 评论(0) 推荐(0)
摘要: SELECT ROWNUM,bmbaent,bmbasite, connect_by_root(bmaa001) root, bmba002,bmaa001,bmba003, LEVEL level1, sys_connect_by_path(LEVEL,'∠') level2 FROM bmaa_ 阅读全文
posted @ 2021-08-25 15:16 AaronLi 阅读(145) 评论(0) 推荐(0)
摘要: SELECT to_date('2019-01-01\', 'yyyy-MM-dd\') + ROWNUM - 1 AS dateday FROM dual CONNECT BY ROWNUM <= (to_date('2021-08-24\', 'yyyy-MM-dd\') - to_date(' 阅读全文
posted @ 2021-08-23 15:39 AaronLi 阅读(757) 评论(0) 推荐(0)
摘要: 大概效果: 参考:https://echarts.apache.org/examples/zh/editor.html?c=pie-nest 前端: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="axmt630zc.aspx.cs 阅读全文
posted @ 2021-08-11 15:12 AaronLi 阅读(282) 评论(0) 推荐(0)
摘要: 效果: 官网:https://echarts.apache.org/zh/index.html 前端web: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Demo_1.aspx.cs" Inherits="WebApplicat 阅读全文
posted @ 2021-08-10 15:31 AaronLi 阅读(262) 评论(0) 推荐(0)
摘要: 效果图 前端web和axaj: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="zichanmx.aspx.cs" Inherits="xsweb.ERPInfo.zichanmx" %> <!DOCTYPE html> <html 阅读全文
posted @ 2021-07-28 11:52 AaronLi 阅读(187) 评论(0) 推荐(0)
摘要: <connectionStrings> <add name="oracle" connectionString="Data Source= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx 阅读全文
posted @ 2021-07-28 11:40 AaronLi 阅读(455) 评论(0) 推荐(0)
摘要: select dt,(Datepart(weekday,dt)-1) week from ( select convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from ma 阅读全文
posted @ 2021-07-28 11:32 AaronLi 阅读(125) 评论(0) 推荐(0)