#region 浏览文件
private void btnViewFile_Click(object sender, EventArgs e)
{
#region
StringBuilder filter = new StringBuilder();//限制上传文件的格式
filter.Append("(*.jpg,*.png,*.bmp,*.doc,*.docx,*.xls,*.xlsx,*.txt,*.zip,*.rar,*.pdf)|");
filter.Append("*.jpg;*.png;*.bmp;*.doc;*.docx;*.xls;*.xlsx;*.txt;*.zip;*.rar;*.pdf");
OpenFileDialog openFile = new OpenFileDialog();
openFile.Filter = filter.ToString();// "*.jpg|*.jpg|*.png|*.png|*.bmp|*.bmp|*.doc|*.doc|*.docx|*.docx|*.xls|*.xls|*.xlsx|*.xlsx|*.zip|*.zip|*.rar|*.rar|*.pdf|*.pdf|*.txt|*.txt|";//限制上传文件的格式
openFile.ShowDialog();
string fileName = openFile.FileName;
if (fileName.Equals("") || !System.IO.File.Exists(fileName))
{
return;
}
FileInfo finfo = new FileInfo(fileName);
if (finfo.Length >= 1000000000)
{
MessageBox.Show("文件太大!系统加载失败!", "系统提示", MessageBoxButtons.OK);
return;
}
txtUploadFile.Text = fileName;
#endregion
}
#endregion
#region 上传附件
private void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (this.txtUploadFile.Text.Trim().Length <= 0)
{
MessageUtil.ShowError("请选择文件!");
return;
}
string filePath = @"" + this.txtUploadFile.Text.Trim();
FileInfo fileInfo = new FileInfo(filePath);
if (!fileInfo.Exists)
{
MessageUtil.ShowError("文件不存在!");
return;
}
if (fileInfo.Length / 1000 >= 1000000)
{
MessageBox.Show("文件太大!系统加载失败!", "系统提示", MessageBoxButtons.OK);
return;
}
controlState(false);
//判断是否存在文件夹
//truck-车辆;driver-司机;returnBill-回单;jobOrder-作业;contract-协议;taskOrder-任务单
string serverPathURL1 = string.Format("{0}/{1} ", g_ftpServerIp, g_attachFile.OrderType);
string serverPathURL2 = string.Format("{0}/{1} ", serverPathURL1.Trim(), DateTime.Now.ToString("yyyy"));
string serverPathURL3 = string.Format("{0}/{1} ", serverPathURL2.Trim(), DateTime.Now.ToString("MM"));
UpMakeDirectory(serverPathURL1.Trim() + "/", g_ftpUserName, g_ftpPwd);
UpMakeDirectory(serverPathURL2.Trim() + "/", g_ftpUserName, g_ftpPwd);
UpMakeDirectory(serverPathURL3.Trim() + "/", g_ftpUserName, g_ftpPwd);
string fileName = DateTime.Now.ToString("yyyyMMddHHmmssffff") + "_" + filePath.Substring(filePath.LastIndexOf(@"\") + 1);
#region 先在数据库插入附件记录
AttachFile attachLocal = new AttachFile();
attachLocal.OrderType = g_attachFile.OrderType;
attachLocal.OrderNo = g_attachFile.OrderNo;
attachLocal.AttachName = fileName;
attachLocal.Remark = this.txtRemark.Text.Trim();
attachLocal.AttachSize = int.Parse((fileInfo.Length / 1000).ToString());
attachLocal.RelativePath = serverPathURL3;
bool isSuccesAdd = g_serviceUpload.AddAttachment(attachLocal);
#endregion
if (isSuccesAdd)
{
isSuccesAdd = UploadFile(serverPathURL3.Trim(), filePath, fileName, g_ftpUserName, g_ftpPwd);
if (isSuccesAdd)
{
MessageUtil.ShowTips("上传成功!");
BindData();
this.txtUploadFile.Text = "";
this.txtRemark.Text = "";
showCountAtButton(null);
}
else
{
//上传不成功,删除数据库