D调dè小雨

最近项目出使用到了将word文档以二进制的方法存到数据库中，并再次读取出二进制数据转换为word文档。最后总结了一下，不多说看示例方法：

代码

        /// <summary>
        /// 二进制数据转换为word文件
        /// </summary>
        /// <param name="data">二进制数据</param>
        /// <param name="fileName">word文件名</param>
        /// <returns>word保存的相对路径</returns>
        public string ByteConvertWord(byte[] data, string fileName)
        {
            string savePath = @"\SystemWord\"+FormatNowTime(2)+@"\";

            if (!System.IO.Directory.Exists(GetPath() + savePath))
            {
                Directory.CreateDirectory(GetPath() + savePath);
            }
            savePath += fileName + ".doc";
            string filePath = GetPath() + savePath;

            FileStream fs;
            if (System.IO.File.Exists(filePath))
            {
                fs = new FileStream(filePath, FileMode.Truncate);
            }
            else
            {
                fs = new FileStream(filePath, FileMode.CreateNew);
            }
            BinaryWriter br = new BinaryWriter(fs);
            br.Write(data, 0, data.Length);
            br.Close();
            fs.Close();
            return savePath;
        }

        /// <summary>
        /// word文件转换二进制数据(用于保存数据库)
        /// </summary>
        /// <param name="wordPath">word文件路径</param>
        /// <returns>二进制</returns>
        private byte[] wordConvertByte(string wordPath)
        {
            byte[] bytContent = null;
            System.IO.FileStream fs = null;
            System.IO.BinaryReader br = null;
            try
            {
                fs = new FileStream(wordPath, System.IO.FileMode.Open);
            }
            catch
            {
            }
            br = new BinaryReader((Stream)fs);
            bytContent = br.ReadBytes((Int32)fs.Length);

            return bytContent;
        }

        /// <summary>
        /// 项目所在目录
        /// </summary>
        /// <returns></returns>
        public string GetPath()
        {
            return Application.StartupPath;
        }

        /// <summary>
        /// 格式化当前时间: 
        /// 1:yyMMddHHmmss; 2:yyyy-MM\dd\
        /// </summary>
        /// <returns></returns>
        public string FormatNowTime(int num)
        {
            if (num == 1)
            {
                return DateTime.Now.ToString("yyMMddHHmmss");
            }
            else if (num == 2)
            {
                return DateTime.Now.ToString("yyyy-MM") + @"\" + DateTime.Now.Day;
            }
            return "";
        }

//测试方法
 private void button1_Click(object sender, EventArgs e)
        {
            string newWord = ByteConvertWord(wordConvertByte(@"D:\测试文件.doc"), "测试成功");
        }

其他方法：来源CSDN：

http://topic.csdn.net/u/20100412/17/fbdeb7a1-412f-4533-93c1-1a2516c3738a.html?seed=38035402&r=64626024#r_64626024

    /// <summary>
    /// 字符串截取方法
    /// </summary>
    /// <param name="str">截取字符</param>
    /// <param name="len">大于Len时,截取len</param>
    /// <returns></returns>
    public string Substr(string str, int len)
    {
        if (!string.IsNullOrEmpty(str))
        {
            System.Text.RegularExpressions.Regex rChinese = new Regex(@"[\u4e00-\u9fa5]"); //验证中文
            Regex rEnglish = new Regex(@"^[A-Za-z0-9]+$");  //验证字母

            if (rChinese.IsMatch(str))
            {
                //中文
                return (str.Length > len) ? str.Substring(0, len) + "..." : str; 
            }
            else if (rEnglish.IsMatch(str))
            {
                //英文或数字
                return (str.Length > len * 2) ? str.Substring(0, len * 2) + "..." : str; 
            }

            return (str.Length > len) ? str.Substring(0, len) + "..." : str; 
        }
        return "";
    } 

1.使用CheckedListBox1.Items.Add循环方式
 
  赋值:
  foreach (DataRow dr in ds.Tables[0].Rows)
  {
     checkedListBox1.Items.Add(dr["Name"]);
  }
 
  选中索引：
  foreach (int indexChecked in checkedListBox1.CheckedIndices)
  {
      MessageBox.Show("Index#: " + indexChecked.ToString());             
  }

  选中值：
  foreach (object itemChecked in chk.CheckedItems)
  {
     MessageBox.Show("Item with title: " + itemChecked.ToString());
  }

2.使用DataSource方式

  赋值：
  CheckedListBox.DataSource = ds.Tables[0];
  CheckedListBox.DisplayMember = "Id";
  CheckedListBox.ValueMember = "Name";

  选中值：
  for (int count = 0; count < CheckedListBox1.CheckedItems.Count; count++)
  {
      string id = (CheckedListBox1.Items[CheckedListBox1.CheckedIndices[count]] as DataRowView)["Id"].ToString(); //获取ID
      string name = (CheckedListBox1.Items[CheckedListBox1.CheckedIndices[count]] as DataRowView)["Name"].ToString(); //获取名称
      MessageBox.Show("Id:" + id + " Name:" + name);
  }