//----------------------------------------------------------------------------//
// Property //
//----------------------------------------------------------------------------//
//----------------------------------------------------------------------------//
// Method //
//----------------------------------------------------------------------------//
private void FormReview_Load(object sender, EventArgs e)
{
UiHandling uih = new UiHandling(dataGridView1);
uih.DgvReadyNoRHeader();
//並び替えができないようにする
uih.NoSortable();
uih.DgvColumnsWidth(85);
uih.DgvColumnsWidth(0, 90);
dataGridView1.Rows.Add(iniRCnt);
uih.DgvRowsHeight(26);
uih.DgvRowsReadOnly(readOnlyRows, Color.PaleGreen);
uih.DgvRowsReadOnly(readOnlyRowsW, Color.White);
uih.DgvColumnsReadOnly(readOnlyCells, Color.PaleGreen);
create_cbOffice();
create_cbDepart();
create_cbYM();
setColumnLimitter();
setViewData(dataGridView1);
}
private void editAndView(DataGridView dgv, string officeCode, string department)
{
StringUtility su = new StringUtility();
TaskData[] tdWkA = new TaskData[tdA.Length];
MembersData mbd = new MembersData();
int j = 0;
for (int i = 0; i < tdA.Length; i++)
{
//mbd = new MembersData();
//mbd = mbd.SelectMembersDataAll( tdA[i].SalesMCode );
//if( mbd == null ) continue;
//if( mbd.OfficeCode == officeCode && mbd.Department == department )
//{
// tdWkA[j] = new TaskData();
// tdWkA[j] = ( TaskData )tdA[i].Clone();
// j++;
//}
string wkoffice = su.SubstringByte(tdA[i].TaskBaseCode, 2, 1);
if (su.SubstringByte(tdA[i].TaskBaseCode, 2, 1) == officeCode)
{
tdWkA[j] = new TaskData();
tdWkA[j] = ( TaskData )tdA[i].Clone();
j++;
}
}
TaskData[] tdArray = new TaskData[j];
for (int i = 0; i < j; i++)
{
tdArray[i] = new TaskData();
tdArray[i] = ( TaskData )tdWkA[i].Clone();
}
MembersData[] mbdA = mbd.SelectMembersDataAll();
if (mbdA == null)
{
return;
}
string[] mCodeArray = new string[mbdA.Length];
string[] mNameArray = new string[mbdA.Length];
for (int i = 0; i < mbdA.Length; i++)
{
mCodeArray[i] = mbdA[i].MemberCode.TrimEnd();
mNameArray[i] = mbdA[i].Name.TrimEnd();
}
UiHandling uih = new UiHandling(dgv);
uih.DgvRowsHeight(26);
dataGridView1.Rows.Add(tdArray.Length);
for (int i = 0; i < tdArray.Length; i++)
{
dgv.Rows[i].Cells["SeqNo"].Value = i + 1;
dgv.Rows[i].Cells["TaskCode"].Value = selTaskCode(tdArray[i], officeCode, department);
dgv.Rows[i].Cells["TaskName"].Value = tdArray[i].TaskName;
dgv.Rows[i].Cells["VersionNo"].Value = tdArray[i].VersionNo;
dgv.Rows[i].Cells["IssueDate"].Value = (string.IsNullOrEmpty(Convert.ToString(tdArray[i].IssueDate))) ? "" : tdArray[i].IssueDate.ToShortDateString();
if (tdArray[i].SalesMCode.Trim() == "00")
{
tdArray[i].SalesMCode = null;
}
dgv.Rows[i].Cells["SalesMName"].Value = (string.IsNullOrEmpty(tdArray[i].SalesMCode)) ? "" : mNameArray[Array.IndexOf(mCodeArray, tdArray[i].SalesMCode.TrimEnd())];
dgv.Rows[i].Cells["SalesMInputDate"].Value = (string.IsNullOrEmpty(Convert.ToString(tdArray[i].SalesMInputDate))) ? "" : tdArray[i].SalesMInputDate.ToShortDateString();
dgv.Rows[i].Cells["Approval"].Value = (string.IsNullOrEmpty(tdArray[i].Approval)) ? "" : mNameArray[Array.IndexOf(mCodeArray, tdArray[i].Approval.TrimEnd())];
dgv.Rows[i].Cells["ApprovalDate"].Value = (string.IsNullOrEmpty(Convert.ToString(tdArray[i].ApprovalDate))) ? "" : tdArray[i].ApprovalDate.ToShortDateString();
dgv.Rows[i].Cells["MakeOrder"].Value = (string.IsNullOrEmpty(tdArray[i].Approval)) ? "" : mNameArray[Array.IndexOf(mCodeArray, tdArray[i].MakeOrder.TrimEnd())];
dgv.Rows[i].Cells["MakeOrderDate"].Value = (string.IsNullOrEmpty(Convert.ToString(tdArray[i].MakeOrderDate))) ? "" : tdArray[i].MakeOrderDate.ToShortDateString();
dgv.Rows[i].Cells["ConfirmAdm"].Value = (string.IsNullOrEmpty(tdArray[i].MakeOrder)) ? "" : mNameArray[Array.IndexOf(mCodeArray, tdArray[i].ConfirmAdm.TrimEnd())];
dgv.Rows[i].Cells["ConfirmDate"].Value = (string.IsNullOrEmpty(Convert.ToString(tdArray[i].ConfirmDate))) ? "" : tdArray[i].ConfirmDate.ToShortDateString();
}
rowCount = tdArray.Length;
labelMsg.Text = comboBoxOffice.Text + "発行の業務引継書で承認が未完了のものを表示しました。";
}
private void editAndView(DataGridView dgv)
{
// 社員番号、名テーブル作成
MembersData mbd = new MembersData();
MembersData[] mbdA = mbd.SelectMembersDataAll();
if (mbdA == null)
{
return;
}
string[] mCodeArray = new string[mbdA.Length];
string[] mNameArray = new string[mbdA.Length];
for (int i = 0; i < mbdA.Length; i++)
{
mCodeArray[i] = mbdA[i].MemberCode.TrimEnd();
mNameArray[i] = mbdA[i].Name.TrimEnd();
}
// GridView Row設定
UiHandling uih = new UiHandling(dgv);
uih.DgvRowsHeight(26);
dataGridView1.Rows.Add(pdA.Length);
// GirdViewデータ移送
for (int i = 0; i < pdA.Length; i++)
{
dgv.Rows[i].Cells["SeqNo"].Value = i + 1;
dgv.Rows[i].Cells["TaskCode"].Value = (string.IsNullOrEmpty(pdA[i].TaskCode)) ? "" : pdA[i].TaskCode;
dgv.Rows[i].Cells["TaskName"].Value = pdA[i].TaskName;
dgv.Rows[i].Cells["VersionNo"].Value = pdA[i].VersionNo;
if (pdA[i].CreateStat == 1)
{
dgv.Rows[i].Cells["CreateMName"].Value = (string.IsNullOrEmpty(pdA[i].CreateMCd)) ? "" : mNameArray[Array.IndexOf(mCodeArray, pdA[i].CreateMCd.TrimEnd())];
dgv.Rows[i].Cells["CreateDate"].Value = (string.IsNullOrEmpty(Convert.ToString(pdA[i].CreateDate))) ? "" : pdA[i].CreateDate.ToShortDateString();
}
if (pdA[i].ConfirmStat == 1)
{
dgv.Rows[i].Cells["ConfirmMName"].Value = (string.IsNullOrEmpty(pdA[i].ConfirmMCd)) ? "" : mNameArray[Array.IndexOf(mCodeArray, pdA[i].ConfirmMCd.TrimEnd())];
dgv.Rows[i].Cells["ConfirmDate"].Value = (string.IsNullOrEmpty(Convert.ToString(pdA[i].ConfirmDate))) ? "" : pdA[i].ConfirmDate.ToShortDateString();
}
if (pdA[i].ScreeningStat == 1)
{
dgv.Rows[i].Cells["ScreeningMName"].Value = (string.IsNullOrEmpty(pdA[i].ScreeningMCd)) ? "" : mNameArray[Array.IndexOf(mCodeArray, pdA[i].ScreeningMCd.TrimEnd())];
dgv.Rows[i].Cells["ScreeningDate"].Value = (string.IsNullOrEmpty(Convert.ToString(pdA[i].ScreeningDate))) ? "" : pdA[i].ScreeningDate.ToShortDateString();
}
if (pdA[i].ApOfficerStat == 1)
{
dgv.Rows[i].Cells["ApOfficerMName"].Value = (string.IsNullOrEmpty(pdA[i].ApOfficerMCd)) ? "" : mNameArray[Array.IndexOf(mCodeArray, pdA[i].ApOfficerMCd.TrimEnd())];
dgv.Rows[i].Cells["ApOfficerDate"].Value = (string.IsNullOrEmpty(Convert.ToString(pdA[i].ApOfficerDate))) ? "" : pdA[i].ApOfficerDate.ToShortDateString();
}
if (pdA[i].ApPresidentStat == 1)
{
dgv.Rows[i].Cells["ApPresidentMName"].Value = (string.IsNullOrEmpty(pdA[i].ApPresidentMCd)) ? "" : mNameArray[Array.IndexOf(mCodeArray, pdA[i].ApPresidentMCd.TrimEnd())];
dgv.Rows[i].Cells["ApPresidentDate"].Value = (string.IsNullOrEmpty(Convert.ToString(pdA[i].ApPresidentDate))) ? "" : pdA[i].ApPresidentDate.ToShortDateString();
}
}
labelMsg.Text = comboBoxOffice.Text + "発行の実行予算書で承認が未完了のものを表示しました。";
}