/// <summary>
/// 原価実績データを登録する（「原価データ作成」ボタン押下時）
/// </summary>
/// <param name="dgv"></param>
/// <returns></returns>
private bool saveCostReportData(DataGridView dgv)
{
int procCnt = 0;
CostReportData crd = new CostReportData();
crd.OfficeCode = Conv.OfficeCode;
crd.Department = Conv.DepartCode;
crd.ReportDate = dateTimePickerEx1.Value.EndOfMonth();
crd.UnitPrice = 0;
crd.Quantity = 1;
crd.Unit = "式";
//crd.SubCoCode = "";
crd.MemberCode = hp.MemberCode;
//crd.AccountCode = "";
crd.Note = "";
for (int i = 0; i < dgv.Rows.Count; i++)
{
if (Convert.ToString(dgv.Rows[i].Cells["ItemCode"].Value) == "")
{
continue;
}
crd.ItemCode = Convert.ToString(dgv.Rows[i].Cells["ItemCode"].Value);
crd.Item = Convert.ToString(dgv.Rows[i].Cells["Item"].Value);
crd.TaskCode = Convert.ToString(dgv.Rows[i].Cells["TaskCode"].Value);
crd.Cost = DHandling.ToRegDecimal(Convert.ToString(dgv.Rows[i].Cells["Amount"].Value));
crd.LeaderMCode = Convert.ToString(dgv.Rows[i].Cells["LeaderMCode"].Value);
crd.SalesMCode = Convert.ToString(dgv.Rows[i].Cells["SalesMCode"].Value);
crd.CustoCode = Convert.ToString(dgv.Rows[i].Cells["PartnerCode"].Value);
crd.Subject = Convert.ToString(crd.ItemCode[0]);
//crd.Unit = "式";
crd.SubCoCode = crd.ItemCode;
crd.AccountCode = "OSPM";
crd.CoTaskCode = "";
if (Convert.ToString(dgv.Rows[i].Cells["SlipNo"].Value) == "")
{
if (!crd.InsertCostReportAndGetID())
{
return(false);
}
dgv.Rows[i].Cells["SlipNo"].Value = Convert.ToString(crd.SlipNo);
dgv.Rows[i].Cells["CostReportID"].Value = Convert.ToString(crd.CostReportID);
labelMsg.Text = costIns;
}
else
{
crd.SlipNo = Convert.ToInt32(dgv.Rows[i].Cells["SlipNo"].Value);
if (!crd.UpdateCostReport())
{
return(false);
}
labelMsg.Text = costUpd;
}
procCnt++;
}
if (procCnt == 0)
{
MessageBox.Show("処理対象のデータはありませんでした！");
return(false);
}
return(true);
}
private void button_Click(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
Button btn = ( Button )sender;
switch (btn.Name)
{
case "buttonSave":
if (!savePaymentData(dataGridView1))
{
return;
}
if (opd.SlipNo > 0)
{
CostReportData crp = new CostReportData();
if (!crp.UpdateCostReport(opd))
{
return; // 変更内容を原価実績データにも反映
}
}
labelMsg.Text = dataSave;
updateStat = false;
break;
case "buttonDelete":
if (!deletePaymentData(dataGridView1))
{
return;
}
break;
case "buttonCost":
if (!saveCostReportData(dataGridView1))
{
return;
}
if (!savePaymentData(dataGridView1))
{
return;
}
labelMsg.Text = costSave;
break;
case "buttonCancel":
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(iniRCnt);
seqNoReNumbering(dataGridView1);
break;
case "buttonEnd":
if (!unsavedCheck(dataGridView1))
{
return;
}
this.Close();
break;
case "buttonPrint":
PublishOsCost poc = new PublishOsCost(Folder.DefaultExcelTemplate("外注出来高調書.xlsx"), collectPublishData(dataGridView1));
poc.ExcelFile("OsPayment");
break;
default:
break;
}
if (btn.Name == "buttonEnd" || btn.Name == "buttonPrint")
{
return;
}
selectPaymentData(dataGridView1, dateTimePickerEx1.Value.EndOfMonth(), Conv.OfficeCode, Conv.DepartCode);
}
