protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.ToolTip = "Click to select this row.";
e.Row.Attributes["onclick"] = Page.ClientScript.GetPostBackClientHyperlink(GridView1, "Select$" + e.Row.RowIndex);
int line = int.Parse(e.Row.Cells[0].Text);
int lineNew = line + 7;
if (line >= 44)
{
e.Row.Cells[0].Text = lineNew.ToString();
}
if (!input_BLL.InputDay_CheckRSbyLine(line, planid))
{
for (int i = 1; i < 21; i++)
{
e.Row.Cells[i].Text = "";
}
e.Row.Cells[21].Text = "-";
}
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
string color;
if (ddlShift.SelectedValue.Equals("Day"))
//DAY
#region Day
{
LineColorDay_BLL colorLine = new LineColorDay_BLL();
LineInputDay lineStocking = new LineInputDay();
lineStocking = inputDay_BLL.InputDay_GetStocking(planid);
stockingPosition = lineStocking.line;
if (e.Row.RowType == DataControlRowType.Footer)
{
int index = GridView1.Rows.Count;
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Footer, DataControlRowState.Normal);
TableCell cell = new TableCell();
cell.Text = "Stocking:";
cell.ColumnSpan = 4;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "-";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "-";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.plan.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.actual.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.diff.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.target.ToString();
row.Cells.Add(cell);
cell = new TableCell();
float actualrateStocking = 0;
if (lineStocking.target != 0)
{
actualrateStocking = (float)lineStocking.actual / lineStocking.target * 100;
}
cell.Text = actualrateStocking.ToString("F1") + "%";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h07.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color07H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h08.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color08H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h09.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color09H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h10.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color10H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h11.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color11H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h12.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color12H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h13.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color13H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h14.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color14H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h15.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color15H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h16.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color16H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h17.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color17H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h18.ToString();
cell.BackColor = setColor(colorLine.getColorDayByColum("Color18H", stockingPosition, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.comment.ToString();
row.Cells.Add(cell);
GridView1.Controls[0].Controls.Add(row);
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
int line = int.Parse(e.Row.Cells[0].Text);
int lineNew = line + 7;
if (line >= 44)
{
e.Row.Cells[0].Text = lineNew.ToString();
}
if (inputDay_BLL.InputDay_CheckRSbyLine(line, planid))
{
if (!e.Row.Cells[4].Text.Equals(""))
{
totalPW += common.ConvertInt(e.Row.Cells[4].Text);
}
if (!e.Row.Cells[5].Text.Equals(""))
{
totalAW += common.ConvertInt(e.Row.Cells[5].Text);
}
if (!e.Row.Cells[6].Text.Equals(""))
{
totalPl += common.ConvertInt(e.Row.Cells[6].Text);
}
if (!e.Row.Cells[7].Text.Equals(""))
{
totalAC += common.ConvertInt(e.Row.Cells[7].Text);
}
if (!e.Row.Cells[8].Text.Equals(""))
{
totalDiff += common.ConvertInt(e.Row.Cells[8].Text);
}
if (!e.Row.Cells[9].Text.Equals(""))
{
totalTarget += common.ConvertInt(e.Row.Cells[9].Text);
}
if (!e.Row.Cells[11].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color07H", line, planid);
e.Row.Cells[11].BackColor = setColor(color);
total7 += common.ConvertInt(e.Row.Cells[11].Text);
}
if (!e.Row.Cells[12].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color08H", line, planid);
e.Row.Cells[12].BackColor = setColor(color);
total8 += common.ConvertInt(e.Row.Cells[12].Text);
}
if (!e.Row.Cells[13].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color09H", line, planid);
e.Row.Cells[13].BackColor = setColor(color);
total9 += common.ConvertInt(e.Row.Cells[13].Text);
}
if (!e.Row.Cells[14].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color10H", line, planid);
e.Row.Cells[14].BackColor = setColor(color);
total10 += common.ConvertInt(e.Row.Cells[14].Text);
}
if (!e.Row.Cells[15].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color11H", line, planid);
e.Row.Cells[15].BackColor = setColor(color);
total11 += common.ConvertInt(e.Row.Cells[15].Text);
}
if (!e.Row.Cells[16].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color12H", line, planid);
e.Row.Cells[16].BackColor = setColor(color);
total12 += common.ConvertInt(e.Row.Cells[16].Text);
}
if (!e.Row.Cells[17].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color13H", line, planid);
e.Row.Cells[17].BackColor = setColor(color);
total13 += common.ConvertInt(e.Row.Cells[17].Text);
}
if (!e.Row.Cells[18].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color14H", line, planid);
e.Row.Cells[18].BackColor = setColor(color);
total14 += common.ConvertInt(e.Row.Cells[18].Text);
}
if (!e.Row.Cells[19].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color15H", line, planid);
e.Row.Cells[19].BackColor = setColor(color);
total15 += common.ConvertInt(e.Row.Cells[19].Text);
}
if (!e.Row.Cells[20].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color16H", line, planid);
e.Row.Cells[20].BackColor = setColor(color);
total16 += common.ConvertInt(e.Row.Cells[20].Text);
}
if (!e.Row.Cells[21].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color17H", line, planid);
e.Row.Cells[21].BackColor = setColor(color);
total17 += common.ConvertInt(e.Row.Cells[21].Text);
}
if (!e.Row.Cells[22].Text.Equals(""))
{
color = colorLine.getColorDayByColum("Color18H", line, planid);
e.Row.Cells[22].BackColor = setColor(color);
total18 += common.ConvertInt(e.Row.Cells[22].Text);
}
if (e.Row.Cells[23].Text.Trim().Equals("Run"))
{
e.Row.Cells[23].Text = "R";
e.Row.Cells[23].BackColor = Color.FromArgb(0, 204, 0);
}
else if (e.Row.Cells[23].Text.Trim().Equals("Stop"))
{
e.Row.Cells[23].Text = "S";
e.Row.Cells[23].BackColor = Color.Red;
}
}
else
{
for (int i = 1; i < 23; i++)
{
e.Row.Cells[i].Text = "";
}
e.Row.Cells[23].Text = "-";
}
}
}
#endregion
else
//Night
#region Night
{
LineColorNight_BLL colorLine = new LineColorNight_BLL();
LineInputNight lineStocking = new LineInputNight();
lineStocking = inputNight_BLL.InputNight_GetStocking(planid);
if (e.Row.RowType == DataControlRowType.Footer)
{
int index = GridView1.Rows.Count;
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Footer, DataControlRowState.Normal);
TableCell cell = new TableCell();
cell.Text = "Stocking:";
cell.ColumnSpan = 4;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "-";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "-";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.plan.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.actual.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.diff.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.target.ToString();
row.Cells.Add(cell);
cell = new TableCell();
float actualrateStocking = 0;
if (lineStocking.target != 0)
{
actualrateStocking = (float)lineStocking.actual / lineStocking.target * 100;
}
cell.Text = actualrateStocking.ToString("F1") + "%";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h19.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color19H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h20.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color20H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h21.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color21H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h22.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color22H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h23.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color23H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h00.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color00H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h01.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color01H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h02.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color02H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h03.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color03H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h04.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color04H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h05.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color05H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.h06.ToString();
cell.BackColor = setColor(colorLine.getColorNightByColum("Color06H", 39, planid));
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = lineStocking.comment.ToString();
row.Cells.Add(cell);
GridView1.Controls[0].Controls.Add(row);
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
int line = int.Parse(e.Row.Cells[0].Text);
int lineNew = line + 7;
if (line >= 44)
{
e.Row.Cells[0].Text = lineNew.ToString();
}
if (inputNight_BLL.InputNight_CheckRSbyLine(line, planid))
{
if (!e.Row.Cells[4].Text.Equals(""))
{
totalPW += common.ConvertInt(e.Row.Cells[4].Text);
}
if (!e.Row.Cells[5].Text.Equals(""))
{
totalAW += common.ConvertInt(e.Row.Cells[5].Text);
}
if (!e.Row.Cells[6].Text.Equals(""))
{
totalPl += common.ConvertInt(e.Row.Cells[6].Text);
}
if (!e.Row.Cells[7].Text.Equals(""))
{
totalAC += common.ConvertInt(e.Row.Cells[7].Text);
}
if (!e.Row.Cells[8].Text.Equals(""))
{
totalDiff += common.ConvertInt(e.Row.Cells[8].Text);
}
if (!e.Row.Cells[9].Text.Equals(""))
{
totalTarget += common.ConvertInt(e.Row.Cells[9].Text);
}
if (!e.Row.Cells[11].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color19H", line, planid);
e.Row.Cells[11].BackColor = setColor(color);
total19 += common.ConvertInt(e.Row.Cells[11].Text);
}
if (!e.Row.Cells[12].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color20H", line, planid);
e.Row.Cells[12].BackColor = setColor(color);
total20 += common.ConvertInt(e.Row.Cells[12].Text);
}
if (!e.Row.Cells[13].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color21H", line, planid);
e.Row.Cells[13].BackColor = setColor(color);
total21 += common.ConvertInt(e.Row.Cells[13].Text);
}
if (!e.Row.Cells[14].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color22H", line, planid);
e.Row.Cells[14].BackColor = setColor(color);
total22 += common.ConvertInt(e.Row.Cells[14].Text);
}
if (!e.Row.Cells[15].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color23H", line, planid);
e.Row.Cells[15].BackColor = setColor(color);
total23 += common.ConvertInt(e.Row.Cells[15].Text);
}
if (!e.Row.Cells[16].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color00H", line, planid);
e.Row.Cells[16].BackColor = setColor(color);
total0 += common.ConvertInt(e.Row.Cells[16].Text);
}
if (!e.Row.Cells[17].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color01H", line, planid);
e.Row.Cells[17].BackColor = setColor(color);
total1 += common.ConvertInt(e.Row.Cells[17].Text);
}
if (!e.Row.Cells[18].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color02H", line, planid);
e.Row.Cells[18].BackColor = setColor(color);
total2 += common.ConvertInt(e.Row.Cells[18].Text);
}
if (!e.Row.Cells[19].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color03H", line, planid);
e.Row.Cells[19].BackColor = setColor(color);
total3 += common.ConvertInt(e.Row.Cells[19].Text);
}
if (!e.Row.Cells[20].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color04H", line, planid);
e.Row.Cells[20].BackColor = setColor(color);
total4 += common.ConvertInt(e.Row.Cells[20].Text);
}
if (!e.Row.Cells[21].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color05H", line, planid);
e.Row.Cells[21].BackColor = setColor(color);
total5 += common.ConvertInt(e.Row.Cells[21].Text);
}
if (!e.Row.Cells[22].Text.Equals(""))
{
color = colorLine.getColorNightByColum("Color06H", line, planid);
e.Row.Cells[22].BackColor = setColor(color);
total6 += common.ConvertInt(e.Row.Cells[22].Text);
}
if (e.Row.Cells[23].Text.Trim().Equals("Run"))
{
e.Row.Cells[23].Text = "R";
e.Row.Cells[23].BackColor = Color.FromArgb(0, 204, 0);
}
else if (e.Row.Cells[23].Text.Trim().Equals("Stop"))
{
e.Row.Cells[23].Text = "S";
e.Row.Cells[23].BackColor = Color.Red;
}
}
else
{
for (int i = 1; i < 23; i++)
{
e.Row.Cells[i].Text = "";
}
e.Row.Cells[23].Text = "-";
}
}
}
#endregion
}