03 2021 档案
摘要:HTML页面: <div class=" row t1" style="text-align:center;"> <div class="form-group col-xs-2 col-md-offset-1"> <div class="panel panel-danger" style="back
阅读全文
摘要:两个系统共用一张表,系统A和系统B数据类型有两种:20:回寄中30:已签收,系统A插入:10,系统B插入:20, 查询表中字段TransOrderID唯一且OrderBackType=10,Status=30的数据数量 表:orderbackdetail sql语句: SELECT COUNT(1)
阅读全文
摘要:setTimeout() 方法用于在指定的毫秒数后调用函数或计算表达式。 <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>setTimeout</title> </head> <body> <p>点击按钮,3 秒后会弹出 "He
阅读全文
摘要:ajax请求添加数据 1 $.ajax({ 2 type: "post", 3 url: that._reqUrl.getSave, 4 data: dataObj, 5 dataType: "json", 6 async: false,//是否异步,true:异步,false:同步 7 succe
阅读全文
摘要:对获取的数据进行封装 public PDA_ResponseBase_DTO_OP<List<PDA_PickPacage_LO_OP>> GetPackageVali(PDA_PickPacage_DTO_IP model) { PDA_ResponseBase_DTO_OP<List<PDA_P
阅读全文
摘要://初始赋值 var date = new Date().format("yyyy-MM-01"); var date1 = new Date().format("yyyy-MM-dd"); that._doms.createDate.val(date + " 00:00:00 ~ " + date
阅读全文
摘要://初始化表格 function initTable() { var baseConfig = { uniqueId: "MemberID" //指定主键列 , sortName: "CreateDate" //默认排序列 , sortOrder: "desc" , method: "post" ,
阅读全文
摘要:1 //$可以使参数sortVolumesq融入到sql语句中 3 var sql = $@"SELECT 4 t.`MemberID`,t2.`MemberName`,SUM(t1.`Volumn`)AS TotalVolume,COUNT(t.`MemberID`)AS TotalOrder 5
阅读全文
摘要:SELECT COUNT(*)AS AddOrder, IFNULL(SUM(m.OrderReceived), 0) AS OrderReceived, IFNULL(SUM(m.WaitingDelivery), 0)AS WaitingDelivery, IFNULL(SUM(m.PlanDe
阅读全文
摘要://定义显示的数据 var _datas = { chart4: { xAxisData: [], series: { data1: [] } } }; //模型折线图 var chart4 = echarts.init(document.getElementById('pie2')); funct
阅读全文
摘要:1 //定义显示的数据 2 3 var _datas = { 4 chart1: { 5 xAxisData: [], 6 series: { 7 data1: [], 8 data2: [] 9 } 10 } 11 }; 12 13 14 15 //模型柱状图 16 var chart1 = ec
阅读全文
摘要:为表添加新的字段: ALTER TABLE `tt_tms_orderback` ADD (`BackType` INT(2) NOT NULL DEFAULT '1' COMMENT '1按扫描2按时间', `DateRange` VARCHAR(50) DEFAULT NULL COMMENT
阅读全文