/// <summary>
/// 上传附件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnUpload_Click(object sender, EventArgs e)
{
Stream fileStream = null;
ITable pXMFJTable = null;
if (string.IsNullOrEmpty(txtProjectName.Text))
{
MessageManager.Show(MessageType.Warning, "项目不能为空!", "提示");
return;
}
if (!Directory.Exists(txtLJ.Text.Trim()))
{
MessageManager.Show(MessageType.Warning, "请选择路径!", "提示");
return;
}
strXMBH = txtProjectName.Text.Trim();
resultFile = txtLJ.Text;
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Multiselect = true;
openFileDialog1.InitialDirectory = "C:\\";
openFileDialog1.Filter = "All Files (*.*)|*.*|Image Files(*.jpg)|*.jpg|Excel Files (*.xls)|*.xls";
openFileDialog1.FilterIndex = 1;
openFileDialog1.RestoreDirectory = true;
if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if ((fileStream = openFileDialog1.OpenFile()) != null)
{
for (int fi = 0; fi < openFileDialog1.FileNames.Length; fi++)
{
ScanFile = openFileDialog1.FileNames[fi];
resultFileName = ScanFile.Substring(ScanFile.LastIndexOf('\\') + 1);
expandName = ScanFile.Substring(ScanFile.LastIndexOf('.') + 1);
File.Copy(ScanFile, txtLJ.Text.Trim() + "\\" + resultFileName, false);
strCFDZ = txtLJ.Text.Trim() + "\\" + resultFileName;
//将数据更新到SQLite数据库XMFJ表中
pXMFJTable = XYGlobalVariable.ZDBAdoWorkspace.OpenTable(XYTableDeclare.c_XMFJ_TableName);
RowBase pRowBase = new RowBase();
pRowBase.SetValue("OBJECTID", 1);
pRowBase.SetValue("XMBH", strXMBH);
pRowBase.SetValue("FJMC", resultFileName);
pRowBase.SetValue("FJLX", expandName);
pRowBase.SetValue("CFDZ", strCFDZ);
pXMFJTable.Save(pRowBase);
}
fileStream.Close();
}
}
DataTable pDtXMFJ = pXMFJTable.GetDataTable(null);
//添加复选框列
pDtXMFJ.Columns.Add("选择", System.Type.GetType("System.Boolean"));
pDtXMFJ.Columns["选择"].SetOrdinal(0);
this.gridControl1.DataSource = pDtXMFJ;
MessageManager.Show("上传完成!", "提示");
}
OpenFileDialog 多选上传附件
最新推荐文章于 2023-04-29 21:52:12 发布