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