摘要：public int ExcuteCommand(string sql) { int result = -1; OleDbConnection myconn = getcon(); OleDbTransaction trans = myconn.BeginTransaction(IsolationLevel.ReadCommitted); try { OleDbCommand cmd = new OleDbCommand(sql, myconn); cmd.Transaction = trans; trans.Commit(); result = cmd.ExecuteNonQuery(); 阅读全文

摘要：//senfe("表格名称","奇数行背景","偶数行背景","鼠标经过背景","点击后背景","经过时字色","经过后字色",开始变色的行号);调用：senfe("table1", "#FFF", "#EEE", "#1B3243", "#074387", "#FFF", "#666", 2);function se 阅读全文

摘要：1:删除CREATE PROCEDURE Sp_deletedatabyCondition @tablename nvarchar(100), @condition nvarchar(200) ASBEGIN DECLARE @Sql nvarchar(500) SET @Sql='delete from '+@tablename+ ' where '+@condition EXEC(@Sql)ENDGO2：查询CREATE PROCEDURE SP_getColumnsByCondition @tablename nvarchar(100), @columns 阅读全文

摘要：/// <summary> /// 生成缩略图(最终图片固定大小,图片按比例缩小,并为缩略图加上边框,以jpg格式保存) /// </summary> /// <param name="sourceImg">原图片(物理路径)</param> /// <param name="toPath">缩略图存放地址(物理路径,带文件名)</param> /// <param name="width">缩略图宽度</param> /// <pa 阅读全文