public SettingForm(InputFormData <object> iData)
{
InitializeComponent();
SettingFile = iData.SettingFile;
Data = SettingDataCommand.LoadFile(SettingFile);
SettingLoad();
}
private void SummaryCollection(object sender, EventArgs e)
{
btnSummaryCollection.BackColor = Color.BurlyWood;
Cursor preCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Library.AllCtrlSwInForm(this, false);
IsDoing = true;
try
{
SummaryRequestParam reqParam = new SummaryRequestParam();
reqParam.ModelID = ModelID;
bool isPredict = false;
Dictionary <string, string> xTypeDict = Library.MakeStringDict(lstXtypeJp, lstXtypeEn);
for (int r = 0; r < dgvCollection.Rows.Count; r++)
{
string key = (string)dgvCollection[2, r].Value;
xTypeDict.TryGetValue((string)dgvCollection[3, r].Value, out string val);
reqParam.ParamDict.Add(key, val);
if ((bool)dgvCollection[0, r].Value)
{
reqParam.Yname = key;
isPredict = true;
}
}
reqParam.Purpose = Purpose;
reqParam.IgnoreCheckY = 0;
InputFormData <SummaryRequestParam> iData = new InputFormData <SummaryRequestParam>
{
SettingFile = SettingFile,
RequestParam = reqParam
};
SummaryResultData data = SummaryCommand.Collection(iData);
if (data.MsgType != 0)
{
return;
}
string tempPath = AppDomain.CurrentDomain.BaseDirectory;
FileInfo tempFile = new FileInfo(Path.Combine(tempPath, "Templates", "SummaryReport.xlsx"));
MsgBox.MsgBoxShowInfo(String.Format("サマリ詳細出力が完了しました。\r\n出力先:{0}", tbSelectOutFolder.Text));
}
catch (Exception ex)
{
MsgBox.MsgBoxShowErr(ex.Message);
}
finally
{
Library.AllCtrlSwInForm(this, true);
Cursor.Current = preCursor;
btnSummaryCollection.BackColor = Color.Empty;
IsDoing = false;
}
}
public ModelCreateEntranceForm(InputFormData <UploadRequestParam> iData)
{
InitializeComponent();
cbPurpose.SelectedIndex = 0;
SettingFile = iData.SettingFile;
BookPath = iData.BookPath;
ModelID = iData.RequestParam.ModelID;
ModelIdFile = iData.ModelIdFile;
}
private void OpenCreateForm(object sender, RibbonControlEventArgs e)
{
if (!ExeCheck())
{
return;
}
try
{
if (menuForm == null || menuForm.IsDisposed)
{
Cursor preCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Reload();
Dictionary <object, object> titleDict = null;
if (selectedRange.ListObject == null)
{
titleDict = XlsOperation.GetTitleDict(activeSh);
}
UploadRequestParam paras = new UploadRequestParam
{
FileFullName = XlsOperation.MakeSelectedRangeTempFile(activePath, selectedRange, titleDict, activeSh),
Method = "train"
};
InputFormData <UploadRequestParam> data = new InputFormData <UploadRequestParam>
{
SettingFile = settingFile,
RequestParam = paras,
BookPath = activePath,
ModelIdFile = modelIdFile
};
var rsltData = UploadCommand.UploadCSV(data);
if (rsltData.MsgType == 0)
{
data.RequestParam.ModelID = rsltData.DsName;
}
else
{
return;
}
Cursor.Current = preCursor;
menuForm = new ModelCreateEntranceForm(data);
menuForm.Show();
}
}
catch (Exception ex)
{
MsgBox.MsgBoxShowErr(ex.Message);
}
}
public ModelCreateForm(InputFormData <SummaryResultData> iData)
{
InitializeComponent();
GridData = iData.RequestParam.Data;
ModelName = iData.RequestParam.ModelName;
Purpose = iData.RequestParam.Purpose;
tbSelectOutFolder.Text = Path.GetDirectoryName(iData.BookPath);
LoadGrid();
SettingFile = iData.SettingFile;
ThisBookPath = iData.BookPath;
ModelID = iData.RequestParam.ModelID;
ModelIdFile = iData.ModelIdFile;
}
public ModelApplyForm(InputFormData <object> iData)
{
InitializeComponent();
ModelIdFile = iData.ModelIdFile;
ModelIdDict = DataSourceCommand.LoadFile(ModelIdFile);
cbModelID.DataSource = ModelIdDict.DataSources.Keys.Reverse().ToList();
cbHowToModelID.SelectedIndex = 0;
if (cbModelID.Items.Count < 1)
{
cbHowToModelID.SelectedIndex = 1;
}
SetHowTo(cbHowToModelID.SelectedIndex);
ThisSh = iData.ActiveSh;
FilePath = iData.BookPath;
SettingFile = iData.SettingFile;
}
private void OnSetting(object sender, RibbonControlEventArgs e)
{
if (!ExeCheck())
{
return;
}
if (menuForm == null || menuForm.IsDisposed)
{
Reload();
InputFormData <object> data = new InputFormData <object>
{
SettingFile = settingFile
};
menuForm = new SettingForm(data);
menuForm.Show();
}
}
private void OpenApplyForm(object sender, RibbonControlEventArgs e)
{
if (!ExeCheck())
{
return;
}
if (menuForm == null || menuForm.IsDisposed)
{
Reload();
InputFormData <object> iData = new InputFormData <object>
{
ModelIdFile = modelIdFile,
ActiveSh = activeSh,
BookPath = activePath,
SettingFile = settingFile
};
menuForm = new ModelApplyForm(iData);
menuForm.Show();
}
}
private void CollectionStart(object sender, EventArgs e)
{
btnCollectionStart.BackColor = Color.BurlyWood;
Cursor preCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Library.AllCtrlSwInForm(this, false);
IsDoing = true;
try
{
if (String.IsNullOrEmpty(tbModelName.Text) && String.IsNullOrWhiteSpace(tbModelName.Text))
{
throw new Exception("モデル名が未入力です。");
}
if (ModelID == null)
{
throw new Exception("DS_Nameが見つかりません。");
}
SummaryRequestParam paras = new SummaryRequestParam
{
ModelID = ModelID
};
Dictionary <string, string> purposeDict = Library.MakeStringDict(lstPurposeJp, lstPurposeEn);
string purpose = cbPurpose.SelectedItem.ToString();
purposeDict.TryGetValue(purpose, out string resPurpose);
if (resPurpose == null)
{
resPurpose = "CLF";
}
paras.Purpose = resPurpose;
paras.IgnoreCheckY = 1;
InputFormData <SummaryRequestParam> data = new InputFormData <SummaryRequestParam>
{
SettingFile = SettingFile,
RequestParam = paras
};
var rsltData = SummaryCommand.Collection(data);
if (rsltData.MsgType == 0)
{
rsltData.ModelName = tbModelName.Text;
InputFormData <SummaryResultData> iData = new InputFormData <SummaryResultData>
{
SettingFile = SettingFile,
RequestParam = rsltData,
BookPath = BookPath,
ModelIdFile = ModelIdFile
};
iData.RequestParam.ModelID = ModelID;
Form form = new ModelCreateForm(iData);
form.Show(this);
RibbonMenu.menuForm = form;
}
else
{
throw new Exception();
}
}
catch (Exception ex)
{
MsgBox.MsgBoxShowErr(ex.Message);
this.Close();
this.Dispose();
}
finally
{
Library.AllCtrlSwInForm(this, true);
Cursor.Current = preCursor;
btnCollectionStart.BackColor = Color.Empty;
IsDoing = false;
if (!this.IsDisposed)
{
this.Hide();
}
}
}
private void ModelApplied(object sender, EventArgs e)
{
btnExec.BackColor = Color.BurlyWood;
Cursor preCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Library.AllCtrlSwInForm(this, false);
IsDoing = true;
try
{
ModelApplyRequestRaram reqParam = new ModelApplyRequestRaram();
if (cbHowToModelID.SelectedIndex == 0)
{
if (cbModelID.Items.Count >= 1)
{
reqParam.ModelID = cbModelID.SelectedItem.ToString();
}
}
else
{
reqParam.ModelID = tbInputModelID.Text;
}
if (String.IsNullOrEmpty(reqParam.ModelID))
{
throw new Exception("モデルIDを選択または入力して下さい。");
}
Dictionary <object, object> titleDict = null;
var selectedRange = Globals.ThisAddIn.Application.Selection as Excel.Range;
if (selectedRange.ListObject == null)
{
titleDict = XlsOperation.GetTitleDict(ThisSh);
}
UploadRequestParam paras = new UploadRequestParam
{
FileFullName = XlsOperation.MakeSelectedRangeTempFile(FilePath, selectedRange, titleDict, ThisSh),
Method = "predict",
ModelID = reqParam.ModelID
};
InputFormData <UploadRequestParam> data = new InputFormData <UploadRequestParam>
{
SettingFile = SettingFile,
RequestParam = paras
};
var rsltData = UploadCommand.UploadCSV(data);
if (rsltData.MsgType != 0)
{
return;
}
reqParam.DsName = rsltData.DsName;
InputFormData <ModelApplyRequestRaram> iData = new InputFormData <ModelApplyRequestRaram>
{
SettingFile = SettingFile,
RequestParam = reqParam
};
ModelApplyResultData resData = ModelApplyCommand.ModelApplied(iData);
if (resData.MsgType != 0)
{
return;
}
MsgBox.MsgBoxShowInfo("モデル適用が完了しました。");
}
catch (Exception ex)
{
MsgBox.MsgBoxShowErr(ex.Message);
}
finally
{
Library.AllCtrlSwInForm(this, false);
Cursor.Current = preCursor;
btnExec.BackColor = Color.Empty;
IsDoing = false;
this.Close();
this.Dispose();
}
}
public FormInputRow(InputFormData inputFormData)
{
_inputFormData = inputFormData;
InitializeComponent();
}
