摘要:
alter procedure Asset_spQueryAlertInfomation(@pi_Action VARCHAR(100),@pi_InfoId BIGINT,@pi_pageIndex INT,@pi_pageSize INT,@po_recordCount BIGINT OUTPUT)asDECLARE @pt_StartRowIndex INTDECLARE @pt_EndRowIndex INTSET @pt_StartRowIndex = (@pi_pageIndex - 1) * @pi_pageSize + 1SET @pt_EndRowIndex = @pi_pa 阅读全文
摘要:
--合同执行度(累计已审批/合同汇总金额)--投资进度(合同汇总总额/批准概算投资额)select a.*,cast(round((ljysp/( case when xmze=0 then 1 else xmze end))*100,2) as numeric(5,2)) as htzxd,cas... 阅读全文
摘要:
DECLARE @pt_retstatus INTDECLARE @pt_retvalue VARCHAR(200)execute App_System_spMakeExecuteInfo 'TrainErp_Financial_DailyRB',@pt_retstatus output,@pt_r... 阅读全文
摘要:
1. 新建一个存储过程-- =============================================-- Author: -- Create date: -- Description: -- =============================================... 阅读全文
摘要:
checkEqual(id1, id2, msg) //验证二个值是否相等checkIsQQ (id,msg) //验证QQcheckPassWord id,msg) //验证密码checkIsQQ (id,msg) //验证QQcheckMemberCode(id,msg) //验证会员号chec... 阅读全文
摘要:
页面直接通过查询语句取值方法// DataTable页面查询语句取值方法DataTable dtTable = DbService.Instance().QueryDataTable("select * from TrainErp_Product_LevelAfter where ProductCo... 阅读全文
摘要:
1.Jquery页面拼接字符串方法//开始做字符的合并 var mLevelHtmlInfo = ""; var levelCodes = $("#LevelCodes").val().split(','); if (levelCodes.length > 0) { for (var i = 0; ... 阅读全文
摘要:
主从表或者关联分类表存在下级使用上级数据的,不可删除判断条件if exists (select * from TrainErp_Product_ProductTopic where ProductLevelInfoCode in (select ProductLevelInfoCode from ... 阅读全文
摘要:
页面获取自动生成编号方法 List parpams = new List(); parpams.Add(new DataParam("Code", "KT")); parpams.Add(new DataParam("Count", "1")); DbService.Instance().Execu... 阅读全文
摘要:
1. --课件自动编号 declare @pt_OtherCateCode varchar(50) exec App_s_spGetSequenceNumber 'KJ',1,@pt_OtherCateCode output,0 2./*Func:获得自动编号CreateDate:20140829C... 阅读全文
摘要:
1.--定义Md5加密declare @pt_pwd varchar(50)set @pt_pwd = ''set @pt_pwd = substring(sys.fn_sqlvarbasetostr(HashBytes('MD5',@pi_Password)),3,32) 阅读全文