摘要:
function ExportExcel(tableid) { var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); sel.select(); ... 阅读全文
摘要:
DELIMITER $DROP PROCEDURE IF EXISTS sp_sUserLogin$CREATE PROCEDURE `sp_sUserLogin`(userid varchar(72))begin declare stmt varchar(2000); set @sqlstr=concat("SELECT UserID,UserFullNM from tbUser where CurrentUserFlg =1 and UserID='",userid,"'"); prepare stmt from @sqlstr; e 阅读全文