private void createExcelFile(string templateFileName, string sheetName)
{
Publish publ = new Publish(Folder.DefaultExcelTemplate(templateFileName));
PublishData pd = new PublishData();
pd.TaskCode = ted.TaskCode;
pd.TaskName = ted.TaskName;
pd.CostType = ted.CostType;
pd.TaskPlace = ted.TaskPlace;
pd.StartDate = ted.StartDate;
pd.EndDate = ted.EndDate;
pd.TaxRate = ted.TaxRate;
pd.Publisher = Convert.ToString(comboBoxOffice.SelectedValue) + Convert.ToString(comboBoxWork.SelectedValue);
pd.OrderDate = dateTimePickerOrderDate.Value;
pd.OrderStartDate = dateTimePickerOStart.Value;
pd.OrderEndDate = dateTimePickerOEnd.Value;
pd.InspectDate = dateTimePickerInspectDate.Value;
pd.ReceiptDate = dateTimePickerReceiptDate.Value;
pd.OrderPartner = comboBoxPartner.Text;
pd.Place = textBoxDeliveryPoint.Text;
pd.Note = textBoxNote.Text;
pd.PayRoule = Convert.ToInt32(comboBoxPayRoule.SelectedValue);
pd.OrderNo = labelOrderNo.Text;
pd.Amount = DHandling.ToRegDecimal(labelSum.Text);
pd.Tax = pd.Amount * pd.TaxRate;
pd.OfficeCode = Convert.ToString(comboBoxOffice.SelectedValue);
pd.OfficeName = comboBoxOffice.Text;
pd.PublishOffice = (checkBoxPublish.Checked) ? 1 : 0;
publ.ExcelFile(sheetName, pd, dataGridView1);
return;
}
// Wakamatsu 20170316
private void buttonPrint_Click(object sender, EventArgs e)
{
// print 処理
// Wakamatsu 20170301
//Publish publ = new Publish(Folder.DefaultExcelTemplate("CostSummary.xlsx"));
Publish publ = new Publish(Folder.DefaultExcelTemplate("原価集計表.xlsx"));
// Wakamatsu 20170301
PublishData pd = new PublishData();
publ.ExcelFile("CostSummary", pd, dataGridView1);
}
private void createExcelFile(string templateFileName, string sheetName)
{
Publish publ = new Publish(Folder.DefaultExcelTemplate(templateFileName));
PublishData pd = new PublishData();
pd.TaskCode = ted.TaskCode;
pd.TaskName = ted.TaskName;
pd.CostType = ted.CostType;
pd.TaskPlace = ted.TaskPlace;
pd.StartDate = ted.StartDate;
pd.EndDate = ted.EndDate;
pd.TaxRate = ted.TaxRate;
pd.PartnerName = ted.PartnerName;
pd.LeaderName = labelLeader.Text;
pd.SalesMName = labelSalesM.Text;
pd.OrderPartner = labelPartner.Text;
pd.RecordedDate = dateTimePickerRecordedDate.Value;
publ.ExcelFile(sheetName, pd, dataGridView1);
return;
}
public void CreateExcelFile(TaskEntryData ted, DataGridView dgv, string templateFileName, string sheetName)
{
Publish publ = new Publish(Folder.DefaultExcelTemplate(templateFileName));
PublishData pd = new PublishData();
pd.TaskCode = ted.TaskCode;
pd.TaskName = ted.TaskName;
pd.CostType = ted.CostType;
pd.TaskPlace = ted.TaskPlace;
pd.StartDate = ted.StartDate;
pd.EndDate = ted.EndDate;
pd.TaxRate = ted.TaxRate;
pd.PartnerName = ted.PartnerName;
pd.RecordedDate = dateTimePickerRecordedDate.Value.StripTime();
pd.OfficeCode = ted.OfficeCode;
pd.OfficeName = ted.OfficeName;
pd.PublishOffice = (checkBoxPublish.Checked) ? 1 : 0;
publ.ExcelFile(sheetName, pd, dgv);
return;
}
//------------------------------//
// Event
//------------------------------//
private void button_Click(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
Button btn = ( Button )sender;
EstPlanOp epo = new EstPlanOp();
switch (btn.Name)
{
// 予算書からデータ取得
case "buttonFromEstimate":
if (MessageBox.Show("見積書のデータを予算書に取り込みます。\r\n" +
"現在表示中のデータはすべて削除されます。", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
//"予算書内のデータはすべて削除されますので注意してください。", "", MessageBoxButtons.YesNo ) == DialogResult.No )
return;
}
if (loadEstimateData())
{
reCalculateAll(dataGridView1);
labelMsg.Text = msgCopyEstimate;
}
else
{
labelMsg.Text = msgNoEstimate;
}
break;
// 実行予算書へ戻る
case "buttonPrev":
if (updateStat)
{
Func <DialogResult> dialogRemining = DMessage.DialogRemining;
if (dialogRemining() == DialogResult.No)
{
return;
}
}
this.Close();
break;
// 再計算
case "buttonReCalc":
reCalculateAll(dataGridView1);
break;
// 上書、但しデータが全くない場合は新規保存
case "buttonOWrite":
reCalculateAll(dataGridView1);
if (plnd[idx].PlanningID < 1)
{
storePlanningAndContents(dataGridView1);
}
else
{
updatePlanningAndContents(dataGridView1);
}
updateStat = false;
break;
// 新版で保存
case "buttonNWrite":
reCalculateAll(dataGridView1);
restructPlanningData();
storePlanningAndContents(dataGridView1);
updateStat = false;
break;
// 削除
case "buttonDelete":
deletePlanningAndContents();
updateStat = false;
break;
case "buttonCancel":
initialDisplayPlannignContData();
loadPlanningContData(dataGridView1);
updateStat = false;
break;
case "buttonPrint":
reCalculateAll(dataGridView1);
Publish publ = new Publish(Folder.DefaultExcelTemplate(bookName));
PublishData pd = new PublishData();
pd.Version = plnd[idx].VersionNo;
pd.PublishIndex = idx;
publ.ExcelFile(sheetName, pd, dataGridView1);
break;
default:
break;
}
}
