摘要:
function GetRequest() { var url = location.search; //获取url中"?"符后的字串 var theRequest = new Object(); if (url.indexOf("?") != -1) { var str = url.substr( 阅读全文
摘要:
通过一次导出功能是让自己如何一步一步掉坑最后又是怎么爬起来的 在页面中通过document.createElement('a');创建一个a标签,然后给a标签的href属性赋url,通过代码触发a标签的click事件请求后台,在Chrome浏览器中请求正常,但是在Firefox中始终无效,debug 阅读全文
摘要:
Create PROCEDURE [dbo].[P_SYSTEM_FindData] ( @value VARCHAR(1024) ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering 阅读全文
摘要:
删除所有的视图 use fkbmvcultimate GO declare @sql varchar(8000) while (select count(*) from sysobjects where type='V')>0 begin SELECT @sql='drop view ' + nam 阅读全文
摘要:
游标实例 DECLARE @LegalUnitID as varchar(100), @ViewID as varchar(100) declare my_cursor cursor for select LegalUnitID,ViewID from T_TEMPLATE_VIEW group b 阅读全文
摘要:
新增字段IsCheckInvoice Alter table T_LegalUnit add IsCheckInvoice bit UPDATE T_LegalUniT SET IsCheckInvoice=1 WHERE LegalUnitID='000010' SELECT *FROM T_Le 阅读全文
摘要:
http://www.cnblogs.com/qcq0703/p/9099199.html select * from user select * from user where 1=1 --这两个 句子执行结果是一样一样的。而sql注入就是利用了这个原理 来进行破坏。比如: select * fr 阅读全文
摘要:
SELECT STATIC_ID,STATIC_CD,STATIC_VALUE,STATIC_VALUE_EN from [dbo].[T_COMMON_STATIC] where TYPE_CD='ItemClass' and COMPANY_GUID='000018' and R_RECORD_ 阅读全文
摘要:
EF 执行存储过程方法: SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Detail_Item_ID",model.DETAIL_ITEM_ID), SqlParameter("@Detail_Item_ID1",mod 阅读全文
摘要:
SELECT DISTINCT BizID ,STUFF( ( SELECT ',' + ApproveName FROM T_Common_ApproveNode WHERE BizID = A.BizID FOR XML PATH('') ) ,1 ,1 ,'' ) AS ApproveName 阅读全文
摘要:
declare @strReturn varchar(max) exec Proc_Fosun_Pay_Tran2WaitPayment 874302,15,@strReturn OUTPUT select @strReturn declare @BillID varchar(max) declar 阅读全文
摘要:
select db_name(st.dbid) as database_name, object_name(st.objectid) as name, p.size_in_bytes / 1024 as size_in_kb, p.usecounts, st.text from sys.dm_exe 阅读全文
摘要:
public void LoadJson() { using (StreamReader r = new StreamReader("file.json")) { string json = r.ReadToEnd(); List<Item> items = JsonConvert.Deserial 阅读全文
摘要:
stockInfo.Code = str[0].Substring(str[0].IndexOf("_str_"), str[0].IndexOf("=") - str[0].IndexOf("_str_")).Replace("_str_","");//股票编码 --去掉最后一个字符串 appen 阅读全文
摘要:
string strTripID = string.Join(",", model.TripList.Select(s => "'" + s.TripID + "'")); var togetherList = itogetheremployeeservice.GetTogetherEmployee 阅读全文
摘要:
///从List分组后从重组织数据 var res = result.GroupBy(s => new { s.LegalUnitID, s.TYPE_CD, s.TYPE_NAME, s.TYPE_NAME_EN, s.BILLTYPE, s.BasicColor }).ToList(); for 阅读全文
摘要:
public DateTime? _InvoiceDate { get { return InvoiceDate == default(DateTime) ? null : new DateTime?(InvoiceDate); } set { if (value.HasValue) { if (I 阅读全文