摘要:
merge into t_product tp using(select t.IMAA017,t.IMAA001 from t100_product_weight t ) s on(tp.PROD_CODE = s.IMAA001) when matched then update set tp.weight = s.IMAA017; 阅读全文
摘要:
UPDATE ( SELECT w.FORM_NO,wp.CF02,wp.LINE_ITEM_NO,wp.STATUS FROM T_WAREHOUS_PRICE w , T_WAREHOUS_PRICE_DTL wp WHERE w.ID = wp.REF_KEY AND wp.IS_DO_PRICE = '是' AND w.SEND_CODE IN (SELECT DISTINCT SEND_ 阅读全文
摘要:
$(function(){ //清空浏览器历史记录 pushHistory(); //监听浏览器后退事件 window.addEventListener("popstate", function(e) { //转向指定的URL location.href=url; }, false); //清空浏览器历史记录 function pushHistory()... 阅读全文
摘要:
function newLinebydraw(){ if ($("input[name='cskIds2']:checked").length JavaType jt = mapper.getTypeFactory().constructParametricType(ArrayList.class, MroRecover.class); List list = ... 阅读全文
摘要:
/** * 从网络Url中下载文件 * @param urlStr * @param fileName * @param savePath * @throws IOException */ public static void downLoadFromUrl(String urlStr,String fileName,Stri... 阅读全文
摘要:
//循环遍历 ,获取每行值对比 $("#linedata2 tr").each(function(i,n){ var mappingProjectCode = $("mappingProjectCode",this).val(); if(mappingProjectCode == null || mappingProjectCode == ''){ must+="... 阅读全文
该文被密码保护。 阅读全文
摘要:
public class DateTest { public static void main(String[] args) { Date date = new Date(); // 新建一个日期 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // 格式化日期 String beforeDate = sd... 阅读全文
摘要:
$("#table tr:gt(0)").each(function(i){ var bidPrice = $("input[name='bidPrice2s']",this).val();//订单数量 if(bidPrice != ''){ flag = true; } }); 阅读全文
摘要:
UPDATE T_ASN_DTL ad1 SET ad1.cf03=( SELECT ac.TH003 FROM "T_ASN_DTL_copy" ac WHERE ac.udf06=ad1.INSPECTER_NAME and ac.udf05=ad1.LINE_ITEM_NO ) WHERE EXISTS (SELECT 1 FROM "T_ASN_DTL_copy" ac WH... 阅读全文