private void deletePlanningAndContents()
{
EstPlanOp epo = new EstPlanOp();
if (!epo.Planning_Delete(plnd[idx].PlanningID))
{
return;
}
if (!epo.PlanningCont_Delete(plnd[idx].PlanningID))
{
return;
}
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(iniRCnt);
buttonNumbering();
reCalculateAll(dataGridView1);
plnd[idx].PlanningID = 0;
plnd[idx].Sales = 0;
plnd[idx].Budgets = 0;
plnd[idx].Discussion = "";
plnd[idx].OfficeCode = "";
plnd[idx].Department = "";
plnd[idx].Publisher = "";
clearLabelText();
labelMsg.Text = "削除しました。";
}
//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormInvoice_Load(object sender, EventArgs e)
{
this.defaultCellStyle = new DataGridViewCellStyle();
UiHandling uih = new UiHandling(dataGridView1);
uih.DgvReadyNoRHeader();
uih.NoSortable();
DateTime dtNow = DateTime.Now;
iniRCnt = Convert.ToInt32((dtNow.EndOfMonth()).Day) - 1;
dataGridView1.Rows.Add(iniRCnt);
edit_Labels();
edit_TextBox();
create_dtPicker();
// 作業項目マスタの一覧作成
EstPlanOp ep = new EstPlanOp();
wid = ep.StoreWorkItemsData(ted.MemberCode);
initialProcessing(0);
nowMonth();
}
// 内訳データ読込GridView表示
private bool loadPlanningContData(DataGridView dgv)
{
dgv.Rows.Clear();
dgv.Rows.Add(iniRCnt);
EstPlanOp epo = new EstPlanOp();
if (plnd[idx].PlanningID > 0)
{
DataTable dt = epo.PlanningCont_Select(plnd[idx].PlanningID);
if (dt == null)
{
return(false);
}
if (dt.Rows.Count > iniRCnt)
{
dgv.Rows.Add(dt.Rows.Count - iniRCnt);
}
if (!viewPlanningContToDgv(dt, dgv))
{
return(false);
}
}
buttonNumbering();
reCalculateAll(dgv);
return(true);
}
private void button_Click(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
Button btn = ( Button )sender;
EstPlanOp epo = new EstPlanOp();
switch (btn.Name)
{
case "buttonPrint":
PublishTaskNoConfList poc = new PublishTaskNoConfList(Folder.DefaultExcelTemplate(bookName), collectTaskNoConfListData(dataGridView1));
poc.ExcelFile();
break;
case "buttonClose":
this.Close();
break;
default:
break;
}
}
private void button_Click(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
Button btn = ( Button )sender;
EstPlanOp epo = new EstPlanOp();
switch (btn.Name)
{
case "buttonOWrite":
break;
case "buttonDelete":
break;
case "buttonCancel":
this.Close();
break;
case "buttonPrint":
PublishReview prev = new PublishReview(Folder.DefaultExcelTemplate(excelFile), editPublishData(dataGridView1));
prev.ExcelFile();
break;
case "buttonClose":
this.Close();
break;
default:
break;
}
}
private void viewOutsourceDataToForm(int idx, DataGridView dgv)
{
EstPlanOp epo = new EstPlanOp();
osd[idx].OrderNo = epo.NumberingOrder(osd[idx].OfficeCode, osd[idx].Department);
labelOrderNo.Text = osd[idx].OrderNo;
osd[idx].TaskEntryID = ted.TaskEntryID;
if ((osd[idx].OutsourceID = epo.InsertOutsource(osd[idx])) > 0)
{
epo.InsertOutsourceCont(dataGridView1, osd[idx].OutsourceID);
}
loadExistingOutsourceData();
}
private void initialSetbuttonFromPlan()
{
EstPlanOp epo = new EstPlanOp();
DataTable dt;
if ((dt = epo.Planning_Select_Latest(ted.TaskEntryID)) == null)
{
buttonFromPlan.Enabled = false;
}
else
{
buttonFromPlan.Enabled = true;
}
}
private void updatePlanningAndContents(DataGridView dgv)
{
EstPlanOp epo = new EstPlanOp();
if (!epo.Planning_Update(plnd[idx]))
{
return;
}
if (!epo.PlanningCont_Delete(plnd[idx].PlanningID))
{
return;
}
if (!epo.PlanningCont_Insert(dgv, plnd[idx].PlanningID))
{
return;
}
labelMsg.Text = "更新しました。";
}
private void loadPlanningData(DataGridView dgv)
{
EstPlanOp epo = new EstPlanOp();
DataTable dt;
if ((dt = epo.Planning_Select_Latest(ted.TaskEntryID)) == null)
{
return;
}
plnd = new PlanningData(dt.Rows[dt.Rows.Count - 1]);
string condition = "Cost1 > 0";
if ((dt = epo.PlanningCont_Select(plnd.PlanningID, condition)) == null)
{
return;
}
dgv.Rows.Clear();
dgv.Rows.Add(iniRCnt);
if (dt.Rows.Count > iniRCnt)
{
dgv.Rows.Add(dt.Rows.Count - iniRCnt);
}
if (!viewOutsourceContToDgv(dt, dgv))
{
return;
}
reCalculateAll(dgv); // 再計算
osd = new OutsourceData[1];
osd[0] = new OutsourceData();
osd[0].TaskEntryID = plnd.TaskEntryID;
osd[0].PlanningID = plnd.PlanningID;
osd[0].OfficeCode = plnd.OfficeCode;
osd[0].Department = plnd.Department;
osd[0].Publisher = plnd.OfficeCode + plnd.Department;
plnd = new PlanningData(); // 使用済み初期化
return;
}
private void storePlanningAndContents(DataGridView dgv)
{
EstPlanOp epo = new EstPlanOp();
plnd[idx].VersionNo = plnd[idx].MaxVersion + 1;
plnd[idx].TaskEntryID = ted.TaskEntryID;
plnd[idx].OfficeCode = ted.OfficeCode;
plnd[idx].Department = ted.Department;
plnd[idx].Publisher = ted.OfficeCode + ted.Department;
plnd[idx].PlanningID = epo.Planning_Insert(plnd[idx]);
if (plnd[idx].PlanningID < 0)
{
return;
}
if (!epo.PlanningCont_Insert(dgv, plnd[idx].PlanningID))
{
return;
}
buttonOWrite.Enabled = true;
buttonNWrite.Enabled = false; // 新規保存利用不可
labelMsg.Text = "保存しました。";
}
private void FormPlanningCont_Load(object sender, EventArgs e)
{
this.defaultCellStyle = new DataGridViewCellStyle();
UiHandling uih = new UiHandling(dataGridView1);
//並び替えができないようにする
foreach (DataGridViewColumn c in dataGridView1.Columns)
{
c.SortMode = DataGridViewColumnSortMode.NotSortable;
}
// Assist Message クリア
labelMsg.Text = "";
dataGridView1.Rows.Add(iniRCnt);
buttonNumbering();
initialDisplayPlannignContData();
create_cbEVersion();
// 作業項目マスタの取込み
EstPlanOp ep = new EstPlanOp();
wid = ep.StoreWorkItemsData(ted.MemberCode);
// I/Fデータ(plnd)の既存データ数確認と利用可能ボタンの設定
setButtonEnabled();
// 既存内訳データ読込
if (endPoint > -1 && plnd[idx].PlanningID > 0)
{
loadPlanningContData(dataGridView1);
}
updateStat = false;
}
private bool loadEstimateData()
{
EstPlanOp epo = new EstPlanOp();
int verNo = (String.IsNullOrEmpty(comboBoxEVersion.Text)) ? 0 : Convert.ToInt32(comboBoxEVersion.Text);
DataTable dt = epo.Estimate_Select(ted.TaskEntryID, verNo);
if (dt == null)
{
return(false);
}
DataRow dr = dt.Rows[0];
EstimateData estd = new EstimateData(dr);
dt = epo.EstimateCont_Select(estd.EstimateID);
if (dt == null)
{
return(false);
}
viewEstimateContToDgv(dt, dataGridView1);
viewEstimateData(estd);
viewPlanningContSummary();
return(true);
}
// Cell 内容に変化があった時
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (iniPro)
{
return; // 初期化中
}
if (grdSet == true)
{
return;
}
DataGridView dgv = ( DataGridView )sender;
Calculation calc = new Calculation();
switch (e.ColumnIndex)
{
case 1: // 「コード」列
EstPlanOp epo = new EstPlanOp(); // Code入力時作業項目マスタ読込
WorkItemsData wids = epo.LoadWorkItemsData(wid, Convert.ToString(dgv.Rows[e.RowIndex].Cells["Code"].Value));
if (wids != null)
{
viewItemDataToDgv(dgv.Rows[e.RowIndex], wids);
}
dgv.Refresh();
break;
case 4: // 「数量」列
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly == false)
{
editDGVRowCell(dgv.Rows[e.RowIndex], e.ColumnIndex);
reCalculateAll(dataGridView1);
}
break;
case 6: // 単価0
case 8: // 単価1
case 10: // 単価2
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly == false)
{
if (Convert.ToString(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) != "")
{
editDGVRowCell(dgv.Rows[e.RowIndex], e.ColumnIndex);
}
reCalculateAll(dataGridView1);
}
break;
case 7:
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly == false)
{
reCalculateAll(dataGridView1);
}
if (Convert.ToString(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) != "")
{
// 直営費金額
AmountReg[0] = Convert.ToString(dgv.Rows[e.RowIndex].Cells["Amount0"].Value);
}
break;
case 9:
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly == false)
{
reCalculateAll(dataGridView1);
}
if (Convert.ToString(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) != "")
{
// 下請外注費金額
AmountReg[1] = Convert.ToString(dgv.Rows[e.RowIndex].Cells["Amount1"].Value);
}
break;
case 11:
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly == false)
{
reCalculateAll(dataGridView1);
}
if (Convert.ToString(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) != "")
{
// 資材費金額
AmountReg[2] = Convert.ToString(dgv.Rows[e.RowIndex].Cells["Amount2"].Value);
}
break;
case 12:
if (Convert.ToString(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) != "")
{
// 計
AmountReg[3] = Convert.ToString(dgv.Rows[e.RowIndex].Cells["Sum"].Value);
}
break;
default:
break;
}
updateStat = true;
}
//------------------------------//
// 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;
}
}
private void button_Click(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
Button btn = ( Button )sender;
EstPlanOp epo = new EstPlanOp();
switch (btn.Name)
{
case "buttonFromPlan":
Func <DialogResult> dialogNewLoad = DMessage.DialogNewLoad;
if (dialogNewLoad() == DialogResult.No)
{
return;
}
loadPlanningData(dataGridView1);
buttonNumbering(dataGridView1);
buttonFromPlan.Enabled = false;
break;
case "buttonPrevData":
if (cpg > 0)
{
cpg--;
viewData(cpg);
}
break;
case "buttonNextData":
if (cpg < osd.Length - 1)
{
cpg++;
viewData(cpg);
}
break;
case "buttonCopyAndNext":
clearOutsourceContAmount(dataGridView1);
OutsourceData[] newOsd = new OutsourceData[osd.Length + 1];
Array.Copy(osd, newOsd, Math.Min(osd.Length, newOsd.Length));
newOsd[newOsd.Length - 1] = ( OutsourceData )osd[cpg].Clone();
newOsd[newOsd.Length - 1].OutsourceID = 0;
osd = newOsd;
buttonGrpDisabled();
buttonPrevData.Enabled = true;
buttonNew.Enabled = true;
cpg++;
break;
case "buttonClose":
this.Close();
break;
case "buttonReCalc":
reCalculateAll(dataGridView1);
break;
case "buttonOverWrite":
Func <DialogResult> dialogOverWrite = DMessage.DialogOverWrite;
if (dialogOverWrite() == DialogResult.No)
{
return;
}
if (checkAndStoreLatestOutsourceData(cpg))
{
viewOutsourceDataToForm(cpg, dataGridView1);
}
else
{
epo.UpdateOutsource(osd[cpg]);
epo.UpdateOutsourceCont(dataGridView1, osd[cpg].OutsourceID);
}
break;
case "buttonNew":
storeLatestOutsourceData(cpg);
viewOutsourceDataToForm(cpg, dataGridView1);
initialViewSetting(cpg);
//buttonGrpEnabled();
break;
case "buttonDelete":
Func <DialogResult> dialogDelete = DMessage.DialogDelete;
if (dialogDelete() == DialogResult.No)
{
return;
}
epo.DeleteOutsourceCont(osd[cpg].OutsourceID);
epo.DeleteOutsource(osd[cpg].OutsourceID);
cpg--;
initialViewSetting(cpg);
break;
case "buttonCancel":
Func <DialogResult> dialogCancel = DMessage.DialogCancel;
if (dialogCancel() == DialogResult.No)
{
return;
}
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(iniRCnt);
break;
case "buttonPrintContent":
createExcelFile("外注内訳書.xlsx", "OsContent");
break;
case "buttonPrintOrder":
createExcelFile("注文書.xlsx", "OsOrder");
break;
case "buttonPrintConfirm":
createExcelFile("注文請書.xlsx", "OsConfirm");
break;
default:
break;
}
edit_lblPageNo();
}
