//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormRegular_Load(object sender, EventArgs e)
{
UiHandling uih = new UiHandling(dataGridViewL);
uih.DgvReadyNoRHeader();
uih.NoSortable();
uih = new UiHandling(dataGridViewR);
uih.DgvReadyNoRHeader();
uih.NoSortable();
uih = new UiHandling(dataGridViewT);
uih.DgvReadyNoRHeader();
uih.NoSortable();
labelPublisher.Text = ted.OfficeName + ted.DepartName; // 部署名
create_cbOffice(); // 事業所comboBox
comboBoxOffice.Text = ted.OfficeName;
create_cbWork(); // 部門ComboBox
comboBoxWork.Text = ted.DepartName;
ListFormDataOp lo = new ListFormDataOp();
psd = lo.SelectPartnersScData();
create_dtPicker();
edit_Labels();
initialViewSetting(0);
nowMonth();
}
private void comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
ComboBox cb = ( ComboBox )sender;
ListFormDataOp lo = new ListFormDataOp();
Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepartment);
switch (cb.Name)
{
case "comboBoxOffice":
initializeTaskCostData();
create_cbDepart();
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, null);
break;
case "comboBoxDepartment":
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, null); // Task情報
break;
default:
break;
}
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(iniRCnt);
}
//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormMenuEstPlan_Load(object sender, EventArgs e)
{
create_cbOffice(); // ComboBox 「事業所」作成
create_cbDepart(); // ComboBox 「部門」作成
create_cbCostType(); // ComboBox 「原価目標」作成
clearLabel();
// 各ボタンに現在の最新版数表示
//setButtonLabel(Convert.ToString(comboBoxTaskName.SelectedValue), publisher);
//ted = new TaskEntryData();
//ted.OfficeCode = hp.OfficeCode;
//ted.Department = hp.Department;
//ted.OfficeName = hp.OfficeName;
//ted.DepartName = hp.DepartName;
//ted.MemberCode = hp.MemberCode;
//ted.TaxRate = hp.TaxRate;
//ted.AdminCostRate = hp.AdminCostRate;
//ted.OthersCostRate = hp.OthersCostRate;
//ted.Expenses = hp.Expenses;
Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepartment);
ListFormDataOp lo = new ListFormDataOp();
//etcd = lo.SelectTaskEntryNameData( hp.OfficeCode, Convert.ToString( comboBoxDepartment.SelectedValue ), null );
etcd = lo.SelectTaskEntryNameData(Conv.OfficeCode, Conv.DepartCode, null);
//tcd = lo.SelectTaskCodeNameData( hp.OfficeCode, Convert.ToString( comboBoxDepartment.SelectedValue ), null );
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, null);
}
private void dispCostList(string officeCode)
{
string wParam = " ORDER BY CostCode";
if (labelItemCode.Text != "")
{
wParam = " AND ((CostCode LIKE '%999') OR (CostCode BETWEEN 'A' AND 'C'+'1') OR "
+ "(CostCode LIKE 'D%' AND Item LIKE '" + textBoxItem.Text + "%') OR "
+ "(CostCode LIKE 'E%') OR (CostCode BETWEEN 'G' AND 'Z'+'1') OR "
+ "(CostCode = '" + labelItemCode.Text + "')) ORDER BY CostCode";
}
//wParam = " AND ((CostCode BETWEEN 'A' AND 'E'+'1') OR (CostCode BETWEEN 'G' AND 'Z'+'1') OR (CostCode = '" + labelItemCode.Text + "')) ORDER BY CostCode";
ListFormDataOp lo = new ListFormDataOp();
cmd = lo.SelectCostData(officeCode, wParam);
if (cmd == null)
{
return;
}
dataGridView2.Rows.Clear();
//dataGridView2.Rows.Add( cmd.GetLength( 0 ) - 1 );
dataGridView2.Rows.Add(cmd.Length - 1);
//for ( int i = 0; i < cmd.GetLength( 0 ); i++ )
for (int i = 0; i < cmd.Length; i++)
{
dataGridView2.Rows[i].Cells["CItemCode"].Value = cmd[i].CostCode;
dataGridView2.Rows[i].Cells["CItem"].Value = cmd[i].Item;
dataGridView2.Rows[i].Cells["CItemDetail"].Value = cmd[i].ItemDetail;
dataGridView2.Rows[i].Cells["CUnit"].Value = cmd[i].Unit;
}
seqNoReNumbering(dataGridView2, "CSeq");
checkExistingCostData();
}
private void comboBox_TextChanged(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
ComboBox cbx = ( ComboBox )sender;
Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepart);
switch (cbx.Name)
{
case "comboBoxOffice":
create_cbDepart();
ListFormDataOp lo = new ListFormDataOp();
cmd = lo.SelectCostDataInitialF(Conv.OfficeCode);
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode);
break;
case "comboBoxDepart":
break;
default:
break;
}
selectPaymentData(dataGridView1, dateTimePickerEx1.Value.EndOfMonth(), Conv.OfficeCode, Conv.DepartCode);
}
private void comboBox_TextChanged(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
ComboBox cb = (ComboBox)sender;
switch (cb.Name)
{
case "comboBoxOffice":
ListFormDataOp lo = new ListFormDataOp();
tcd = lo.SelectTaskCodeNameData(Convert.ToString(comboBoxOffice.SelectedValue)); // Task情報
cmd = lo.SelectCostData(Convert.ToString(comboBoxOffice.SelectedValue)); // Cost情報
create_cbDepart();
break;
case "comboBoxDepart":
break;
default:
break;
}
}
//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormLogin_Load(object sender, EventArgs e)
{
Assembly mainAssembly = Assembly.GetEntryAssembly();
this.Text = String.Format("出来高管理システム （ ver {0} ） ", mainAssembly.GetName().Version);
labelMessage.Text = "";
ListFormDataOp lo = new ListFormDataOp();
msd = lo.SelectMembersScData();
}
// [Ctrl]と組み合わせたTextBoxの操作用Short-Cut Key
// 前提：コントロールがTextBoxにある時
private void textBox_KeyDown(object sender, KeyEventArgs e)
{
labelMessage.Text = "";
if (iniPro)
{
return;
}
TextBox tb = ( TextBox )sender;
if (e.KeyCode == Keys.Enter)
{
switch (tb.Name)
{
case "textBoxItem":
if (!selectCostMaster(textBoxItem.Text))
{
MessageBox.Show("指定された原価コードのデータはありません");
return;
}
break;
default:
break;
}
}
if ((e.Modifiers & Keys.Control) != Keys.Control)
{
return; // Ctrlキーが押下された時のみ以下処理
}
if (e.KeyCode == Keys.A)
{
ListFormDataOp lo = new ListFormDataOp();
cmd = lo.SelectCostDataInitialF(hp.OfficeCode);
chooseCostData();
iSelPro[0] = false;
iSelPro[1] = false;
checkBoxTSelAll.Checked = false;
checkBoxCSelAll.Checked = false;
}
if (textBoxItem.Text == "")
{
labelItemCode.Text = "";
return;
}
else
{
dispTaskCodeNameList(Convert.ToString(comboBoxOffice.SelectedValue), Convert.ToString(comboBoxDepart.SelectedValue));
dispCostList(Convert.ToString(comboBoxOffice.SelectedValue));
}
}
private TaskCodeNameData[] setupSourceTaskCodeNameArray(DateTime dateFr, DateTime dateTo, string item, string officeCode, int val)
{
if (val == 0)
{
dateTo = dateFr;
}
if (dateTo.StripTime() < dateFr.StripTime())
{
dateTo = dateFr;
}
ListFormDataOp lo = new ListFormDataOp();
return(tcas = lo.SelectTaskCodeNameFromCostReport(dateFr.StripTime(), dateTo.StripTime(), item, officeCode));
}
private CostData[] setupCostDataArray(DateTime dateFr, DateTime dateTo, string officeCode, string department, int val)
{
if (val == 0)
{
dateTo = dateFr;
}
if (dateTo.StripTime() < dateFr.StripTime())
{
dateTo = dateFr;
}
ListFormDataOp lo = new ListFormDataOp();
return(cost = lo.SelectCostDataFromCostReport(dateFr.StripTime(), dateTo.StripTime(), officeCode, department));
}
// 取引先マスタ外注データをFormSubComList画面から得る
private void choosePartnersScData(DataGridViewRow dgvRow)
{
PartnersScData psds = FormSubComList.ReceiveItems(psd);
if (psds == null)
{
return;
}
dgvRow.Cells["CoCompany"].Value = psds.PartnerName;
ListFormDataOp lo = new ListFormDataOp();
string editPartnerName = psds.PartnerName;
cmd = lo.SelectCostData(Conv.OfficeCode, "CostCode", "F", editPartnerName.RemoveCorpForm());
}
//--------------------------------------------------------------------------//
// SubRoutine //
//--------------------------------------------------------------------------//
private void initializeScreen()
{
textBoxTaskCode.Text = "";
initializeTaskCostData();
create_cbOffice();
create_cbDepart();
dateTimePickerFR.Value = DateTime.Now;
dateTimePickerTO.Value = DateTime.Now;
ListFormDataOp lo = new ListFormDataOp();
tcd = lo.SelectTaskCodeNameData(string.IsNullOrEmpty(TaskSummary.Default.Office) ? "H" : TaskSummary.Default.Office,
string.IsNullOrEmpty(TaskSummary.Default.Department) ? "2" : TaskSummary.Default.Department, null); // Task情報
}
//--------------------------------------------------------------------------//
// SubRoutine //
//--------------------------------------------------------------------------//
private void initializeScreen()
{
labelMessage.Text = "";
textBoxSlipNo.Text = "";
textBoxSlipNo.ReadOnly = false;
textBoxTaskCode.Text = "";
textBoxTaskName.Text = "";
labelPartnerName.Text = "";
labelTaskPlace.Text = "";
labelStartDate.Text = "";
labelEndDate.Text = "";
labelLeaderMName.Text = "";
labelLeaderMCode.Text = "";
labelSalesMName.Text = "";
labelSalesMCode.Text = "";
labelSum.Text = "0";
labelAmount.Text = "0";
labelTax.Text = "0";
labelPartnerCode.Text = "";
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(iniRCnt);
//buttonNumbering();
create_cbOffice();
//comboBoxOffice.Text = hp.OfficeCode; // 初期値
//comboBoxOffice.SelectedIndex = oList.IndexOf(hp.OfficeCode);
comboBoxOffice.SelectedIndex = Conv.oList.IndexOf(hp.OfficeCode);
create_cbDepart();
comboBoxDepart.Text = hp.Department; // 初期値
dateTimePickerEntryDate.Value = DateTime.Now;
ListFormDataOp lo = new ListFormDataOp();
tcd = lo.SelectTaskCodeNameData(hp.OfficeCode); // Task情報
cmd = lo.SelectCostData(hp.OfficeCode); // Cost情報
}
//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormTaskChange_Load(object sender, EventArgs e)
{
create_cbOffice();
comboBoxOffice.Text = hp.OfficeCode; // 初期値
create_cbDepart();
comboBoxDepart.Text = hp.Department; // 初期値
labelItem.Text = "";
labelSTaskName.Text = "";
labelDTaskName.Text = "";
labelMes.Text = "";
ListFormDataOp lo = new ListFormDataOp();
tcad = lo.SelectTaskCodeNameData(hp.OfficeCode, hp.Department, "DESC");
DateTime dtToday = DateTime.Today;
cost = setupCostDataArray(dtToday, dtToday, hp.OfficeCode, hp.Department, 0);
}
private void comboBox_TextChanged(object sender, EventArgs e)
{
if (iniPro)
{
return;
}
ComboBox cb = ( ComboBox )sender;
ted = new TaskEntryData();
Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepartment);
ListFormDataOp lo = new ListFormDataOp();
switch (cb.Name)
{
case "comboBoxOffice":
ted.OfficeName = cb.Text;
create_cbDepart();
etcd = lo.SelectTaskEntryNameData(Conv.OfficeCode, Conv.DepartCode, null);
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, "DESC");
this.textBoxTaskName.Text = "";
clearLabel();
break;
case "comboBoxDepartment":
ted.DepartName = cb.Text;
etcd = lo.SelectTaskEntryNameData(Conv.OfficeCode, Conv.DepartCode, null);
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, "DESC");
this.textBoxTaskName.Text = "";
clearLabel();
break;
case "comboBoxCostType":
ted.CostType = cb.Text;
clearLabel();
break;
default:
break;
}
}
private void comboBox_TextChanged(object sender, EventArgs e)
{
labelMes.Text = "";
if (iniPro)
{
return;
}
ComboBox cbx = (ComboBox)sender;
ListFormDataOp lo = new ListFormDataOp();
// Debug
dateTimePickerTo.Value = dateTimePickerFr.Value;
switch (cbx.Name)
{
case "comboBoxOffice":
create_cbDepart();
tcad = lo.SelectTaskCodeNameData(Convert.ToString(comboBoxOffice.SelectedValue),
Convert.ToString(comboBoxDepart.SelectedValue), "DESC");
cost = setupCostDataArray(dateTimePickerFr.Value, dateTimePickerTo.Value,
Convert.ToString(comboBoxOffice.SelectedValue), Convert.ToString(comboBoxDepart.SelectedValue), 0);
break;
case "comboBoxDepart":
tcad = lo.SelectTaskCodeNameData(Convert.ToString(comboBoxOffice.SelectedValue),
Convert.ToString(comboBoxDepart.SelectedValue), "DESC");
cost = setupCostDataArray(dateTimePickerFr.Value, dateTimePickerTo.Value,
Convert.ToString(comboBoxOffice.SelectedValue), Convert.ToString(comboBoxDepart.SelectedValue), 0);
break;
default:
break;
}
// Wakamatsu 20170322
ControlClear(1);
// Wakamatsu 20170322
}
private void FormTaskEntry_Load(object sender, EventArgs e)
{
labelPublisher.Text = ted.OfficeName + " " + ted.DepartName;
labelTaskCode.Text = "";
/***** ComboBox 「原価目標」作成 *****/
ComboBoxEdit cb = new ComboBoxEdit(comboBoxCostType);
cb.ComDataList("COST", ted.OfficeCode);
comboBoxCostType.Text = "選択してください"; // 初期値
/***** ComboBox 「事業所」作成 *****/
//cb = new ComboBoxEdit( comboBoxPartner );
//cb.TableData( "M_Partners", "PartnerCode", "PartnerName", " WHERE RelCusto = 1 ORDER BY PartnerCode" );
//comboBoxPartner.Text = "選択してください"; // 初期値
ListFormDataOp lo = new ListFormDataOp();
tcd = lo.SelectTaskCodeNameData(ted.OfficeCode, (ted.OfficeCode == Sign.HQOfficeCode ? ted.Department : "8"), null);
psd = lo.SelectPartnersCuData();
td = new TaskData();
tid = new TaskIndData();
}
private bool dispTaskInformation(string taskCode)
{
ListFormDataOp lo = new ListFormDataOp();
TaskCodeNameData tcnd = lo.SelectTaskCodeNameData(taskCode, Convert.ToString(comboBoxOffice.SelectedValue));
TaskData td = lo.SelectTaskData(taskCode);
if (td == null)
{
return(false);
}
labelTaskName.Text = td.TaskName;
labelTerm.Text = "工期：";
labelTerm.Text += (td.StartDate.StripTime()).ToString("yyyy年MM月dd日") + " ～ ";
labelTerm.Text += (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
if (td.PartnerCode != null)
{
PartnersData pd = new PartnersData();
labelPartnerName.Text = pd.SelectPartnerName(td.PartnerCode);
}
return(true);
}
//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormOsPayment_Load(object sender, EventArgs e)
{
create_cbOffice();
comboBoxOffice.Text = hp.OfficeCode; // 初期値
create_cbDepart();
comboBoxDepart.Text = hp.Department; // 初期値
this.clsArray = new DateTime[] { hp.CloseHDate, hp.CloseKDate, hp.CloseSDate, hp.CloseTDate }; // 現在の締日リスト
dataGridView1.Rows.Add(iniRCnt);
UiHandling ui = new UiHandling(dataGridView1);
ui.DgvReadyNoRHeader();
readyDateTimePicker();
dateTimePickerEx1.Value = clsArray[Conv.oList.IndexOf(hp.OfficeCode)].AddMonths(1); // 初期表示開始月（締月の翌月）
preReportDate = dateTimePickerEx1.Value.EndOfMonth();
labelACheckDate.Text = "";
labelDCheckDate.Text = "";
labelPCheckDate.Text = "";
labelMsg.Text = "";
readyCheckBox();
buttonEnabled();
buttonCost.Enabled = false;
// 取引先マスタより外注先一覧作成
Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepart);
ListFormDataOp lo = new ListFormDataOp();
psd = lo.SelectPartnersScData();
tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode);
cmd = lo.SelectCostDataInitialF(Conv.OfficeCode);
selectPaymentData(dataGridView1, dateTimePickerEx1.Value.EndOfMonth(), Conv.OfficeCode, Conv.DepartCode);
}
private void textBox_KeyDown(object sender, KeyEventArgs e)
{
labelMes.Text = "";
if (iniPro)
{
return;
}
TextBox tb = (TextBox)sender;
ListFormDataOp lo = new ListFormDataOp();
TaskCodeNameData tcd;
if (e.KeyCode == Keys.Enter)
{
switch (tb.Name)
{
case "textBoxItem":
if (!selectCostMaster(textBoxItem.Text))
{
MessageBox.Show("指定された原価コードのデータはありません");
return;
}
tcas = setupSourceTaskCodeNameArray(dateTimePickerFr.Value, dateTimePickerTo.Value,
textBoxItem.Text, Convert.ToString(comboBoxOffice.SelectedValue), 0);
break;
case "textBoxSTask":
tcd = lo.SelectTaskCodeNameData(textBoxSTask.Text, Convert.ToString(comboBoxOffice.SelectedValue));
if (tcd != null)
{
labelSTaskName.Text = tcd.TaskName;
}
break;
case "textBoxDTask":
tcd = lo.SelectTaskCodeNameData(textBoxDTask.Text, Convert.ToString(comboBoxOffice.SelectedValue));
if (tcd != null)
{
labelDTaskName.Text = tcd.TaskName;
}
break;
default:
break;
}
}
if ((e.Modifiers & Keys.Control) != Keys.Control)
{
return; // Ctrlキーが押下された時のみ以下処理
}
if (e.KeyCode == Keys.A)
{
switch (tb.Name)
{
case "textBoxItem":
chooseCostData();
if (String.IsNullOrEmpty(textBoxItem.Text))
{
labelItem.Text = "";
return;
}
tcas = setupSourceTaskCodeNameArray(dateTimePickerFr.Value, dateTimePickerTo.Value,
textBoxItem.Text, Convert.ToString(comboBoxOffice.SelectedValue), 0);
break;
case "textBoxSTask":
chooseTaskCodeNameData(((tcas == null) ? tcad : tcas), textBoxSTask, labelSTaskName);
//if ( tcas == null )
//{
// chooseTaskCodeNameData( tcad, textBoxSTask, labelSTaskName );
//}
//else
//{
// chooseTaskCodeNameData( tcas, textBoxSTask, labelSTaskName );
//}
break;
case "textBoxDTask":
chooseTaskCodeNameData(tcad, textBoxDTask, labelDTaskName);
break;
default:
break;
}
}
}
private void dispTaskCodeNameList(string officeCode, string department)
{
//string wParam = "";
//if (officeCode == "H")
//{
// switch (department)
// {
// case "1": // 設計
// wParam = " AND (LEFT(TaskCode, 1) = 'B' OR LEFT(TaskCode, 1) = 'C' OR LEFT(TaskCode, 1) = 'F')";
// break;
// case "2": // 測量
// wParam = " AND (LEFT(TaskCode, 1) = 'A' OR LEFT(TaskCode, 1) = 'E' OR LEFT(TaskCode, 1) = 'F')";
// break;
// default:
// wParam = " AND (LEFT(TaskCode, 1) = 'D' OR LEFT(TaskCode, 1) = 'F' OR LEFT(TaskCode, 1) = 'G' OR LEFT(TaskCode, 1) = 'Z')";
// break;
// }
//}
ListFormDataOp lo = new ListFormDataOp();
////tcd = lo.SelectTaskCodeNameData(officeCode);
//tcd = lo.SelectTaskCodeNameData(officeCode, wParam, 1);
tcd = lo.SelectTaskCodeNameData(officeCode, department, null);
if (tcd == null)
{
return;
}
dataGridView1.Rows.Clear();
//dataGridView1.Rows.Add(tcd.GetLength(0) - 1);
//if (tcd.GetLength(0) <= 1)
if (tcd.Length <= 1)
{
dataGridView1.Rows.Add(1);
}
else
{
//dataGridView1.Rows.Add(tcd.GetLength(0) - 1);
dataGridView1.Rows.Add(tcd.Length - 1);
}
TaskData td = new TaskData();
PartnersData pd = new PartnersData();
//for ( int i = 0; i < tcd.GetLength( 0 ); i++ )
for (int i = 0; i < tcd.Length; i++)
{
dataGridView1.Rows[i].Cells["TaskNo"].Value = tcd[i].TaskCode;
dataGridView1.Rows[i].Cells["Task"].Value = tcd[i].TaskName;
td = td.SelectTaskData(tcd[i].TaskID); //taskIDからtaskを読みPartnerとStartDate,EndDateを得る
if (td.TaskName == null)
{
return;
}
dataGridView1.Rows[i].Cells["Partner"].Value = pd.SelectPartnerName(td.PartnerCode);
dataGridView1.Rows[i].Cells["StartDate"].Value = (td.StartDate.StripTime()).ToString("yyyy年MM月dd日");
dataGridView1.Rows[i].Cells["EndDate"].Value = (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
}
seqNoReNumbering(dataGridView1, "TSeq");
checkExistingTaskData();
}
private void button_Click(object sender, EventArgs e)
{
Button btn = ( Button )sender;
if (btn.Name == "buttonClose")
{
this.Close();
return;
}
if (btn.Name == "buttonStoreMWorkItems")
{
if (formImpMWorkItems == null || formImpMWorkItems.IsDisposed)
{
formImpMWorkItems = new FormImpMWorkItems(hp);
formImpMWorkItems.Show();
}
else
{
MessageBox.Show(msgAlready);
}
return;
}
TaskEntryData itd = new TaskEntryData();
if (btn.Name == "buttonAdd")
{
//itd.OfficeCode = Convert.ToString( comboBoxOffice.SelectedValue );
//itd.Department = Convert.ToString( comboBoxDepartment.SelectedValue );
//itd.OfficeName = comboBoxOffice.Text;
//itd.DepartName = comboBoxDepartment.Text;
//labelTaskEntryID.Text = "";
}
else
{
if (labelTaskEntryID.Text == "" || labelTaskEntryID.Text == "0")
{
DMessage.DataNotEnough();
return;
}
itd = itd.SelectTaskEntryData(Convert.ToInt32(labelTaskEntryID.Text));
itd.MemberCode = hp.MemberCode;
itd.TaxRate = hp.TaxRate;
itd.AdminCostRate = hp.AdminCostRate;
itd.OthersCostRate = hp.OthersCostRate;
itd.Expenses = hp.Expenses;
itd.OfficeCode = Conv.OfficeCode;
itd.Department = Conv.DepartCode;
itd.PartnerName = labelPartner.Text;
}
switch (btn.Name)
{
case "buttonEstimate":
formEstimate = new FormEstimate(itd);
formEstimate.Show();
break;
case "buttonPlanning":
formPlanning = new FormPlanning(itd);
formPlanning.Show();
break;
case "buttonOsDetail":
formOutsource = new FormOutsource(itd);
formOutsource.Show();
break;
case "buttonContract":
formContract = new FormContract(itd);
formContract.Show();
break;
case "buttonRegular":
formRegular = new FormRegular(itd);
formRegular.Show();
break;
case "buttonVolumeInvoice":
formVolumeInvoice = new FormVolumeInvoice(itd);
formVolumeInvoice.Show();
break;
case "buttonInvoice":
formInvoice = new FormInvoice(itd);
formInvoice.Show();
break;
//case "buttonDetail":
// displayDetailLabel(ted);
// break;
case "buttonAdd":
itd.OfficeCode = Conv.OfficeCode;
itd.Department = Conv.DepartCode;
itd.OfficeName = Conv.Office;
itd.DepartName = Conv.Depart;
labelTaskEntryID.Text = "";
itd = FormTaskEntry.DispData(itd);
displayDetailLabel(itd);
comboBoxCostType.Text = itd.CostType;
textBoxTaskName.Text = itd.TaskName;
labelPartner.Text = itd.PartnerName;
labelTaskPlace.Text = itd.TaskPlace;
labelTaskCode.Text = itd.TaskCode;
labelTaskEntryID.Text = Convert.ToString(itd.TaskEntryID);
// ? 仮版 : 正式版
labelTaskName.Text = (labelTaskCode.Text.Trim() == "") ? "": itd.TaskName;
ListFormDataOp lo = new ListFormDataOp();
etcd = lo.SelectTaskEntryNameData(itd.OfficeCode, itd.Department, null);
buttonTask.Enabled = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false;
buttonTask.Visible = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false;
break;
case "buttonTask":
if (String.IsNullOrEmpty(textBoxTaskName.Text))
{
MessageBox.Show("対応する見積・計画用業務名がありません");
return;
}
tcds = FormTaskCodeNameList.ReceiveItems(tcd);
if (!writeTaskCodeToTaskEntryData())
{
return;
}
if (!displayTaskData(tcds))
{
return;
}
break;
default:
break;
}
}
private bool dispTaskInformation(string taskCode)
{
ListFormDataOp lo = new ListFormDataOp();
TaskCodeNameData tcnd = lo.SelectTaskCodeNameData(taskCode, Convert.ToString(comboBoxOffice.SelectedValue));
TaskData td = lo.SelectTaskData(taskCode);
if (td == null)
{
return(false);
}
textBoxTaskName.Text = td.TaskName;
labelTaskPlace.Text = td.TaskPlace;
labelStartDate.Text = (td.StartDate.StripTime()).ToString("yyyy年MM月dd日");
labelEndDate.Text = (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
labelSalesMCode.Text = td.SalesMCode;
DataTable dt;
DataRow dr;
SqlHandling sql;
if (td.PartnerCode != null)
{
sql = new SqlHandling("M_Partners");
if ((dt = sql.SelectAllData("WHERE PartnerCode = '" + td.PartnerCode + "'")) != null)
{
dr = dt.Rows[0];
labelPartnerName.Text = Convert.ToString(dr["PartnerName"]);
labelPartnerCode.Text = Convert.ToString(dr["PartnerCode"]);
}
}
// 20190302 asakawa
// add start
labelLeaderMName.Text = "";
labelSalesMName.Text = "";
// add end
//if (tcnd.LeaderMCode != null && tcnd.LeaderMCode != " ")
if (tcnd != null && tcnd.LeaderMCode != null && tcnd.LeaderMCode != " ")
{
sql = new SqlHandling("M_Members");
if ((dt = sql.SelectAllData("WHERE MemberCode = '" + tcnd.LeaderMCode + "'")) != null)
{
dr = dt.Rows[0];
labelLeaderMName.Text = Convert.ToString(dr["Name"]);
labelLeaderMCode.Text = tcnd.LeaderMCode;
}
}
if (td.SalesMCode != " ")
{
sql = new SqlHandling("M_Members");
if ((dt = sql.SelectAllData("WHERE MemberCode = '" + td.SalesMCode + "'")) != null)
{
dr = dt.Rows[0];
labelSalesMName.Text = Convert.ToString(dr["Name"]);
}
}
return(true);
}
/// <summary>
/// 現在保存している外注出来高データをDBから読取り表示する
/// </summary>
/// <param name="reportDate"></param>
/// <param name="costCode"></param>
/// <param name="officeCode"></param>
/// <param name="department"></param>
private void selectPaymentData(DataGridView dgv, DateTime reportDate, string officeCode, string department)
{
readyPro = true;
dgv.Enabled = true;
dgv.Rows.Clear();
dgv.Rows.Add(iniRCnt);
opd = new OsPaymentData();
DataTable dt = opd.SelectPayment(reportDate.EndOfMonth(), officeCode, department);
if (dt == null || dt.Rows.Count < 1)
{
labelMsg.Text = "表示できるデータはありません。";
seqNoReNumbering(dgv);
this.dataGridView1.CurrentCell = null;
readyPro = false;
return;
}
labelMsg.Text = "";
if (dt.Rows.Count > iniRCnt)
{
dgv.Rows.Add(dt.Rows.Count - iniRCnt + 5);
}
TaskData tdp = new TaskData();
ListFormDataOp lo = new ListFormDataOp();
DataRow dr;
string taskCode;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (i == 0)
{
string[] ckItems = new string[] { "AdminCheck", "DirectorCheck", "PresidentCheck" };
string[] dtItems = new string[] { "ACheckDate", "DCheckDate", "PCheckDate" };
for (int j = 0; j < ckItems.Length; j++)
{
int checkStat = Convert.ToInt32(dr[ckItems[j]]);
ckArray[j].Checked = (checkStat == 1) ? true : false;
dtArray[j] = (checkStat == 1) ? Convert.ToDateTime(dr[dtItems[j]]) : DateTime.MinValue;
lbArray[j].Text = (checkStat == 1) ? dtArray[j].ToLongDateString() : "";
}
if (ckArray[2].Checked)
{
buttonDisEnabled();
}
else if (ckArray[1].Checked)
{
buttonDisEnabled();
buttonCost.Enabled = true;
}
else if (ckArray[0].Checked)
{
buttonEnabled();
buttonCost.Enabled = false;
}
}
dgv.Rows[i].Cells["ItemCode"].Value = Convert.ToString(dr["ItemCode"]);
dgv.Rows[i].Cells["Item"].Value = Convert.ToString(dr["Item"]);
dgv.Rows[i].Cells["OrderNo"].Value = Convert.ToString(dr["OrderNo"]);
taskCode = Convert.ToString(dr["TaskCode"]);
dgv.Rows[i].Cells["TaskCode"].Value = taskCode;
if (Convert.ToString(dr["OrderAmount"]) == "" || Convert.ToString(dr["OrderAmount"]) == "0.00")
{
dgv.Rows[i].Cells["OAmount"].Value =
opd.SelectOAmountPayment(Convert.ToString(dr["ItemCode"]), taskCode, Conv.OfficeCode, Conv.DepartCode, dateTimePickerEx1.Value);
}
else
{
dgv.Rows[i].Cells["OAmount"].Value = Convert.ToDecimal(dr["OrderAmount"]);
}
dgv.Rows[i].Cells["SAmount"].Value =
opd.SelectSumAmountPayment(Convert.ToString(dr["ItemCode"]), taskCode, Conv.OfficeCode, Conv.DepartCode, dateTimePickerEx1.Value);
dgv.Rows[i].Cells["Amount"].Value = Convert.ToDecimal(dr["Amount"]);
calculateInvolvedItems(dgv.Rows[i]);
dgv.Rows[i].Cells["LeaderMCode"].Value = Convert.ToString(dr["LeaderMCode"]);
dgv.Rows[i].Cells["SlipNo"].Value = Convert.ToInt32(dr["SlipNo"]) == 0 ? "" : Convert.ToString(dr["SlipNo"]);
dgv.Rows[i].Cells["CostReportID"].Value = Convert.ToInt32(dr["CostReportID"]) == 0 ? "" : Convert.ToString(dr["CostReportID"]);
dgv.Rows[i].Cells["PaymentID"].Value = Convert.ToString(dr["OsPaymentID"]);
dgv.Rows[i].Cells["Check"].Value = false;
TaskCodeNameData tcnd = lo.SelectTaskCodeNameData(taskCode, Conv.OfficeCode);
if (tcnd != null)
{
dgv.Rows[i].Cells["TaskName"].Value = tcnd.TaskName;
tdp = tdp.SelectTaskData(taskCode);
dgv.Rows[i].Cells["SalesMCode"].Value = "0" + tdp.SalesMCode;
dgv.Rows[i].Cells["PartnerCode"].Value = tdp.PartnerCode;
}
}
seqNoReNumbering(dgv);
this.dataGridView1.CurrentCell = null;
readyPro = false;
}
/// <summary>
/// データグリッドビュー変更処理
/// </summary>
/// <param name="TargetPoint"></param>
private void DataGridViewChange(Point TargetPoint)
{
DataGridViewRow TargetdgvRow = this.dataGridViewList.Rows[TargetPoint.Y];
switch (TargetPoint.X)
{
// Wakamatsu 20170302
case 2: // 原価コード
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[2].Value = CostKey.CostCodeH + CostKey.CostCodeNum;
TargetdgvRow.Dispose();
return;
}
// 入力確認
string CheckCodeU = Convert.ToString(TargetdgvRow.Cells[2].Value).ToUpper();
string CheckResult = CostCodeCheck(CheckCodeU, TargetPoint.Y);
if (CheckResult != "")
{
MessageBox.Show(CheckResult);
TargetdgvRow.Cells[2].Value = CostKey.CostCodeH + CostKey.CostCodeNum;
TargetdgvRow.Dispose();
return;
}
TargetdgvRow.Cells[1].Value = CheckCodeU.Substring(0, 1);
TargetdgvRow.Cells[2].Value = CheckCodeU;
string CheckCodeH = "";
if (CostKey.CostCodeH == "A" || CostKey.CostCodeH == "B")
{
if (CostKey.CostCodeH == "A")
{
CheckCodeH = "B";
}
else
{
CheckCodeH = "A";
}
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A" || Convert.ToString(TargetdgvRow.Cells[1].Value) == "B")
{
// 変更前も変更後も原価コードの先頭文字列が"A"または"B"の場合
for (int i = 0; i < this.dataGridViewList.Rows.Count; i++)
{
if (Convert.ToString(this.dataGridViewList.Rows[i].Cells[2].Value) == CheckCodeH + CostKey.CostCodeNum &&
Convert.ToString(this.dataGridViewList.Rows[i].Cells[7].Value) == CostKey.MemberCode)
{
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A")
{
CheckCodeH = "B";
}
else
{
CheckCodeH = "A";
}
this.dataGridViewList.Rows[i].Cells[1].Value = CheckCodeH;
this.dataGridViewList.Rows[i].Cells[2].Value = CheckCodeH + Convert.ToString(TargetdgvRow.Cells[2].Value).Substring(1);
}
}
}
else
{
// 変更前の原価コードの先頭文字列が"A"または"B"で変更後の原価コードの先頭文字列が"A"または"B"でない場合
for (int i = 0; i < this.dataGridViewList.Rows.Count; i++)
{
if (Convert.ToString(this.dataGridViewList.Rows[i].Cells[2].Value) == CheckCodeH + CostKey.CostCodeNum &&
Convert.ToString(this.dataGridViewList.Rows[i].Cells[7].Value) == CostKey.MemberCode)
{
this.dataGridViewList.Rows.RemoveAt(i);
}
}
TargetdgvRow.Cells[7].Value = "";
}
}
else
{
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A" || Convert.ToString(TargetdgvRow.Cells[1].Value) == "B")
{
// 変更前の原価コードの先頭文字列が"A"または"B"でなく変更後の原価コードの先頭文字列が"A"または"B"場合
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A")
{
CheckCodeH = "B";
}
else
{
CheckCodeH = "A";
}
TargetdgvRow.Cells[3].Value = "";
TargetdgvRow.Cells[6].Value = CheckDecimal("0");
TargetdgvRow.Cells[7].Value = "";
TargetdgvRow.Cells[10].Value = "[原価名称]を入力してください。";
this.dataGridViewList.Rows.Insert(TargetPoint.Y + 1);
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[1].Value = CheckCodeH;
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[2].Value = CheckCodeH + Convert.ToString(TargetdgvRow.Cells[2].Value).Substring(1);
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[3].Value = "";
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[6].Value = CheckDecimal("0");
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[7].Value = "";
this.dataGridViewList.Rows[TargetPoint.Y + 1].Cells[10].Value = "[原価名称]を入力してください。";
}
}
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "K")
{
if (Convert.ToString(TargetdgvRow.Cells[3].Value) == "" || Convert.ToString(TargetdgvRow.Cells[3].Value) == CODEL)
{
TargetdgvRow.Cells[3].Value = CODEK;
}
}
else if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "L" && Convert.ToString(TargetdgvRow.Cells[3].Value) == "")
{
if (Convert.ToString(TargetdgvRow.Cells[3].Value) == "" || Convert.ToString(TargetdgvRow.Cells[3].Value) == CODEK)
{
TargetdgvRow.Cells[3].Value = CODEL;
}
}
break;
// Wakamatsu 20170302
case 3: // 原価名称
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[3].Value = CostKey.CostName;
TargetdgvRow.Dispose();
return;
}
if (Convert.ToString(TargetdgvRow.Cells[3].Value) == "")
{
// 社員番号を空欄とする
TargetdgvRow.Cells[7].Value = "";
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A" ||
Convert.ToString(TargetdgvRow.Cells[1].Value) == "B")
{
// 対となる原価コード変更
PairCostControl("", "");
}
}
else
{
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "A" ||
Convert.ToString(TargetdgvRow.Cells[1].Value) == "B")
{
// 原価名称編集後
ListFormDataOp lo = new ListFormDataOp();
// メンバー取得
MembersScData[] msdl = lo.SelectMembersScData(Convert.ToString(TargetdgvRow.Cells[3].Value), 0);
MembersScData msd = null;
if (msdl != null)
{
msd = FormMembersList.ReceiveItems(msdl);
}
if (msd == null)
{
// 選択されなかった場合
msd = new MembersScData();
msd.Name = "";
msd.MemberCode = "";
TargetdgvRow.Cells[3].Value = msd.Name;
TargetdgvRow.Cells[7].Value = msd.MemberCode;
}
else
{
// 選択された社員情報を格納
TargetdgvRow.Cells[3].Value = msd.Name;
TargetdgvRow.Cells[7].Value = msd.MemberCode;
string OverlapCode = ""; // 重複原価コード格納用
string[] OverlapCodeList; // 重複原価コード格納用(配列)
bool OverlapFlag = false; // 重複社員番号フラグ
// 選択された場合
for (int i = 0; i < this.dataGridViewList.Rows.Count; i++)
{
if (Convert.ToString(this.dataGridViewList.Rows[i].Cells[1].Value) == "A" ||
Convert.ToString(this.dataGridViewList.Rows[i].Cells[1].Value) == "B")
{
// 原価コードが"A"または"B"の場合
if (Convert.ToString(this.dataGridViewList.Rows[i].Cells[7].Value) == msd.MemberCode)
{
// 社員番号が同じ場合
OverlapCode += Convert.ToString(this.dataGridViewList.Rows[i].Cells[2].Value) + ",";
}
}
}
// 社員番号重複確認
if (OverlapCode.Length != 0)
{
// 末尾の","を外す
OverlapCode = OverlapCode.Substring(0, OverlapCode.Length - 1);
}
OverlapCodeList = OverlapCode.Split(',');
if (OverlapCodeList.Length == 2)
{
// 社員番号の重複が2つの場合
if (OverlapCodeList[0].Substring(0, 1) == OverlapCodeList[1].Substring(0, 1))
{
// 社員番号が重複している行の原価コードの先頭が同じ場合登録不可
OverlapFlag = true;
}
else if (OverlapCodeList[0].Substring(1) != OverlapCodeList[1].Substring(1))
{
// 社員番号が重複している行の原価コードの先頭以外が異なる場合登録不可
OverlapFlag = true;
}
}
else if (OverlapCodeList.Length > 2)
{
// 社員番号が重複している行が３行以上の場合登録不可
OverlapFlag = true;
}
if (OverlapFlag == true)
{
MessageBox.Show("原価コード:" + Convert.ToString(TargetdgvRow.Cells[2].Value) + "\r\n" +
"原価名称:" + Convert.ToString(TargetdgvRow.Cells[3].Value) + "\r\n" +
"すでに登録されている社員番号です。");
TargetdgvRow.Cells[3].Value = "";
TargetdgvRow.Cells[7].Value = "";
msd.Name = "";
msd.MemberCode = "";
}
}
if (Convert.ToString(TargetdgvRow.Cells[1].Value) == "B" && msd.Name != "")
{
TargetdgvRow.Cells[3].Value += CODEB;
}
// 対となる原価コード変更
PairCostControl(msd.Name, msd.MemberCode);
}
}
// 変更確認
if (Convert.ToString(TargetdgvRow.Cells[3].Value) != CostKey.CostName)
{
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[9].Value = "U";
}
}
break;
case 4: // 細別
// 変更確認
if (Convert.ToString(TargetdgvRow.Cells[4].Value) != CostKey.CostDetail)
{
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[9].Value = "U";
}
}
break;
case 5: // 単位
// 変更確認
if (Convert.ToString(TargetdgvRow.Cells[5].Value) != CostKey.CostUnit)
{
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[9].Value = "U";
}
}
break;
case 6: // 原価
TargetdgvRow.Cells[6].Value = CheckDecimal(Convert.ToString(TargetdgvRow.Cells[6].Value));
// 変更確認
if (Convert.ToString(TargetdgvRow.Cells[6].Value) != CostKey.SetCost)
{
if (Convert.ToString(TargetdgvRow.Cells[9].Value) != "I")
{
TargetdgvRow.Cells[9].Value = "U";
}
}
break;
default: // その他
break;
}
// 入力確認
InputCheck(TargetPoint.Y);
TargetdgvRow.Dispose();
}
