摘要:
--这是查找菜单 第一行是一级菜单,下面是二级菜单 with temp as ( select MenuCode,ParentCode,MenuName,URL,1 as curMenuLevel from sys_menu where (ParentCode is null or ParentCode = '') and MenuCode='pms' un... 阅读全文
摘要:
declare @Storage int, @EdsProd intdeclare My_cursor cursor scroll for select distinct Storage,EdsProd from InmInventory open My_cursor fetch next from My_cursor into @Storage,@EdsProd while(@@fetch... 阅读全文
摘要:
//放到 扩展datagrid 的js中 $.extend($.fn.datagrid.methods, { addEditor: function (jq, param) { if (param instanceof Array) { $.each(param, function (index, i... 阅读全文
摘要:
//放到easyui 对应的扩展datagrid 的js中 $.extend($.fn.datagrid.defaults.editors, { combogrid: { init: function (container, options) { var input = $('').appendTo(... 阅读全文
摘要:
阅读全文
摘要:
CREATE FUNCTION [dbo].[F_StringSplit]( @STR NVARCHAR(MAX)='', @SPLITER NVARCHAR(20)='' ) RETURNS @TB TABLE(TB_V NVARCHAR(200) AS BEGIN DECLARE @NUM IN 阅读全文