//-----------------------------------------------//
// Property
//-----------------------------------------------//
//-----------------------------------------------//
// Method
//-----------------------------------------------//
private void FormCostDetail_Load(object sender, EventArgs e)
{
// DataGridViewの列タイトル設定
UiHandling ui = new UiHandling(dataGridView1);
ui.DgvColumnName(2, cif.EditColumnNameArray(cif.Class0, cif.Class1));
ui.DgvColumnHeader(2, cif.EditColumnHeaderArray(cif.Class0, cif.Class1));
//原価計上日
labelFrom.Text = cif.DateSOP.ToString("yyyy/MM/dd");
labelTo.Text = cif.DateEOP.ToString("yyyy/MM/dd");
//明細表
labelType.Text = cif.ClassificationItem;
//出力範囲
labelRange.Text = cif.OutputRange;
labelOffice.Text = cif.Office;
// データ読み込み
string strSql = " D_CR.ReportDate AS ReportDate, D_CR.SlipNo AS SlipNo, D_CR.TaskCode AS TaskCode, SUBSTRING(D_CR.TaskCode, 2, 6) AS TaskBaseCode, D_CR.ItemCode AS ItemCode, D_CR.Quantity AS Quantity,"
+ " D_CR.Unit AS Unit, D_CR.UnitPrice AS UnitPrice, D_CR.Cost AS Cost ,D_T.PartnerCode AS CustoCode, "
+ " CASE WHEN LEN(ISNULL(D_CR.LeaderMCode, '')) < 3 THEN RIGHT('00' + RTRIM(ISNULL(D_CR.LeaderMCode, '')), 3) ELSE ISNULL(D_CR.LeaderMCode, '') END AS LeaderMCode, "
+ " CASE WHEN LEN(ISNULL(D_CR.SalesMCode, '')) < 3 THEN RIGHT('00' + RTRIM(ISNULL(D_CR.SalesMCode, '')), 3) ELSE ISNULL(D_CR.SalesMCode, '') END AS SalesMCode, "
//+ " M_C.CostCode AS CostCode, M_C.Item AS Item FROM D_CostReport AS D_CR "
+ " M_C.CostCode AS CostCode, D_CR.Item AS Item FROM D_CostReport AS D_CR "
+ " LEFT JOIN M_Cost AS M_C ON D_CR.ItemCode = M_C.CostCode AND D_CR.OfficeCode = M_C.OfficeCode "
+ " LEFT JOIN D_Task AS D_T ON D_T.TaskBaseCode = SUBSTRING(D_CR.TaskCode, 2, 6) ";
strSql = strSql + cif.WherePhraseDate;
displayDetailInformation(dataGridView1, strSql);
}
//-----------------------------------------------//
// Property
//-----------------------------------------------//
//-----------------------------------------------//
// Method
//-----------------------------------------------//
private void FormCostSummary_Load(object sender, EventArgs e)
{
// DataGridViewの列タイトル設定
UiHandling ui = new UiHandling(dataGridView1);
// Wakamatsu 20170316
string[] nTextArray = cif.EditColumnHeaderArraySummary(cif.Class0, cif.Class1, cif.Class2);
//ui.DgvColumnName(0, cif.EditColumnNameArraySummary(cif.Class0, cif.Class1, cif.Class2));
//ui.DgvColumnHeader(0, cif.EditColumnHeaderArraySummary(cif.Class0, cif.Class1, cif.Class2));
ui.DgvColumnHeader(0, nTextArray);
int VisibleCount = 0;
for (int i = 0; i < nTextArray.Length; i++)
{
if (nTextArray[i] == "")
{
this.dataGridView1.Columns[i].Visible = false;
}
else
{
VisibleCount++;
}
}
switch (VisibleCount)
{
case 0:
this.dataGridView1.Columns[0].Visible = true;
this.dataGridView1.Columns[0].Width = 980;
TotalColumns = 0;
break;
case 1:
for (int i = 0; i < nTextArray.Length; i++)
{
if (this.dataGridView1.Columns[i].Visible == true)
{
this.dataGridView1.Columns[i].Width = 980;
TotalColumns = i;
}
}
break;
case 2:
for (int i = 0; i < nTextArray.Length; i++)
{
if (this.dataGridView1.Columns[i].Visible == true)
{
this.dataGridView1.Columns[i].Width = 490;
TotalColumns = i;
}
}
break;
case 3:
this.dataGridView1.Columns[0].Width = 340;
this.dataGridView1.Columns[1].Width = 320;
this.dataGridView1.Columns[2].Width = 320;
TotalColumns = 2;
break;
default:
break;
}
// Wakamatsu 20170316
//原価計上日
labelFrom.Text = cif.DateSOP.ToString("yyyy/MM/dd");
labelTo.Text = cif.DateEOP.ToString("yyyy/MM/dd");
//明細表
labelType.Text = cif.ClassificationItem;
//出力範囲
labelRange.Text = cif.OutputRange;
labelOffice.Text = cif.Office;
// データ読み込み
displayDetailInformation(dataGridView1, cif.SqlStr);
}
