public async Task ShouldUploadFilesCommandThrowsMaximumSizeExceedsExceptionWhenUnsupportedImageUploaded()
{
// Arrange
var uploadDate = new DateTime(2021, 5, 6);
var fileSizeSetting = new UploadSetting(UploadSettingKeys.MaxAllowedSingleFileSizeInBytes, "1");
var uploadSettings = new List <UploadSetting> {
fileSizeSetting
};
var simpleFiles = new List <SimpleFile>();
var filesDbSet = TestHelpers.CreateMockDbSet(simpleFiles);
var uploadSettingsDbSet = TestHelpers.CreateMockDbSet(uploadSettings);
var dbContextMock = new Mock <IApplicationDbContext>();
dbContextMock.Setup(x => x.SimpleFiles).Returns(filesDbSet);
dbContextMock.Setup(x => x.UploadSettings).Returns(uploadSettingsDbSet);
var handler =
new UploadFilesCommandHandler(dbContextMock.Object, TestHelpers.CreateDateTimeProvider(uploadDate));
var query = new UploadFilesCommand
{
Files = new List <UploadFileDto>
{
new("", "", new byte[5])
}
};
//Act
//Assert
await Should.ThrowAsync <MaximumSizeExceedsException>(handler.Handle(query, CancellationToken.None));
}
internal void PageLoad(object sender, RoutedEventArgs e)
{
View = (UploadSettingEditView)sender;
if (View.MD != null)
{
//View = (FuncModuleUpdateView)sender;
View.Title = "修改";
View.TitleImg.Source = new BitmapImage(new Uri("pack://siteoforigin:,,,/image/modify.png"));
md = View.MD;//页面传参
View.txtID.Text = md.ID.ToString();
View.txtCode.Text = md.Code.ToString();
View.txtName.Text = md.RuleName;
View.txtRemark.Text = md.Remark;
View.txtFormat.Text = md.Format;
LoadcmbEnable();
View.cmbEnable.SelectedValue = md.EnableStatus;
LoadcmbTransType();
View.cmbTransType.SelectedValue = md.DataTranferTypeID;
}
else
{
View.Title = "添加";
View.TitleImg.Source = new BitmapImage(new Uri("pack://siteoforigin:,,,/image/add.png"));
//View.txtgnbh.Focus();
}
}
public MaintainManager(ILoggerFactory loggerFactory, CloudSpeedManager cloudSpeedManager, UploadSetting uploadSetting, IConfiguration configuration)
{
_logger = loggerFactory.CreateLogger <MaintainManager>();
_cloudSpeedManager = cloudSpeedManager;
_uploadSetting = uploadSetting;
_configuration = configuration;
}
public CloudSpeedManager(ILogger <CloudSpeedManager> logger,
IPanPasswordHasher panPasswordHasher, UploadSetting uploadSetting, LotusClient lotusClient)
{
_logger = logger;
_panPasswordHasher = panPasswordHasher;
_uploadSetting = uploadSetting;
_lotusClient = lotusClient;
}
public LotusWorker(ILogger <LotusWorker> logger, CloudSpeedManager cloudSpeedManager, LotusClientSetting lotusClientSetting, UploadSetting uploadSetting, DealerService dealerService)
{
_logger = logger;
_cloudSpeedManager = cloudSpeedManager;
_lotusClientSetting = lotusClientSetting;
_uploadSetting = uploadSetting;
_dealerService = dealerService;
}
public UploadManager(ILoggerFactory loggerFactory,
CloudSpeedManager cloudSpeedManager, UploadSetting uploadSetting, IConfiguration configuration,
UserManager <Member> memberManager)
{
_logger = loggerFactory.CreateLogger <UploadManager>();
_cloudSpeedManager = cloudSpeedManager;
_uploadSetting = uploadSetting;
_configuration = configuration;
_memberManager = memberManager;
}
public IActionResult SaveUploadSettings([FromBody] UploadSettingModel model)
{
if (ModelState.IsValid)
{
UploadSetting entity = new UploadSetting();
model.CopyTo(entity);
return(_settingService.Save(entity).SaveResult(T));
}
return(SaveFailure(GetModelErrors()));
}
/// <summary>
/// 数据保存前判别各项录入数据的有效性
/// </summary>
/// <returns></returns>
private bool InputValidity(UploadSetting model)
{
bool bValid = true;
var code = View.txtCode.Text.Trim();
if (string.IsNullOrEmpty(code))
{
MessageBox.Show("代码不能为空！");
View.txtID.Focus();
return(false);
}
else
{
if (model == null)
{
if (new SystemModuleBIZ().SelectExist(" where Code =" + code))
{
MessageBox.Show("代码已存在，请重新输入！");
View.txtCode.Focus();
return(false);
}
}
}
if (string.IsNullOrEmpty(View.txtName.Text))
{
MessageBox.Show("请输入名称！");
View.txtName.Focus();
return(false);
}
if (string.IsNullOrEmpty(View.txtFormat.Text))
{
MessageBox.Show("请填写格式！");
View.txtFormat.Focus();
return(false);
}
if (string.IsNullOrEmpty(View.cmbEnable.Text))
{
MessageBox.Show("请选择可用状态！");
View.cmbEnable.Focus();
return(false);
}
if (string.IsNullOrEmpty(View.cmbTransType.Text))
{
MessageBox.Show("请选择传输类型！");
View.cmbTransType.Focus();
return(false);
}
return(bValid);
}
/// <summary>
/// 删除记录
/// </summary>
private void BtnDelete_Click(object sender)
{
if (View.DGSelect.SelectedItem == null)
{
MessageBox.Show("请选择要删除的功能模块！");
}
foreach (var item in View.DGSelect.Items)
{
if (View.DGSelect.SelectedItem == item)
{
UploadSetting model = item as UploadSetting;
new UploadSettingBIZ().delete(model);
MessageBox.Show("删除成功！");
BtnSearch_Click(null);
}
}
}
/// <summary>
/// 修改记录
/// </summary>
private void BtnUpdate_Click(object sender)
{
if (View.DGSelect.SelectedItem == null)
{
MessageBox.Show("请选择要修改的记录！");
}
foreach (var item in View.DGSelect.Items)
{
if (View.DGSelect.SelectedItem == item)
{
UploadSetting model = item as UploadSetting;
//FuncModule gnmk = (FuncModule)sender;
UploadSettingEditView view = new UploadSettingEditView(model);
view.ShowDialog();
BtnSearch_Click(null);
}
}
}
private void ItemInfoDialog_Load(object sender, EventArgs e)
{
uploadSetting = UploadHelperClient.GetUploadSettingByModuleID(moduleID);
if (uploadSetting != null && uploadSetting.Items != null)
{
SheetView2.Rows.Count = uploadSetting.Items.Count;
tb_rootName.Text = uploadSetting.Name;
for (int i = 0; i < uploadSetting.Items.Count; i++)
{
SheetView2.Rows[i].Tag = uploadSetting.Items[i].NeedSetting;
SheetView2.Cells[i, 0].Value = uploadSetting.Items[i].Description;
SheetView2.Cells[i, 0].Tag = uploadSetting.Items[i].Name;
SheetView2.Cells[i, 1].Value = uploadSetting.Items[i].CellName;
SheetView2.Cells[i, 1].Tag = uploadSetting.Items[i].SheetID;
}
}
}
public static async Task SeedDefaultUploadSettings(IApplicationDbContext applicationDbContext)
{
if (!await applicationDbContext.UploadSettings.AnyAsync(x =>
x.Key == UploadSettingKeys.AllowedContentTypes))
{
var allowedContentTypes =
new UploadSetting(UploadSettingKeys.AllowedContentTypes, "image/png,image/jpeg");
await applicationDbContext.UploadSettings.AddAsync(allowedContentTypes);
}
if (!await applicationDbContext.UploadSettings.AnyAsync(x =>
x.Key == UploadSettingKeys.MaxAllowedSingleFileSizeInBytes))
{
const int maxSizeInKb = 20 * 1024; // 20 KB
var allowedMaxSingleFileSizeInBytes =
new UploadSetting(UploadSettingKeys.MaxAllowedSingleFileSizeInBytes, maxSizeInKb.ToString());
await applicationDbContext.UploadSettings.AddAsync(allowedMaxSingleFileSizeInBytes);
}
await applicationDbContext.SaveChangesAsync(CancellationToken.None);
}
public async Task ShouldListUploadSettingsQueryReturnsSettings()
{
// Arrange
var setting1 = new UploadSetting(UploadSettingKeys.AllowedContentTypes, "content1");
var setting2 = new UploadSetting(UploadSettingKeys.MaxAllowedSingleFileSizeInBytes, "content2");
var uploadSettings = new List<UploadSetting> {setting1, setting2};
var dbSet = TestHelpers.CreateMockDbSet(uploadSettings);
var dbContextMock = new Mock<IApplicationDbContext>();
dbContextMock.Setup(x => x.UploadSettings).Returns(dbSet);
var handler = new ListUploadSettingsQueryHandler(dbContextMock.Object);
var query = new ListUploadSettingsQuery();
// Act
var result = await handler.Handle(query, CancellationToken.None);
// Assert
result.ShouldNotBeNull();
result.Count.ShouldBe(2);
}
public async Task ShouldUploadFilesCommandSuccessWhenMultipleValidImageGiven()
{
// Arrange
var uploadDate = new DateTime(2021, 5, 6);
var mediaTypeSetting = new UploadSetting(UploadSettingKeys.AllowedContentTypes, "image/jpeg,image/png");
var fileSizeSetting = new UploadSetting(UploadSettingKeys.MaxAllowedSingleFileSizeInBytes, "5");
var uploadSettings = new List <UploadSetting> {
mediaTypeSetting, fileSizeSetting
};
var simpleFiles = new List <SimpleFile>();
var filesDbSet = TestHelpers.CreateMockDbSet(simpleFiles);
var uploadSettingsDbSet = TestHelpers.CreateMockDbSet(uploadSettings);
var dbContextMock = new Mock <IApplicationDbContext>();
dbContextMock.Setup(x => x.SimpleFiles).Returns(filesDbSet);
dbContextMock.Setup(x => x.UploadSettings).Returns(uploadSettingsDbSet);
var handler =
new UploadFilesCommandHandler(dbContextMock.Object, TestHelpers.CreateDateTimeProvider(uploadDate));
var query = new UploadFilesCommand
{
Files = new List <UploadFileDto>
{
new("", "image/jpeg", new byte[5]),
new("", "image/png", new byte[3]),
new("", "image/jpeg", new byte[1])
}
};
// Act
await handler.Handle(query, CancellationToken.None);
// Assert
dbContextMock.Verify(x => x.SimpleFiles.AddAsync(It.IsAny <SimpleFile>(), It.IsAny <CancellationToken>()),
Times.Exactly(query.Files.Count));
filesDbSet.Count().ShouldBe(query.Files.Count);
}
//保存
private void BtnSave_Click()
{
bool success = false;
try
{
if (!InputValidity(md))
{
return; //验证失败
}
var model = new UploadSetting();
model.Code = int.Parse(View.txtCode.Text);
model.RuleName = View.txtName.Text.Trim();
model.Remark = View.txtRemark.Text;
model.Format = View.txtFormat.Text;
model.EnableStatus = int.Parse(View.cmbEnable.SelectedValue.ToString());
model.DataTranferTypeID = View.cmbTransType.SelectedValue.ToString();
if (md != null)
{
model.ID = int.Parse(View.txtID.Text); //修改需要ID的值
}
if (new UploadSettingBIZ().Insert(model) > 0)
{
MessageBox.Show("保存成功!");
View.Close();
}
else
{
MessageBox.Show("保存失败!");
}
}
catch (Exception ex)
{
MessageBox.Show("保存失败!原因是：" + ex.Message);
UIHelper.WriteLog(ex.Message);
}
}
public int InsertOrUpdateBy(UploadSetting _model, string _identity)
{
return(_model.ID == 0 ? dal.Insert(_model) : dal.Update(_model, _identity));
}
public int Insert(UploadSetting model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public UploadSettingEditView(UploadSetting md)
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(UploadSettingEditVM.PageLoad);
MD = md;
}
public int delete(UploadSetting _model)
{
return(dal.Delete(_model));
}
public bool CreatMultiXMLFile(UploadSetting set, String path, DataRow[] drArr, String trCode)
{
if (File.Exists(path))
{
try
{
File.Delete(path);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml("<?xml version=\"1.0\" encoding=\"gb2312\"?><ROOT></ROOT>");
if (set.Items != null)
{
foreach (DataRow dr in drArr)
{
XmlElement root = xmldoc.CreateElement(set.Name);
xmldoc.DocumentElement.AppendChild(root);
JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dr["Data"].ToString());
XmlElement ele = null;
foreach (var item in set.Items)
{
ele = xmldoc.CreateElement(item.Name);
String value = "";
if (item.NeedSetting)
{
Object obj = JZCommonHelper.GetCellValue(doc, item.SheetID, item.CellName);
if (obj != null)
{
value = obj.ToString();
}
}
else
{
switch (item.Name)
{
case "F_TRCODE": //试验室编号
value = trCode;
break;
default:
break;
}
}
ele.InnerText = value;
root.AppendChild(ele);
}
}
}
try
{
xmldoc.Save(path);
return(true);
}
catch (Exception e)
{
logger.Error(e.Message);
return(false);
}
}
public UploadController(ILogger <UploadController> logger, UploadSetting uploadSetting, CloudSpeedManager CloudSpeedManager)
{
_logger = logger;
_uploadSetting = uploadSetting;
_CloudSpeedManager = CloudSpeedManager;
}
/// <summary>
///上传试验室综合情况
/// </summary>
public void UploadTestRoomInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode)
{
try
{
Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap);
String moduleID = "E77624E9-5654-4185-9A29-8229AAFDD68B"; //试验室综合情况
String ksign = "01"; //01表示试验室
UploadSetting set = GetUploadSettingByModuleID(moduleID);
if (set != null)
{
String sql = "SELECT TestRoomCode,Data FROM dbo.sys_document WHERE ModuleID='" + moduleID + "' AND Status>0";
DataTable dt = GetDataTable(sql);
List <String> files = new List <string>();
if (dt != null && dt.Rows.Count > 0)
{
String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验室基本属性");
DeleteDirAllFile(path);
if (!Directory.Exists(path))
{
try
{
Directory.CreateDirectory(path);
}
catch (Exception ee)
{
logger.Error(ee.Message);
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
String testRoomCode = dt.Rows[i]["TestRoomCode"].ToString();
if (testRoomCodeMap.ContainsKey(testRoomCode))
{
testRoomCode = testRoomCodeMap[testRoomCode].ToString();
}
JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dt.Rows[i]["Data"].ToString());
String fileName = Path.Combine(path, testRoomCode + ".xml");
if (CreatXMLFile(set, fileName, doc, testRoomCode))
{
files.Add(fileName);
}
doc = null;
Thread.Sleep(3000);
}
if (files.Count > 0)
{
String zipFile = Path.Combine(path, "试验室基本属性.zip");
if (File.Exists(zipFile))
{
try
{
File.Delete(zipFile);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
if (JZCommonHelper.CreateZipFile(files, zipFile))
{
FileStream stream = null;
stream = new FileInfo(zipFile).OpenRead();
Byte[] buffer = new Byte[stream.Length];
stream.Read(buffer, 0, Convert.ToInt32(stream.Length));
stream.Close();
String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode);
if (result == "1")
{
logger.Error("试验室综合情况数据上传成功");
}
else
{
logger.Error("试验室综合情况数据上传失败，返回值为：" + result);
}
}
}
}
else
{
logger.Error("未找到试验室综合情况信息");
}
}
else
{
logger.Error("未找到该模板对应的上传设置");
}
}
catch (Exception ex)
{
logger.Error("UploadTestRoomInfo error:" + ex.ToString());
}
}
/// <summary>
/// 上传试验数据
/// </summary>
public void UploadTestDataInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode)
{
try
{
Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap);
// String sql = @"SELECT top 100 ID,TestRoomCode,Data,WillUploadCount,ModuleID,BGBH,CreatedTime FROM dbo.sys_document WHERE
// ModuleID NOT IN ('E77624E9-5654-4185-9A29-8229AAFDD68B','08899BA2-CC88-403E-9182-3EF73F5FB0CE',
// 'BA23C25D-7C79-4CB3-A0DC-ACFA6C285295') AND Status>0 AND NeedUpload=1 and BGBH is not null and BGBH<>'' ORDER BY CreatedTime ";//排除人员、设备、试验室
String sql = @"SELECT top 100 ID FROM dbo.sys_document WHERE
ModuleID NOT IN ('E77624E9-5654-4185-9A29-8229AAFDD68B','08899BA2-CC88-403E-9182-3EF73F5FB0CE',
'BA23C25D-7C79-4CB3-A0DC-ACFA6C285295') AND Status>0 AND NeedUpload=1 and BGBH is not null and BGBH<>'' ORDER BY CreatedTime ";//排除人员、设备、试验室
DataTable dtIDs = GetDataTable(sql);
ModuleHelper mh = new ModuleHelper();
DocumentHelper dh = new DocumentHelper();
if (dtIDs != null && dtIDs.Rows.Count > 0)
{
String ksign = "05";//05表示试验数据
List <String> files = new List <String>();
#region 创建目录
String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验数据");
DeleteDirAllFile(path);
if (!Directory.Exists(path))
{
try
{
Directory.CreateDirectory(path);
}
catch (Exception ee)
{
logger.Error(ee.Message);
}
}
#endregion
#region 回收应用程序池
//string strRealPath = System.Web.Hosting.HostingEnvironment.MapPath("~");
//logger.Error("strRealPath:" + strRealPath);
//strRealPath = strRealPath.Substring(0, strRealPath.Length - 1);
//int LastIndex = strRealPath.LastIndexOf('\\');
//string AppPoolName = strRealPath.Substring(LastIndex + 1, strRealPath.Length - LastIndex - 1);
//logger.Error("AppPoolName:" + AppPoolName);
//string method = "Recycle";
//try
//{
// DirectoryEntry appPool = new DirectoryEntry("IIS://localhost/W3SVC/AppPools");
// DirectoryEntry findPool = appPool.Children.Find(AppPoolName, "IIsApplicationPool");
// findPool.Invoke(method, null);
// appPool.CommitChanges();
// appPool.Close();
// logger.Error("应用程序池名称回收成功");
//}
//catch (Exception ex)
//{
// logger.Error("回收失败:" + ex.Message);
//}
#endregion
StringBuilder strIDs = new StringBuilder();
UploadSetting[] usArr = new UploadSetting[dtIDs.Rows.Count];
DataRow[] docRowArr = new DataRow[dtIDs.Rows.Count];
int[] wucArr = new int[dtIDs.Rows.Count];//WillUploadCount
#region 创建资料列表
for (int i = 0; i < dtIDs.Rows.Count; i++)
{
string strID = dtIDs.Rows[i]["ID"].ToString();
string strSQL = "SELECT ID,TestRoomCode,Data,WillUploadCount,ModuleID,BGBH,CreatedTime FROM dbo.sys_document where ID='" + strID + "'";
DataTable dt = GetDataTable(strSQL);
String testRoomCode = dt.Rows[0]["TestRoomCode"].ToString();
string strModuleID = dt.Rows[0]["ModuleID"].ToString();
string strBGBH = dt.Rows[0]["BGBH"].ToString();
string docDateDir = DateTime.Parse(dt.Rows[0]["CreatedTime"].ToString()).ToString("yyyy/MM/dd");
int WillUploadCount = int.Parse(dt.Rows[0]["WillUploadCount"].ToString());
strIDs.AppendFormat("'{0}'", strID);
if (i < dt.Rows.Count - 1)
{
strIDs.Append(",");
}
Sys_Module module = mh.GetModuleBaseInfoByID(new Guid(strModuleID));
UploadSetting set = module.UploadSetting;
if (set != null)
{
if (testRoomCodeMap.ContainsKey(testRoomCode))
{
testRoomCode = testRoomCodeMap[testRoomCode].ToString();
}
string strSourceFile = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), string.Format("source/{0}/{1}.pdf", docDateDir, strID));
string strDestFile = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), string.Format("Temp/TestDataUpload/试验数据/{0}_{1}.pdf", testRoomCode, strBGBH));
if (!File.Exists(strSourceFile))
{
//logger.Error(string.Format("{1} ID:{0}不存在，生成文件开始", strID, i));
#region 生成PDF和图片
JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject <JZDocument>(dt.Rows[0]["Data"].ToString());
FpSpread fpSpread = new FpSpread();
//int rIndex = 0;
//foreach (JZSheet sheet in doc.Sheets)
//{
//if (rIndex == module.ReportIndex)
//{
String sheetXML = JZCommonHelper.GZipDecompressString(mh.GetSheetXMLByID(doc.Sheets[module.ReportIndex].ID));// mh.GetSheetXMLByID(sheet.ID);
SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView;
SheetView.Tag = doc.Sheets[module.ReportIndex].ID;
SheetView.Cells[0, 0].Value = "";
SheetView.Protect = true;
foreach (JZCell dataCell in doc.Sheets[module.ReportIndex].Cells)
{
Cell cell = SheetView.Cells[dataCell.Name];
if (cell != null)
{
cell.Value = dataCell.Value;
}
}
fpSpread.Sheets.Add(SheetView);
//}
//else
//{
// //fpSpread.Sheets.Add(null);
//}
//sheetXML = null;
//SheetView = null;
// rIndex++;
//}
//自动生成Excel，图片和报告页的pdf
SourceHelper sourceHelper = new SourceHelper();
sourceHelper.CreateRalationFilesSync(fpSpread, doc.ID, module.ReportIndex, docDateDir);
fpSpread.Dispose();
doc = null;
#endregion
logger.Error(string.Format("{1} ID:{0}不存在，生成文件成功", strID, i));
//Thread.Sleep(10000);
}
else
{
logger.Error(string.Format("{1} ID:{0}存在，不需要生成文件", strID, i));
}
File.Copy(strSourceFile, strDestFile, true);
files.Add(strDestFile);
usArr[i] = set;
docRowArr[i] = dt.Rows[0];
wucArr[i] = WillUploadCount;
//JZDocument doc = Newtonsoft.Json.JsonConvert.DeserializeObject<JZDocument>(dt.Rows[i]["Data"].ToString());
//String fileName = Path.Combine(path, dt.Rows[i]["ID"].ToString() + ".xml");
//if (CreatXMLFile(set, fileName, doc, testRoomCode))
//{
// files.Add(fileName);
//}
}
else
{
usArr[i] = null;
docRowArr[i] = dt.Rows[0];
wucArr[i] = WillUploadCount;
logger.Error("未找到该模板对应的上传设置,资料ID:" + strID);
}
}
#endregion
//logger.Error("reportInfo 0");
String fileName = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验数据/reportInfo.xml");
//生成reportInfo.xml
CreatReportInfoXMLFile(usArr, fileName, docRowArr, jsdwCode, wucArr);
//logger.Error("reportInfo 1");
files.Add(fileName);
#region 资料
if (files.Count > 0)
{
String zipFile = Path.Combine(path, "试验报告.zip");
if (File.Exists(zipFile))
{
try
{
File.Delete(zipFile);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
if (JZCommonHelper.CreateZipFile(files, zipFile))
{
FileStream stream = null;
stream = new FileInfo(zipFile).OpenRead();
Byte[] buffer = new Byte[stream.Length];
stream.Read(buffer, 0, Convert.ToInt32(stream.Length));
stream.Close();
String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode);
if (result == "1")
{
logger.Error("试验报告上传成功");
if (strIDs.Length > 0)
{
dh.UpdateDocumentNeedUpload(strIDs.ToString());
}
}
else
{
logger.Error("试验报告上传失败，返回值为：" + result);
}
}
}
#endregion
}
else
{
logger.Info("未找到试验数据信息");
}
}
catch (Exception ex)
{
logger.Error("UploadTestDataInfo error:" + ex.ToString());
}
}
public DealerService(ILogger <DealerService> logger, CloudSpeedManager cloudSpeedManager, UploadSetting uploadSetting)
{
_logger = logger;
_cloudSpeedManager = cloudSpeedManager;
_uploadSetting = uploadSetting;
}
/// <summary>
/// 上传人员信息
/// </summary>
public void UploadPersonInfo(string strTestRoomCodeMap, String uploadAddress, String jsdwCode)
{
try
{
Hashtable testRoomCodeMap = InitTestRoomCodeMap(strTestRoomCodeMap);
String moduleID = "08899BA2-CC88-403E-9182-3EF73F5FB0CE"; //试验人员
String ksign = "02"; //02表示试验人员
UploadSetting set = GetUploadSettingByModuleID(moduleID);
if (set != null)
{
String sql = "SELECT ID,TestRoomCode,Data FROM dbo.sys_document WHERE ModuleID='" + moduleID + "' AND Status>0";
DataTable dt = GetDataTable(sql);
List <String> files = new List <String>();
if (dt != null && dt.Rows.Count > 0)
{
String path = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~"), "Temp/TestDataUpload/试验室人员");
DeleteDirAllFile(path);
if (!Directory.Exists(path))
{
try
{
Directory.CreateDirectory(path);
}
catch (Exception ee)
{
logger.Error(ee.Message);
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
String testRoomCode = dt.Rows[i]["TestRoomCode"].ToString();
DataRow[] drArr = dt.Select(string.Format("TestRoomCode='{0}'", testRoomCode));
if (testRoomCodeMap.ContainsKey(testRoomCode))
{
testRoomCode = testRoomCodeMap[testRoomCode].ToString();
}
String fileName = Path.Combine(path, testRoomCode + ".xml");
if (CreatMultiXMLFile(set, fileName, drArr, testRoomCode))
{
files.Add(fileName);
ProcessPersonPhoto(drArr, files, path);
foreach (DataRow row in drArr)
{
dt.Rows.Remove(row);
}
}
drArr = null;
Thread.Sleep(3000);
}
if (files.Count > 0)
{
String zipFile = Path.Combine(path, "试验室人员.zip");
if (File.Exists(zipFile))
{
try
{
File.Delete(zipFile);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
if (JZCommonHelper.CreateZipFile(files, zipFile))
{
FileStream stream = null;
stream = new FileInfo(zipFile).OpenRead();
Byte[] buffer = new Byte[stream.Length];
stream.Read(buffer, 0, Convert.ToInt32(stream.Length));
stream.Close();
String result = UploadToServer(uploadAddress, buffer, ksign, jsdwCode);
if (result == "1")
{
logger.Error("试验室人员上传成功");
}
else
{
logger.Error("试验室人员上传失败，返回值为：" + result);
}
}
}
}
else
{
logger.Error("未找到试验人员信息");
}
}
else
{
logger.Error("未找到该模板对应的上传设置");
}
}
catch (Exception ex)
{
logger.Error("UploadPersonInfo error:" + ex.ToString());
}
}
public PowergateWorker(ILogger <PowergateWorker> logger, CloudSpeedManager cloudSpeedManager, UploadSetting uploadSetting)
{
_logger = logger;
_cloudSpeedManager = cloudSpeedManager;
_uploadSetting = uploadSetting;
}
public FilPanManager(IPanPasswordHasher panPasswordHasher, UploadSetting uploadSetting)
{
_panPasswordHasher = panPasswordHasher;
_uploadSetting = uploadSetting;
}
public int Delete(UploadSetting model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Update(UploadSetting model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public UploadsManager(UploadSetting uploadSetting, UserManager <Member> memberManager)
{
_uploadSetting = uploadSetting;
_memberManager = memberManager;
}
