摘要: var datatr = " <tr>"; datatr += "<td bgcolor='#EEEEEE'><input class='inputxt' ignore='ignore' type='checkbox' style='width: 20px'></td>"; datatr += "< 阅读全文
posted @ 2017-07-27 16:36 许佳挺 阅读(185) 评论(0) 推荐(0) 编辑
摘要: var dataobj = eval("("+data+")"); 阅读全文
posted @ 2017-07-27 11:32 许佳挺 阅读(142) 评论(0) 推荐(0) 编辑
摘要: <!DOCTYPE html> <html> <head> <meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> <meta http-equiv="Content-Type" content="text/htm 阅读全文
posted @ 2017-07-18 08:30 许佳挺 阅读(211) 评论(0) 推荐(0) 编辑
摘要: <!DOCTYPE html> <html> <head> <meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> <meta http-equiv="Content-Type" content="text/htm 阅读全文
posted @ 2017-07-17 16:48 许佳挺 阅读(393) 评论(0) 推荐(0) 编辑
摘要: CREATE DEFINER=`wpsuper`@`%` TRIGGER `o2oinsert` BEFORE INSERT ON `t_s_o2o`FOR EACH ROW begin set New.fbianhao=(select fprojectval from t_billCodeRule 阅读全文
posted @ 2017-07-14 16:55 许佳挺 阅读(3003) 评论(0) 推荐(0) 编辑
摘要: DECLARE @fitemid intdeclare @fdcstockid intdeclare @fqty decimal(18,10)declare @fbatchno varchar(50)DECLARE #point_cursor CURSORFORselect fitemid,FDCS 阅读全文
posted @ 2017-05-10 16:32 许佳挺 阅读(305) 评论(0) 推荐(0) 编辑
摘要: select * from ICStockbill where fbillno='JIN002104' exec [xp_ICStockbill_29] 1862,3483,2000,250,'16421','JIN002104' select * from icstockbill where FB 阅读全文
posted @ 2017-05-09 16:13 许佳挺 阅读(443) 评论(0) 推荐(0) 编辑
摘要: delete from TRANSACTION1delete from khcountdelete from emscountdelete from odd_catch1delete from kehumoneydelete from odd_number 阅读全文
posted @ 2017-04-28 09:31 许佳挺 阅读(156) 评论(0) 推荐(0) 编辑
摘要: select sum(FQty) from ICInventory where FItemID=''SELEct FSupplyID,* from ICSubContract where FBillNo='LG2016102011'SELECT FQtyScrap , fitemid ,FAuxSt 阅读全文
posted @ 2017-04-24 17:25 许佳挺 阅读(149) 评论(0) 推荐(0) 编辑
摘要: select sum(FQty) from ICInventory where FItemID=''SELEct FSupplyID,* from ICSubContract where FBillNo='LGSC20170098'SELECT FQtyScrap , fitemid FROM PP 阅读全文
posted @ 2017-04-16 17:43 许佳挺 阅读(153) 评论(-1) 推荐(0) 编辑