private void btnUpLoad_Click(object sender, EventArgs e)
{
try
{
if (GeneralFunction.IsNullOrEmpty(txtFileName.Text))
{
throw new Exception("请填写【文件名】");
}
if (GeneralFunction.IsNullOrEmpty(cmbFileType.Text))
{
throw new Exception("请选择【文件类型】");
}
if (dtpFileDate.Value.Date > ServerTime.Time.Date)
{
throw new Exception("【文件日期】不能大于当前时间");
}
string strFilePath = "";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
foreach (string filePath in openFileDialog1.FileNames)
{
Guid guid = Guid.NewGuid();
FileOperationService.File_UpLoad(guid, filePath,
GeneralFunction.StringConvertToEnum <CE_CommunicationMode>(BasicInfo.BaseSwitchInfo[(int)CE_SwitchName.文件传输方式]));
strFilePath += guid.ToString() + ",";
}
btnUpLoad.Tag = strFilePath.Substring(0, strFilePath.Length - 1);
Bus_Gauge_Files fileInfo = new Bus_Gauge_Files();
fileInfo.F_Id = Guid.NewGuid().ToString();
fileInfo.FileDate = dtpFileDate.Value;
fileInfo.FileName = txtFileName.Text;
fileInfo.FilePath = btnUpLoad.Tag.ToString();
fileInfo.FileType = cmbFileType.Text;
fileInfo.GaugeCode = _GaugeCode;
_Service_Gauge.UpLoadFileInfo(fileInfo);
throw new Exception("上传成功");
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
finally
{
DataGridViewShow();
}
}
public void UpLoadFileInfo(Bus_Gauge_Files fileInfo)
{
using (DepotManagementDataContext ctx = CommentParameter.DepotDataContext)
{
try
{
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
var varData = from a in ctx.Bus_Gauge_Files
where a.FileName == fileInfo.FileName &&
a.GaugeCode == fileInfo.GaugeCode &&
a.FileType == fileInfo.FileType
select a;
if (varData.Count() > 0)
{
throw new Exception("【" + fileInfo.FileName + "】已存在，无法重复上传，如需重新上传，请先删除此【文件记录】");
}
fileInfo.F_Id = Guid.NewGuid().ToString();
fileInfo.F_CreateTime = ServerTime.Time;
fileInfo.F_CreateUser = BasicInfo.LoginID;
ctx.Bus_Gauge_Files.InsertOnSubmit(fileInfo);
ctx.SubmitChanges();
StatusChange(ctx, fileInfo.GaugeCode);
ctx.SubmitChanges();
ctx.Transaction.Commit();
}
catch (Exception)
{
throw;
}
}
}
