private void ExportData()
{
string serverPath = null;
List <Staff> list = null;
try
{
Task <List <Staff> > loadStaff = LoadListAsync();
ProgressDialog.Start(ParentForm, Task.WhenAll(
loadStaff,
ServiceProxyFactory.LifeTime(async factory =>
{
var service = factory.Create <GeneralSettingMasterClient>();
GeneralSettingResult result = await service.GetByCodeAsync(SessionKey, CompanyId, "サーバパス");
if (result.ProcessResult.Result)
{
serverPath = result.GeneralSetting?.Value;
}
})), false, SessionKey);
list = loadStaff.Result;
if (!list.Any())
{
ShowWarningDialog(MsgWngNoExportData);
return;
}
if (!Directory.Exists(serverPath))
{
serverPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
}
var filePath = string.Empty;
var fileName = $"営業担当者マスター{DateTime.Today:yyyyMMdd}.csv";
if (!ShowSaveExportFileDialog(serverPath, fileName, out filePath))
{
return;
}
var definition = new StaffFileDefinition(new DataExpression(ApplicationControl));
var exporter = definition.CreateExporter();
exporter.UserId = Login.UserId;
exporter.UserCode = Login.UserCode;
exporter.CompanyId = CompanyId;
exporter.CompanyCode = Login.CompanyCode;
ProgressDialog.Start(ParentForm, (cancel, progress) =>
{
return(exporter.ExportAsync(filePath, list, cancel, progress));
}, true, SessionKey);
if (exporter.Exception != null)
{
NLogHandler.WriteErrorLog(this, exporter.Exception, SessionKey);
ShowWarningDialog(MsgErrExportError);
return;
}
DispStatusMessage(MsgInfFinishExport);
}
catch (Exception ex)
{
Debug.Fail(ex.ToString());
NLogHandler.WriteErrorLog(this, ex, SessionKey);
DispStatusMessage(MsgErrExportError);
}
}
private void Import()
{
ClearStatusMessage();
try
{
ImportSetting importSetting = null;
var task = Util.GetMasterImportSettingAsync(Login, ImportFileType.Staff);
ProgressDialog.Start(ParentForm, task, false, SessionKey);
importSetting = task.Result;
if (importSetting == null)
{
return;
}
var definition = new StaffFileDefinition(new DataExpression(ApplicationControl));
definition.MailField.Required = UseDistribution;
definition.DepartmentIdField.GetModelsByCode = val =>
{
Dictionary <string, Department> product = null;
ServiceProxyFactory.LifeTime(factory =>
{
var departmentMaster = factory.Create <DepartmentMasterClient>();
DepartmentsResult result = departmentMaster.GetByCode(SessionKey, CompanyId, val);
if (result.ProcessResult.Result)
{
product = result.Departments.ToDictionary(c => c.Code);
}
});
return(product ?? new Dictionary <string, Department>());
};
//その他
definition.StaffCodeField.ValidateAdditional = (val, param) =>
{
var reports = new List <WorkingReport>();
if (((ImportMethod)param) != ImportMethod.Replace)
{
return(reports);
}
var codes = val.Values.Where(x => !string.IsNullOrEmpty(x.Code)).Select(x => x.Code).Distinct().ToArray();
MasterDatasResult resultlogin = null;
ServiceProxyFactory.LifeTime(factory =>
{
var staffMaster = factory.Create <StaffMasterClient>();
resultlogin = staffMaster.GetImportItemsLoginUser(SessionKey, CompanyId, codes);
});
foreach (MasterData ca in resultlogin.MasterDatas.Where(p => !val.Any(a => a.Value.Code == p.Code)))
{
reports.Add(new WorkingReport
{
LineNo = null,
FieldNo = definition.StaffCodeField.FieldIndex,
FieldName = definition.StaffCodeField.FieldName,
Message = $"ログインユーザーマスターに存在する{ca.Code}：{ca.Name}が存在しないため、インポートできません。",
});
}
MasterDatasResult resultcustomer = null;
MasterDatasResult resultbilling = null;
ServiceProxyFactory.LifeTime(factory =>
{
var staffMaster = factory.Create <StaffMasterClient>();
resultcustomer = staffMaster.GetImportItemsCustomer(SessionKey, CompanyId, codes);
resultbilling = staffMaster.GetImportItemsBilling(SessionKey, CompanyId, codes);
});
foreach (MasterData ca in resultcustomer.MasterDatas.Where(p => !val.Any(a => a.Value.Code == p.Code)))
{
reports.Add(new WorkingReport
{
LineNo = null,
FieldNo = definition.StaffCodeField.FieldIndex,
FieldName = definition.StaffCodeField.FieldName,
Message = $"得意先マスターに存在する{ca.Code}：{ca.Name}が存在しないため、インポートできません。",
});
}
foreach (MasterData ca in resultbilling.MasterDatas.Where(p => !val.Any(a => a.Value.Code == p.Code)))
{
reports.Add(new WorkingReport
{
LineNo = null,
FieldNo = definition.StaffCodeField.FieldIndex,
FieldName = definition.StaffCodeField.FieldName,
Message = $"請求データに存在する{ca.Code}：{ca.Name}が存在しないため、インポートできません。",
});
}
return(reports);
};
var importer = definition.CreateImporter(m => m.Code);
importer.UserId = Login.UserId;
importer.UserCode = Login.UserCode;
importer.CompanyId = CompanyId;
importer.CompanyCode = Login.CompanyCode;
importer.LoadAsync = async() => await LoadListAsync();
importer.RegisterAsync = async unitOfWork => await RegisterForImportAsync(unitOfWork);
var importResult = DoImport(importer, importSetting, Clear);
if (!importResult)
{
return;
}
StaffProgress.Clear();
Task <List <Staff> > loadTask = LoadListAsync();
ProgressDialog.Start(ParentForm, loadTask, false, SessionKey);
StaffProgress.AddRange(loadTask.Result);
grdStaff.DataSource = new BindingSource(StaffProgress, null);
}
catch (Exception ex)
{
Debug.Fail(ex.ToString());
NLogHandler.WriteErrorLog(this, ex, SessionKey);
ShowWarningDialog(MsgErrImportErrorWithoutLog);
}
}
/// <summary>インポート処理</summary>
/// <param name="source"></param>
/// <param name="token"></param>
/// <returns></returns>
public async Task <ImportResult> ImportAsync(MasterImportSource source, CancellationToken token = default(CancellationToken))
{
var mode = (ImportMethod)source.ImportMethod;
var encoding = Encoding.GetEncoding(source.EncodingCodePage);
var csv = encoding.GetString(source.Data);
var companyTask = companyProcessor.GetAsync(new CompanySearch {
Id = source.CompanyId,
}, token);
var loginUsersTask = loginUserProcessor.GetAsync(new LoginUserSearch {
CompanyId = source.CompanyId,
}, token);
var appConTask = applicationControlProcessor.GetAsync(source.CompanyId, token);
var departmentTask = departmentProcessor.GetAsync(new DepartmentSearch {
CompanyId = source.CompanyId,
}, token);
var staffTask = staffProcessor.GetAsync(new StaffSearch {
CompanyId = source.CompanyId,
}, token);
await Task.WhenAll(companyTask, loginUsersTask, appConTask, departmentTask);
var company = companyTask.Result.First();
var loginUserDictionary = loginUsersTask.Result.ToDictionary(x => x.Code);
var loginUser = loginUsersTask.Result.First(x => x.Id == source.LoginUserId);
var appCon = appConTask.Result;
var departmentDictionary = departmentTask.Result.ToDictionary(x => x.Code);
var useDistribution = appCon.UseDistribution == 1;
var definition = new StaffFileDefinition(new DataExpression(appCon));
var parser = new CsvParser {
Encoding = encoding,
StreamCreator = new PlainTextMemoryStreamCreator(),
};
definition.MailField.Required = useDistribution;
definition.DepartmentIdField.GetModelsByCode = val => departmentDictionary;
var importer = definition.CreateImporter(x => x.Code, parser);
importer.UserId = source.LoginUserId;
importer.UserCode = loginUser.Code;
importer.CompanyId = source.CompanyId;
importer.CompanyCode = company.Code;
if (mode == ImportMethod.Replace)
{
importer.AdditionalWorker = async worker => {
var codes = worker.Models.Values.Select(x => x.Code).Distinct().ToArray();
var userTask = staffProcessor.GetImportItemsLoginUserAsync(source.CompanyId, codes, token);
var custTask = staffProcessor.GetImportItemsCustomerAsync(source.CompanyId, codes, token);
var billTask = staffProcessor.GetImportItemsBillingAsync(source.CompanyId, codes, token);
await Task.WhenAll(userTask, custTask, billTask);
var def = worker.RowDef as StaffFileDefinition;
def.StaffCodeField.ValidateAdditional = (val, param) => {
var reports = new List <WorkingReport>();
reports.AddRange(userTask.Result.Select(x => new WorkingReport {
FieldNo = def.StaffCodeField.FieldIndex,
FieldName = def.StaffNameField.FieldName,
Message = $"ログインユーザーマスターに存在する{x.Code}：{x.Name}が存在しないため、インポートできません。",
}));
reports.AddRange(custTask.Result.Select(x => new WorkingReport {
FieldNo = def.StaffCodeField.FieldIndex,
FieldName = def.StaffNameField.FieldName,
Message = $"得意先マスターに存在する{x.Code}：{x.Name}が存在しないため、インポートできません。",
}));
reports.AddRange(billTask.Result.Select(x => new WorkingReport {
FieldNo = def.StaffCodeField.FieldIndex,
FieldName = def.StaffNameField.FieldName,
Message = $"請求データに存在する{x.Code}：{x.Name}が存在しないため、インポートできません。",
}));
return(reports);
};
};
}
importer.LoadAsync = () => staffProcessor.GetAsync(new StaffSearch {
CompanyId = source.CompanyId,
}, token);
importer.RegisterAsync = x => staffProcessor.ImportAsync(x.New, x.Dirty, x.Removed, token);
var result = await importer.ImportAsync(csv, mode, token, null);
result.Logs = importer.GetErrorLogs();
return(result);
}
