private void button1_Click(object sender, EventArgs e) { T_UpdateTableAdapter adapter = new T_UpdateTableAdapter(); OpenFileDialog mDlg = new OpenFileDialog(); mDlg.InitialDirectory = AppDomain.CurrentDomain.BaseDirectory; if (mDlg.ShowDialog() == DialogResult.OK) { FileStream fs = new FileStream(mDlg.FileName, FileMode.Open); byte[] bFile = new byte[fs.Length]; fs.Read(bFile, 0, (int)fs.Length); adapter.Insert("销售管理", "1.1", "", DateTime.Now, bFile, ""); } }
private void btnUpload_Click(object sender, EventArgs e) { try { int count = 0; //把表格中的文件上传 T_UpdateTableAdapter adapter = new T_UpdateTableAdapter(); if (adapter.Connection.State == ConnectionState.Closed) { adapter.Connection.Open(); } //循环 foreach (DataRow mRow in mTable.Rows) { string fileName, fileUpPath, fileFullPath; fileName = mRow["文件名"].ToString(); fileUpPath = mRow["相对路径"].ToString(); fileFullPath = mRow["文件目录"].ToString(); // if (File.Exists(fileFullPath) == true) //检查文件是够存在 { string filePath = ""; //如果上传文件是本身,复制文件并上传 filePath = fileFullPath.Insert(fileFullPath.LastIndexOf('\\'), "\\upload"); if (Directory.Exists(filePath.Substring(0, filePath.LastIndexOf('\\'))) == false) { Directory.CreateDirectory(filePath.Substring(0, filePath.LastIndexOf('\\'))); } File.Copy(fileFullPath, filePath, true); using (FileStream fs = new FileStream(filePath, FileMode.Open)) //打开文件,将文件写入字节数组 { byte[] bFile = new byte[fs.Length]; fs.Read(bFile, 0, (int)fs.Length); adapter.Insert(fileName, txtVer.Text, fileUpPath, DateTime.Now, bFile, ""); fs.Close(); fs.Dispose(); count++; } } else { MessageBox.Show("文件不存在"); } } if (adapter.Connection.State == ConnectionState.Open) { adapter.Connection.Close(); } if (count > 0) { MessageBox.Show("文件上传成功"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }