大鹏天空™

/* usage:
exec fk_switch tablename,0
delete tablename where fieldname = abc
-- truncate table tablename
exec fk_switch tablename,1
*/
create proc fk_switch @tablename varchar(20),@status bit
as
declare @fk varchar(50),@fktable varchar(20)
declare @s varchar(1000)
declare cur cursor for
select b.name as fkname,c.name as fktablename
from sysforeignkeys a
join sysobjects b on a.constid = b.id
join sysobjects c on a.fkeyid = c.id
join sysobjects d on a.rkeyid = d.id
where d.name = @tablename
open cur
fetch next from cur into @fk,@fktable
while @@fetch_status = 0
begin
if @status = 0
begin
  set @s = 'alter table +@fktable+ nocheck constraint + @fk'
  print @s
end
else
begin
  set @s = 'alter table +@fktable+ check constraint + @fk'
  print @s
end
exec(@s)
fetch next from cur into @fk,@fktable
end
close cur
deallocate cur

Usage:
     CharsetConverter source destination [-s] [-m match] [-o OriginalCharset] [-
t TargetCharset] [-h]
Options:
     source                     需要进行编码的文件所在位置，必需为文件夹路径
     destination                转换后的文件存放位置
     -s                         包含子文件夹下的文件
     -m match                   要进行转换的文件，过滤的表达式
     -o OriginalCharset         原文件字符集
     -t TargetCharset           目标字符集
     -h                         查看本工具使用说明
Examples:
CharsetConverter e:\website\MyOA d:\temp -s -m *.php -o gb2312 -t utf-8

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace 浏览dwg
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ViewDWG viewDwg = new ViewDWG();
            pictureBox1.Image = viewDwg.GetDwgImage("c:\\1.dwg");
        }
        class ViewDWG
        {
            struct BITMAPFILEHEADER
            {
                public short bfType;
                public int bfSize;
                public short bfReserved1;
                public short bfReserved2;
                public int bfOffBits;
            }
            public Image GetDwgImage(string FileName)
            {
                if (!(File.Exists(FileName)))
                {
                    throw new FileNotFoundException("文件没有被找到");
                }
                FileStream DwgF; //文件流
                int PosSentinel; //文件描述块的位置
                BinaryReader br; //读取二进制文件
                int TypePreview; //缩略图格式
                int PosBMP;       //缩略图位置
                int LenBMP;       //缩略图大小
                short biBitCount; //缩略图比特深度
                BITMAPFILEHEADER biH; //BMP文件头，DWG文件中不包含位图文件头，要自行加上去
                byte[] BMPInfo;       //包含在DWG文件中的BMP文件体
                MemoryStream BMPF = new MemoryStream(); //保存位图的内存文件流
                BinaryWriter bmpr = new BinaryWriter(BMPF); //写二进制文件类
                Image myImg = null;
                try
                {
                    DwgF = new FileStream(FileName, FileMode.Open, FileAccess.Read);   //文件流
                    br = new BinaryReader(DwgF);
                    DwgF.Seek(13, SeekOrigin.Begin); //从第十三字节开始读取
                    PosSentinel = br.ReadInt32(); //第13到17字节指示缩略图描述块的位置
                    DwgF.Seek(PosSentinel + 30, SeekOrigin.Begin); //将指针移到缩略图描述块的第31字节
                    TypePreview = br.ReadByte(); //第31字节为缩略图格式信息，2 为BMP格式，3为WMF格式
                    if (TypePreview == 1)
                    {
                    }
                    else if (TypePreview == 2 || TypePreview == 3)
                    {
                        PosBMP = br.ReadInt32(); //DWG文件保存的位图所在位置
                        LenBMP = br.ReadInt32(); //位图的大小
                        DwgF.Seek(PosBMP + 14, SeekOrigin.Begin); //移动指针到位图块
                        biBitCount = br.ReadInt16(); //读取比特深度
                        DwgF.Seek(PosBMP, SeekOrigin.Begin); //从位图块开始处读取全部位图内容备用
                        BMPInfo = br.ReadBytes(LenBMP); //不包含文件头的位图信息
                        br.Close();
                        DwgF.Close();
                        biH.bfType = 19778; //建立位图文件头
                        if (biBitCount < 9)
                        {
                            biH.bfSize = 54 + 4 * (int)(Math.Pow(2, biBitCount)) + LenBMP;
                        }
                        else
                        {
                            biH.bfSize = 54 + LenBMP;
                        }
                        biH.bfReserved1 = 0; //保留字节
                        biH.bfReserved2 = 0; //保留字节
                        biH.bfOffBits = 14 + 40 + 1024; //图像数据偏移
                        //以下开始写入位图文件头
                        bmpr.Write(biH.bfType); //文件类型
                        bmpr.Write(biH.bfSize); //文件大小
                        bmpr.Write(biH.bfReserved1); //0
                        bmpr.Write(biH.bfReserved2); //0
                        bmpr.Write(biH.bfOffBits); //图像数据偏移
                        bmpr.Write(BMPInfo); //写入位图
                        BMPF.Seek(0, SeekOrigin.Begin); //指针移到文件开始处
                        myImg = Image.FromStream(BMPF); //创建位图文件对象
                        bmpr.Close();
                        BMPF.Close();
                    }
                    return myImg;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
        }

    }
}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> frame </TITLE>
</HEAD>
<frameset rows="50%,50%">
<frame name=top src="top.html">
<frame name=bottom src="bottom.html">
</frameset>
</HTML>