/// <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); }