梦醒心晴

点击 添加引用添加完成后 在项目中using Word = Microsoft.Office.Interop.Word;using Excel = Microsoft.Office.Interop.Excel; Read More

using Word = Microsoft.Office.Interop.Word;using Excel = Microsoft.Office.Interop.Excel;/// <summary> /// 将一个word中的内容拷贝到另外一个word中的表格中 /// 前提是目标word中有一个表格 /// </summary> /// <param name="source">源文件</param> /// <param name="target">目标文件</param> Read More

usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Drawing;usingSystem.Windows.Forms;usingSystem.IO;namespace CodeEncoder{ public class WordHelp { private Microsoft.Office.Interop.Word.ApplicationClass oWordApplic; // a reference to Word application priva... Read More

/// <summary> /// 将一个word文档中的所有文本存放到excel的指定单元格内 /// using Excel = Microsoft.Office.Interop.Excel; /// using Word = Microsoft.Office.Interop.Word; /// </summary> /// <param name="wordPath">word文档的路径</param> /// <param name="excelPath">excel文档的路径</ Read More

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Configuration;using System.Data.SqlClient;using System.Data;using System.Collections;namespace XXX{ public class DbHelper { private readonly string connString = ConfigurationManager.ConnectionS... Read More

主要有两个方法/// <summary> /// 从源DOC文档复制内容返回一个Document类 /// </summary> /// <param name="sorceDocPath">源DOC文档路径</param> /// <returns>Document</returns> protected Document copyWordDoc(object sorceDocPath) { object objDocType = WdDocumentType.wdTypeDocumen... Read More

IF OBJECT_ID ('dbo.VW_Article') IS NOT NULL DROP VIEW dbo.VW_ArticleGOCREATE VIEW VW_ArticleASSELECT a.id, a.accountid, a.title, a.content, b.name, c.displayname, a.soul, a.istop, a.readtimes, a.keywordsFROM tong_blog_article a LEFT JOIN tong_article_catego... Read More

ueditor的部署 Read More

ALTER PROCEDURE [AddInfor]@ID int OUTPUT,@classid INT,@checkurl NVARCHAR(50),@headmanpwd NVARCHAR(50),@supervisorpwd NVARCHAR(50),@testpaperurl NVARCHAR(50),@wrongtimes INTASBEGIN SET NOCOUNT ON DECLARE @Err int INSERT INTO TB_TestpaperDownload ( ClassID, CheckUrl, HeadmanPassword, SupervisorPas... Read More

ALTER PROCEDURE Addwrongtimes@ID INT,@count INT OUTASBEGINSET @count = (SELECT wrongtimes FROM TB_TestpaperDownload WHERE ID=@ID)SET @count = @count+1UPDATE TB_TestpaperDownload SET WrongTimes=@count WHERE ID=@IDEND GO Read More