Byte[] blob = null; FileStream fs = null; const string sConn = "server=(local);Initial Catalog=Northwind;UID=ctester;PWD=password"; try { SqlConnectio Read More
posted @ 2023-03-08 08:51 泉城余文乐 Views(73) Comments(0) Diggs(0) Edit
using System;using System.IO;using System.Text;using System.Web;using System.Data;using Register.DataAccess;using System.Configuration;using HrisInter Read More
posted @ 2023-03-08 08:49 泉城余文乐 Views(12) Comments(0) Diggs(0) Edit
查询所有进程 SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableNameFROM sys.dm_tran_locksWHERE resource_type='OBJECT' 杀死进程 kill Read More
posted @ 2022-04-24 14:58 泉城余文乐 Views(33) Comments(0) Diggs(0) Edit
<?xml version="1.0" encoding="utf-8"?><config> <emailconfig> <offerurl>http://10.29.132.83/HrisAssist/WebService/InstanceFlow3.asmx</offerurl> <csoffe Read More
posted @ 2022-01-20 15:33 泉城余文乐 Views(15) Comments(0) Diggs(0) Edit
var selfw = this;debugger;document.getElementById('GroupControlZPXX_ToolButton2').style.display ="none";var lcflag = selfw.getUrlParam('LCFlag');if (l Read More
posted @ 2021-10-05 15:31 泉城余文乐 Views(123) Comments(0) Diggs(0) Edit
declare v_Count1 int := 0; v_Count2 int := 0;begin select count(1) into v_Count1 from user_all_tables where Upper(Table_Name) = Upper('LSZGZD'); if(v_ Read More
posted @ 2021-08-31 10:16 泉城余文乐 Views(1210) Comments(0) Diggs(0) Edit
oracle declare num number;begin select count(1) into num from user_all_tables where Upper(Table_Name) = Upper('SPLJDJBPZ'); if num=1 then execute imme Read More
posted @ 2021-06-29 10:20 泉城余文乐 Views(76) Comments(0) Diggs(0) Edit
case 'ZJZH_SYDWMC': //使用单位 var editor = { "type": "adplookupbox", "options": { "required": false, "editable": true, "enableFavorite": true, "enableLoc Read More
posted @ 2021-05-10 10:33 泉城余文乐 Views(71) Comments(0) Diggs(0) Edit
本文解决的问题: VS显示“vs未找到导入XXX.vcxproj 项目,请确认 import 声明中的路径正确”。 找到 修改成非只读,打开后删除所有诸如这样的 Import 标签对 类似这样<Import Project=....... /> 重新打开 Read More
posted @ 2021-04-12 17:19 泉城余文乐 Views(1158) Comments(0) Diggs(0) Edit
declare v_Count1 int := 0; v_Count2 int := 0; v_Count3 int := 0; v_Count4 int := 0; v_Count5 int := 0; v_Count6 int := 0; begin select count(1) into v Read More
posted @ 2021-02-24 16:35 泉城余文乐 Views(132) Comments(0) Diggs(0) Edit