/// <summary> /// 导入word文档 /// </summary> /// <param name="tpj_name"></param> private void ImportWordFile(string tpj_name) { OpenFileDialog op = new OpenFileDialog(); op.RestoreDirectory = true; op.Filter = "Word(*.doc)|*.doc"; bool?b = op.ShowDialog(); StringBuilder sqlStr = new StringBuilder(); if (b == true) { MessageBoxResult result = MessageBox.Show("确定导入?", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { byte[] file = wordConvertByte(op.FileName); sqlStr.Append("select * from PC_XTPJ_REPORT where MC = '" + tpj_name + "'"); bool isExist = DbHelperOleDb.ExecuteReader(sqlStr.ToString()).HasRows; sqlStr.Clear(); if (isExist) { sqlStr.Append("Delete from PC_XTPJ_REPORT where MC = '" + tpj_name + "'"); DbHelperOleDb.ExecuteSql(sqlStr.ToString()); sqlStr.Clear(); } sqlStr.Append("INSERT INTO PC_XTPJ_REPORT (MC,XNBG) VALUES ('" + tpj_name + "',@XNBG)"); DbHelperOleDb.ExecuteSqlInsertImg(sqlStr.ToString(), file); MessageBox.Show("导入成功!"); } else { return; } } }