private void setDefaultGrid(AxFPUSpreadADO.AxfpSpread arg_grid)
{
// Set Default Grid
arg_grid.Visible = false;
arg_grid.Reset();
arg_grid.BorderStyle = FPUSpreadADO.BorderStyleConstants.BorderStyleNone;
arg_grid.DisplayColHeaders = false;
arg_grid.DisplayRowHeaders = false;
arg_grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
arg_grid.GrayAreaBackColor = Color.White;
// arg_grid.ScrollBarExtMode = true;
arg_grid.ColHeaderRows = 0;
arg_grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsHorizontal;
arg_grid.Font = new System.Drawing.Font("Calibri", 11);
arg_grid.set_RowHeight(1, 0.5);
arg_grid.set_ColWidth(1, 0.5);
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.TypeEditMultiLine = true;
arg_grid.SetCellBorder(1, 1, 150, arg_grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
arg_grid.SetCellBorder(1, 1, 150, arg_grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
for (int ic = 2; ic <= 150; ic++)
{
arg_grid.set_ColWidth(ic, 4.2);
}
}
private void MergeCol(AxFPUSpreadADO.AxfpSpread gridObject, int iStartRow, int iCol)
{
try
{
string sTemp1 = "";
string sTemp2 = "";
int iRow = iStartRow;
gridObject.Row = iStartRow;
gridObject.Col = iCol;
sTemp1 = gridObject.Value;
for (int i = iStartRow; i < gridObject.MaxRows + 4; i++)
{
gridObject.Row = i;
gridObject.Col = iCol;
sTemp2 = gridObject.Value;
if (sTemp1 != sTemp2)
{
gridObject.AddCellSpan(iCol, iRow, 1, i - iRow);
sTemp1 = sTemp2;
sTemp2 = "";
iRow = i;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void GridRightHead(int arg_col, AxFPUSpreadADO.AxfpSpread arg_grid)
{
string[] str = { "Model", "Plan", "Input" };
double[] w = { 21.5, 10, 10 };
arg_grid.Col = arg_col;
arg_grid.Row = -1;
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignLeft;
for (int i = 0; i < str.Length; i++)
{
if (i > 0)
{
arg_grid.Col = arg_col + i;
arg_grid.Row = -1;
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignRight;
}
arg_grid.Col = arg_col + i;
arg_grid.Row = 1;
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.Text = str[i];
arg_grid.BackColor = Color.Yellow;
arg_grid.FontSize = 14;
arg_grid.set_ColWidth(arg_col + i, w[i]);
}
}
private void MergeRowGroupCol(AxFPUSpreadADO.AxfpSpread gridObject, int iStartCol, int iEndCol, int iRow)
{
try
{
string sTemp1 = "";
string sTemp2 = "";
int iCol = iStartCol;
gridObject.Row = iRow;
gridObject.Col = iStartCol;
sTemp1 = gridObject.Value;
for (int i = iStartCol; i <= iEndCol; i++)
{
gridObject.Row = iRow;
gridObject.Col = i;
sTemp2 = gridObject.Value;
if (sTemp1 != sTemp2)
{
gridObject.AddCellSpan(iCol, iRow, i - iCol, 1);
sTemp1 = sTemp2;
sTemp2 = "";
iCol = i;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void DisplayGrid(DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
set_qty_actual();
arg_grid.MaxRows = 1;
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
int row_s = 2;
int irow = row_s;
int icol = 2;
_count = 0;
arg_grid.MaxRows = row_s + 25;
MachineHead(icol, irow, 0, arg_dt, arg_grid);
irow = row_s + 2;
MachineBody(icol, irow, 0, arg_dt, arg_grid);
for (int i = 1; i < arg_dt.Rows.Count; i++)
{
if (arg_dt.Rows[i]["LINE_ID"].ToString() == arg_dt.Rows[i - 1]["LINE_ID"].ToString())
{
if (arg_dt.Rows[i]["MINI_LINE_ID"].ToString() == arg_dt.Rows[i - 1]["MINI_LINE_ID"].ToString())
{
irow++;
}
else
{
irow = row_s + 2;
icol += 3;
}
MachineBody(icol, irow, i, arg_dt, arg_grid);
}
else
{
arg_grid.set_ColWidth(icol + 3, 0.7);
icol += 4;
irow = row_s;
MachineHead(icol, irow, i, arg_dt, arg_grid);
irow = row_s + 2;
MachineBody(icol, irow, i, arg_dt, arg_grid);
}
}
arg_grid.MaxCols = icol + 3;
}
catch
{ }
finally
{
// WarehouseMaterialSystem.ClassLib.WinAPI.AnimateWindow(arg_grid.Handle, 200, WarehouseMaterialSystem.ClassLib.WinAPI.getSlidType("2"));
// arg_grid.Visible = true;
}
}
private void ClearGrid(AxFPUSpreadADO.AxfpSpread _axfpSpread)
{
for (int iRow = 1; iRow < _axfpSpread.MaxRows; iRow++)
{
_axfpSpread.AddCellSpan(1, _axfpSpread.MaxCols - 1, _axfpSpread.MaxCols - 1, 1);
}
for (int iCol = 1; iCol < _axfpSpread.MaxCols; iCol++)
{
_axfpSpread.AddCellSpan(iCol, _axfpSpread.MaxRows - 1, 1, _axfpSpread.MaxRows - 1);
}
}
private string GetText(AxFPUSpreadADO.AxfpSpread spread, int col, int row)
{
try
{
object data = null;
spread.GetText(col, row, ref data);
return(data.ToString());
}
catch (Exception ex)
{
return(null);
}
}
private void Display_Grid(AxFPUSpreadADO.AxfpSpread _axfpSpread, DataTable _dt)
{
_axfpSpread.AddCellSpan(2, 1, _dt.Columns.Count - 1, 1);
_axfpSpread.SetText(2, 1, _dt.Columns[1].Caption.ToString().Substring(1, 4));
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
int iNumber = 0;
double dTotal = 0;
double d = Math.Round((232.125 - 22 - 18.75) / (_dt.Columns.Count - 1), 2);
for (int iCol = 1; iCol < _dt.Columns.Count; iCol++)
{
//_axfpSpread.set_ColWidth(iCol + 1, d);
//if (iRow == 0)
//{
// _axfpSpread.SetText(iCol+1,iRow+2,_dt.Columns[iCol].Caption.ToString().Substring(7,2));
//}
if (_dt.Rows[iRow][iCol].ToString() != "0")
{
_axfpSpread.SetText(iCol + 1, iRow + 3, _dt.Rows[iRow][iCol].ToString());
}
if (_dt.Rows[iRow][iCol].ToString() != "" && _dt.Rows[iRow][iCol].ToString() != "0")
{
dTotal += Convert.ToDouble(_dt.Rows[iRow][iCol].ToString());
iNumber++;
}
}
if (iRow == 0)
{
double dd = 232.125 - 22 - (_dt.Columns.Count - 1) * (_axfpSpread.get_ColWidth(_dt.Columns.Count));
_axfpSpread.AddCellSpan(_dt.Columns.Count + 1, iRow + 1, 1, 2);
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 1, "Average");
_axfpSpread.Row = iRow + 1;
_axfpSpread.Col = _dt.Columns.Count + 1;
_axfpSpread.BackColor = Color.Orange;
//_axfpSpread.set_ColWidth(_dt.Columns.Count + 1, dd);
}
if (iNumber != 0)
{
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, Math.Round(dTotal / iNumber, 1));
}
else
{
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, 0);
}
for (int iCol = _dt.Columns.Count + 2; iCol <= _axfpSpread.MaxCols; iCol++)
{
_axfpSpread.set_ColWidth(iCol, 0);
}
}
}
private void GridLeftHead(int arg_col, AxFPUSpreadADO.AxfpSpread arg_grid)
{
string[] str = { "Line", "Machine", "Input", "Bal" };
int[] w = { 6, 12, 6, 6 };
for (int i = 0; i < 4; i++)
{
arg_grid.Col = arg_col + i;
arg_grid.Row = 1;
arg_grid.Text = str[i];
arg_grid.BackColor = Color.Yellow;
arg_grid.FontSize = 14;
arg_grid.set_ColWidth(arg_col + i, w[i]);
}
}
private void Display_Grid(AxFPUSpreadADO.AxfpSpread _axfpSpread, DataTable _dt)
{
_axfpSpread.AddCellSpan(2, 1, _dt.Columns.Count - 1, 1);
_axfpSpread.SetText(2, 1, DateTime.ParseExact(_dt.Columns[1].Caption.ToString().Substring(1, 8), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("MMMM", CultureInfo.InvariantCulture));
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
int iNumber = 0;
double dTotal = 0;
double d = Math.Round((232.125 - 17.12 - 9.5) / (_dt.Columns.Count - 1), 2);
for (int iCol = 1; iCol < _dt.Columns.Count; iCol++)
{
_axfpSpread.set_ColWidth(iCol + 1, d);
if (iRow == 0)
{
_axfpSpread.SetText(iCol + 1, iRow + 2, _dt.Columns[iCol].Caption.ToString().Substring(7, 2));
}
if (_dt.Rows[iRow][iCol].ToString() != "" && _dt.Rows[iRow][iCol].ToString() != "0")
{
_axfpSpread.SetText(iCol + 1, iRow + 3, _dt.Rows[iRow][iCol].ToString());
dTotal += Convert.ToDouble(_dt.Rows[iRow][iCol].ToString());
iNumber++;
}
}
if (iRow == 0)
{
double dd = 232.125 - 17.12 - (_dt.Columns.Count - 1) * (_axfpSpread.get_ColWidth(_dt.Columns.Count));
_axfpSpread.AddCellSpan(_dt.Columns.Count + 1, iRow + 1, 1, 2);
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 1, "Avg");
_axfpSpread.Row = iRow + 1;
_axfpSpread.Col = _dt.Columns.Count + 1;
_axfpSpread.BackColor = Color.Orange;
_axfpSpread.ForeColor = Color.White;
_axfpSpread.set_ColWidth(_dt.Columns.Count + 1, dd);
}
if (iNumber != 0)
{
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, Math.Round(dTotal / iNumber, 1));
}
else
{
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, 0);
}
for (int iCol = _dt.Columns.Count + 2; iCol <= _axfpSpread.MaxCols; iCol++)
{
_axfpSpread.set_ColWidth(iCol, 0);
}
}
}
private string GetText(AxFPUSpreadADO.AxfpSpread spread, int col, int row)
{
try
{
object data = null;
spread.GetText(col, row, ref data);
return(data.ToString());
}
catch
{
//return "";
//log.Error(ex);
return(null);
}
}
private void load_grid(AxFPUSpreadADO.AxfpSpread axGrid)
{
int imax = Convert.ToInt16(_dt_chart.Rows[0]["COL_COUNT"]);
int iColSpan = Convert.ToInt16(_dt_chart.Rows[0]["COL_SPAN"]);
axGrid.MaxCols = imax + 2;
axGrid.AddCellSpan(3, 4, iColSpan, 1);
axGrid.SetText(1, 1, EmptyIfNull(_dt_chart.Rows[0][axGrid.Name.Replace("axGrid_", "") + "_GNAME"].ToString()));
for (int i = 0; i < imax; i++)
{
axGrid.SetText(i + 3, 1, _dt_chart.Rows[i]["TITLE"].ToString());
axGrid.SetText(i + 3, 2, EmptyIfNull2(_dt_chart.Rows[i][axGrid.Name.Replace("axGrid_", "")].ToString()));
axGrid.SetText(i + 3, 3, EmptyIfNull(_dt_chart.Rows[i][axGrid.Name.Replace("axGrid_", "") + "_PER"].ToString() + "%"));
axGrid.SetText(3, 4, EmptyIfNull(_dt_chart.Rows[0][axGrid.Name.Replace("axGrid_", "") + "_IM"].ToString() + "%"));
axGrid.set_ColWidth(i + 3, Convert.ToDouble(_dt_chart.Rows[i]["COL_WIDTH"]));
axGrid.Col = i + 3;
axGrid.Row = 1;
axGrid.FontSize = Convert.ToSingle(_dt_chart.Rows[i]["FONT"]);
axGrid.Row = 4;
if (i >= iColSpan)
{
axGrid.BackColor = Color.White;
}
else
{
axGrid.BackColor = Color.Navy;
}
axGrid.FontSize = 35f;
axGrid.FontBold = true;
}
axGrid.SetCellBorder(1, 1, axGrid.MaxCols, axGrid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
axGrid.SetCellBorder(1, 2, axGrid.MaxCols, axGrid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
axGrid.SetCellBorder(1, 2, axGrid.MaxCols, axGrid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexTop, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
}
private void DisplayGridLeft(DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
int irow = 1, icol = 0, divRow;
int iTotMachine = 0, iTotInput = 0, iTotBal = 0;
arg_grid.Reset();
// arg_grid.BorderStyle = FPUSpreadADO.BorderStyleConstants.BorderStyleNone;
arg_grid.GrayAreaBackColor = Color.White;
arg_grid.DisplayColHeaders = false;
arg_grid.DisplayRowHeaders = false;
arg_grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
arg_grid.ColHeaderRows = 0;
arg_grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsNone;
arg_grid.Font = new System.Drawing.Font("Calibri", 11);
//arg_grid.set_RowHeight(1, 0.5);
//arg_grid.set_ColWidth(1, 0.5);
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.TypeEditMultiLine = true;
arg_grid.Row = 1;
arg_grid.FontBold = true;
//for (int ic = 1; ic <= 50; ic++)
// arg_grid.set_ColWidth(ic, 12);
var query = from DataRow dRow in arg_dt.AsEnumerable()
// where p.Used = "N"
group dRow by dRow["LINE_NAME"] into gp
select new
{
Line = gp.Key,
Machine = gp.Count(),
Input = gp.Count(dRow => dRow.Field <string>("USE_YN") == "Y")
};
divRow = (query.Count() / 2) + 2;
for (int ir = 1; ir <= divRow; ir++)
{
arg_grid.set_RowHeight(ir, 15);
}
arg_grid.set_RowHeight(divRow + 1, 18);
arg_grid.MaxCols = 9;
arg_grid.MaxRows = divRow + 1;
GridLeftHead(1, arg_grid);
arg_grid.SetCellBorder(1, 1, arg_grid.MaxCols, divRow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0x4286f4, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.SetCellBorder(1, 1, arg_grid.MaxCols, divRow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0x4286f4, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
foreach (var element in query)
{
if (irow == divRow)
{
icol += 5;
irow = 2;
GridLeftHead(icol + 1, arg_grid);
arg_grid.set_ColWidth(icol, 2);
arg_grid.SetCellBorder(icol, 1, icol, divRow - 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
//arg_grid.SetCellBorder(irow , icol , 4, divRow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
// arg_grid.SetCellBorder(irow , icol, 4, divRow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
}
else
{
irow++;
}
arg_grid.SetText(icol + 1, irow, element.Line);
arg_grid.SetText(icol + 2, irow, element.Machine);
arg_grid.SetText(icol + 3, irow, element.Input);
arg_grid.SetText(icol + 4, irow, element.Machine - element.Input);
iTotMachine += element.Machine;
iTotInput += element.Input;
iTotBal += (element.Machine - element.Input);
}
arg_grid.AddCellSpan(1, divRow + 1, 6, 1);
arg_grid.SetText(1, divRow + 1, "Total");
arg_grid.SetText(icol + 2, divRow + 1, iTotMachine.ToString());
arg_grid.SetText(icol + 3, divRow + 1, iTotInput.ToString());
arg_grid.SetText(icol + 4, divRow + 1, iTotBal.ToString());
arg_grid.Col = -1;
arg_grid.Row = divRow + 1;
arg_grid.BackColor = Color.FromArgb(232, 232, 127);
arg_grid.FontBold = true;
arg_grid.FontSize = 14;
}
private void Display_Grid(AxFPUSpreadADO.AxfpSpread _axfpSpread, DataTable _dt)
{
//_axfpSpread.AddCellSpan(2, 1, _dt.Columns.Count-2, 1);
//_axfpSpread.SetText(2, 1, DateTime.ParseExact(_dt.Columns[2].Caption.ToString().Substring(1, 8), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("MMMM", CultureInfo.InvariantCulture));
ClearGrid(_axfpSpread);
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
int iNumber = 0;
double dTotal = 0;
double d = Math.Round((159 - 10.75 - 10 * 2) / (_dt.Columns.Count - 2), 2);
for (int iCol = 1; iCol < _dt.Columns.Count; iCol++)
{
_axfpSpread.set_ColWidth(iCol + 1, d);
if (iRow == 0 && iCol > 1)
{
_axfpSpread.SetText(iCol, iRow + 1, DateTime.ParseExact(_dt.Columns[iCol].Caption.ToString().Substring(1, 8), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("MMM", CultureInfo.InvariantCulture));
_axfpSpread.SetText(iCol, iRow + 2, _dt.Columns[iCol].Caption.ToString().Substring(7, 2));
}
_axfpSpread.SetText(iCol, iRow + 3, _dt.Rows[iRow][iCol].ToString());
if (_dt.Rows[iRow][iCol].ToString() != "" && _dt.Rows[iRow][iCol].ToString() != "0" && iCol > 1)
{
dTotal += Convert.ToDouble(_dt.Rows[iRow][iCol].ToString());
iNumber++;
}
}
if (iNumber != 0)
{
_axfpSpread.SetText(_dt.Columns.Count, iRow + 3, Math.Round(dTotal / iNumber, 1));
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, Math.Round(dTotal, 1));
}
else
{
_axfpSpread.SetText(_dt.Columns.Count, iRow + 3, 0);
_axfpSpread.SetText(_dt.Columns.Count + 1, iRow + 3, 0);
}
}
double dd = 159 - 10.75 - (_dt.Columns.Count - 1) * (_axfpSpread.get_ColWidth(_dt.Columns.Count - 2));
_axfpSpread.AddCellSpan(_dt.Columns.Count, 1, 1, 2);
_axfpSpread.SetText(_dt.Columns.Count, 1, "Avg");
_axfpSpread.Row = 1;
_axfpSpread.Col = _dt.Columns.Count;
_axfpSpread.BackColor = Color.Orange;
_axfpSpread.ForeColor = Color.White;
_axfpSpread.set_ColWidth(_dt.Columns.Count, dd / 2);
_axfpSpread.AddCellSpan(_dt.Columns.Count + 1, 1, 1, 2);
_axfpSpread.SetText(_dt.Columns.Count + 1, +1, "Total");
_axfpSpread.Row = 1;
_axfpSpread.Col = _dt.Columns.Count + 1;
_axfpSpread.BackColor = Color.DodgerBlue;
_axfpSpread.ForeColor = Color.White;
_axfpSpread.set_ColWidth(_dt.Columns.Count + 1, dd / 2);
for (int iCol = _dt.Columns.Count + 2; iCol <= _axfpSpread.MaxCols; iCol++)
{
_axfpSpread.set_ColWidth(iCol, 0);
}
for (int i = _dt.Rows.Count + 1; i <= _axfpSpread.MaxRows; i++)
{
_axfpSpread.set_RowHeight(i + 2, 0);
}
MergeRowGroupCol(_axfpSpread, 2, _dt.Columns.Count, 1);
}
private void MachineHead(int arg_icol, int arg_irow, int arg_idt, DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
int iRow = Convert.ToInt32(arg_dt.Rows[arg_idt]["NUM_MINI_LINE"]);
arg_grid.Col = arg_icol;
arg_grid.Row = arg_irow;
arg_grid.Text = "Line " + arg_dt.Rows[arg_idt]["LINE_NAME"].ToString();
arg_grid.FontSize = 11;
arg_grid.FontBold = true;
arg_grid.BackColor = Color.DodgerBlue;
arg_grid.ForeColor = Color.White;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.AddCellSpan(arg_icol, arg_irow, iRow * 3, 1);
//arg_grid.SetCellBorder(arg_icol, arg_irow, arg_icol, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexOutline, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
// arg_grid.SetCellBorder(icol, irow, icol + 3, irow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
//arg_grid.SetCellBorder(icol, irow, icol + 2, irow +1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
//arg_grid.SetCellBorder(icol, irow, icol + 2, irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexTop, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_irow++;
arg_grid.Row = arg_irow;
for (int i = 0; i < iRow; i++)
{
if (arg_dt.Rows[arg_idt]["LINE_NAME"].ToString() == "E")
{
arg_grid.set_ColWidth(arg_icol + (i * 3), 6.0);
}
arg_grid.Col = arg_icol + (i * 3);
arg_grid.Text = "M/C";
arg_grid.BackColor = Color.LightSkyBlue;
// arg_grid.ForeColor = Color.White;
arg_grid.FontSize = 11;
arg_grid.FontBold = true;
arg_grid.Col = arg_icol + (i * 3) + 1;
arg_grid.Text = "Plan";
arg_grid.BackColor = Color.Green;
arg_grid.ForeColor = Color.White;
arg_grid.FontSize = 11;
arg_grid.FontBold = true;
arg_grid.Col = arg_icol + (i * 3) + 2;
arg_grid.Text = "Act";
arg_grid.BackColor = Color.Orange;
arg_grid.ForeColor = Color.White;
arg_grid.FontSize = 11;
arg_grid.FontBold = true;
}
arg_grid.Col = -1;
arg_grid.set_RowHeight(arg_irow, 20);
//arg_grid.Col = arg_icol + 2;
//arg_grid.Text = "R";
//arg_grid.BackColor = Color.LightSkyBlue;
//// arg_grid.ForeColor = Color.White;
//arg_grid.Font = new System.Drawing.Font("Calibri", 15, FontStyle.Bold);
}
catch
{ }
}
private void Display_Grid(AxFPUSpreadADO.AxfpSpread _axfpSpread, DataTable _dt)
{
if (_sProcess == "FSS")
{
int iNumberRow = _dt.Rows.Count;
if (iNumberRow > 99)
{
iNumberRow = 99;
}
for (int iRow = 0; iRow < iNumberRow; iRow++)
{
_axfpSpread.SetText(1, iRow + 4, _dt.Rows[iRow]["MODEL_NAME"].ToString());
if (_dt.Rows[iRow]["PLAN_QTY"].ToString() != "0")
{
_axfpSpread.SetText(2, iRow + 4, _dt.Rows[iRow]["PLAN_QTY"].ToString());
}
else
{
_axfpSpread.SetText(2, iRow + 4, "");
}
if (_dt.Rows[iRow]["INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(3, iRow + 4, _dt.Rows[iRow]["INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(3, iRow + 4, "");
}
if (_dt.Rows[iRow]["LEADTIME"].ToString() != "0")
{
_axfpSpread.SetText(4, iRow + 4, _dt.Rows[iRow]["LEADTIME"].ToString());
}
else
{
_axfpSpread.SetText(4, iRow + 4, "");
}
if (_dt.Rows[iRow]["UV_INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(5, iRow + 4, _dt.Rows[iRow]["UV_INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(5, iRow + 4, "");
}
if (_dt.Rows[iRow]["UV_LT"].ToString() != "0")
{
_axfpSpread.SetText(6, iRow + 4, _dt.Rows[iRow]["UV_LT"].ToString());
}
else
{
_axfpSpread.SetText(6, iRow + 4, "");
}
if (_dt.Rows[iRow]["SP_INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(7, iRow + 4, _dt.Rows[iRow]["SP_INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(7, iRow + 4, "");
}
if (_dt.Rows[iRow]["SP_LT"].ToString() != "0")
{
_axfpSpread.SetText(8, iRow + 4, _dt.Rows[iRow]["SP_LT"].ToString());
}
else
{
_axfpSpread.SetText(8, iRow + 4, "");
}
}
for (int iRow = _dt.Rows.Count + 1; iRow < _axfpSpread.MaxRows; iRow++)
{
_axfpSpread.set_RowHeight(iRow + 1, 0);
}
}
}
public void MachineBody(int arg_icol, int arg_irow, int arg_idt, DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
arg_grid.SetCellBorder(arg_icol + 1, arg_irow, arg_icol + 2, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.SetCellBorder(arg_icol + 3, arg_irow, arg_icol + 3, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.SetCellBorder(arg_icol + 1, arg_irow, arg_icol + 2, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.set_RowHeight(arg_irow, 20);
arg_grid.Col = arg_icol;
arg_grid.Row = arg_irow;
arg_grid.Text = arg_dt.Rows[arg_idt]["MACHINE_NAME"].ToString();
arg_grid.FontSize = 11;
arg_grid.FontBold = true;
arg_grid.BackColor = Color.LightGreen;
///Plan
arg_grid.Col = arg_icol + 1;
arg_grid.Text = arg_dt.Rows[arg_idt]["MOLD_SIZE_CD"].ToString();
if (arg_dt.Rows[arg_idt]["STATUS"].ToString() == "1")
{
arg_grid.BackColor = Color.Yellow;
}
else
{
arg_grid.BackColor = Color.White;
}
///Act
arg_grid.Col = arg_icol + 2;
arg_grid.Text = arg_dt.Rows[arg_idt]["ACTUAL"].ToString();
if (arg_dt.Rows[arg_idt]["STATUS"].ToString() == "1")
{
arg_grid.BackColor = Color.Yellow;
}
else
{
arg_grid.BackColor = Color.White;
}
}
catch (Exception)
{ }
}
private void DisplayGridTop(DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
_Dic_Location = new Dictionary <string, string>();
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
Double.TryParse(arg_dt.Rows[0]["WIDTH"].ToString(), out _iWidth);
Double.TryParse(arg_dt.Rows[0]["HEIGHT"].ToString(), out _iHeight);
// Set Default Grid
arg_grid.Visible = false;
arg_grid.Reset();
arg_grid.BorderStyle = FPUSpreadADO.BorderStyleConstants.BorderStyleNone;
arg_grid.DisplayColHeaders = false;
arg_grid.DisplayRowHeaders = false;
arg_grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
arg_grid.ColHeaderRows = 0;
arg_grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsNone;
arg_grid.Font = new System.Drawing.Font("Calibri", 8);
arg_grid.set_RowHeight(1, 0.5);
arg_grid.set_ColWidth(1, 0.5);
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.TypeEditMultiLine = true;
arg_grid.SetCellBorder(1, 1, 150, axGridTop.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
arg_grid.SetCellBorder(1, 1, 150, axGridTop.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
for (int ic = 2; ic <= 150; ic++)
{
arg_grid.set_ColWidth(ic, 3.1);
}
int row_s = 2;
int irow = row_s;
int icol = 2;
MachineHeadTop(icol, irow, 0, arg_dt, arg_grid);
irow = row_s + 1;
MachineBodyTop(icol, irow, 0, arg_dt, arg_grid);
_Dic_Location.Add(irow.ToString() + "-" + icol.ToString(), arg_dt.Rows[0]["SHORT_NAME"].ToString());
for (int i = 1; i < arg_dt.Rows.Count; i++)
{
if (arg_dt.Rows[i]["LINE_ID"].ToString() == arg_dt.Rows[i - 1]["LINE_ID"].ToString())
{
if (arg_dt.Rows[i]["MINI_LINE_ID"].ToString() == arg_dt.Rows[i - 1]["MINI_LINE_ID"].ToString())
{
irow++;
}
else
{
irow = row_s + 1;
icol++;
}
MachineBodyTop(icol, irow, i, arg_dt, arg_grid);
}
else
{
axGridTop.set_ColWidth(icol + 1, 0.4);
icol += 2;
irow = row_s;
MachineHeadTop(icol, irow, i, arg_dt, arg_grid);
irow = row_s + 1;
MachineBodyTop(icol, irow, i, arg_dt, arg_grid);
}
string loc = irow.ToString() + "-" + icol.ToString();
//for (int i = 0; i < _Dic_Location.Count; i++)
//{
// _Dic_Location.
//}
_Dic_Location.Add(loc, arg_dt.Rows[i]["SHORT_NAME"].ToString());
}
arg_grid.RowsFrozen = irow + 1;
}
catch
{ }
finally
{
arg_grid.Visible = true;
}
}
private void DisplayGridRight(DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
int irow = 1, icol = 0;
int iTotInput = 0, iTotMold = 0, iInput = 0, iMold = 0;
int divRow = 11;
arg_grid.Reset();
//arg_grid.BorderStyle = FPUSpreadADO.BorderStyleConstants.BorderStyleNone;
arg_grid.GrayAreaBackColor = Color.White;
arg_grid.DisplayColHeaders = false;
arg_grid.DisplayRowHeaders = false;
arg_grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
arg_grid.ColHeaderRows = 0;
arg_grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsNone;
arg_grid.Font = new System.Drawing.Font("Calibri", 11);
//arg_grid.set_RowHeight(1, 0.5);
//arg_grid.set_ColWidth(1, 0.5);
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.TypeEditMultiLine = true;
arg_grid.Row = 1;
arg_grid.FontBold = true;
//for (int ic = 1; ic <= 50; ic++)
// arg_grid.set_ColWidth(ic, 12);
for (int ir = 1; ir <= divRow; ir++)
{
arg_grid.set_RowHeight(ir, 15);
}
// arg_grid.set_RowHeight(1, 22);
arg_grid.set_RowHeight(divRow + 1, 18);
GridRightHead(1, arg_grid);
arg_grid.SetCellBorder(1, 1, arg_grid.MaxCols, divRow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0x4286f4, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.SetCellBorder(1, 1, arg_grid.MaxCols, divRow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0x4286f4, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
if (irow == divRow)
{
icol += 4;
irow = 2;
GridRightHead(icol + 1, arg_grid);
arg_grid.set_ColWidth(icol, 2);
arg_grid.SetCellBorder(icol, 1, icol, divRow - 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
//arg_grid.SetCellBorder(irow , icol , 4, divRow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
// arg_grid.SetCellBorder(irow , icol, 4, divRow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
}
else
{
irow++;
}
iInput = Convert.ToInt32(arg_dt.Rows[i]["MOLD_INPUT"]);
iMold = Convert.ToInt32(arg_dt.Rows[i]["QTY"]);
arg_grid.SetText(icol + 1, irow, arg_dt.Rows[i]["SHORT_NAME"].ToString());
arg_grid.SetText(icol + 2, irow, iMold.ToString("###,###,###"));
arg_grid.SetText(icol + 3, irow, iInput.ToString("###,###,###"));
iTotInput += Convert.ToInt32(arg_dt.Rows[i]["MOLD_INPUT"]);
iTotMold += Convert.ToInt32(arg_dt.Rows[i]["QTY"]);
}
arg_grid.AddCellSpan(1, divRow + 1, 13, 1);
arg_grid.SetText(1, divRow + 1, "Total");
arg_grid.SetText(icol + 3, divRow + 1, iTotInput.ToString("###,###,###"));
arg_grid.SetText(icol + 2, divRow + 1, iTotMold.ToString("###,###,###"));
arg_grid.Col = -1;
arg_grid.Row = divRow + 1;
arg_grid.BackColor = Color.FromArgb(232, 232, 127);
arg_grid.FontBold = true;
arg_grid.FontSize = 14;
arg_grid.Col = 1;
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.MaxRows = divRow + 1;
arg_grid.MaxCols = 15;
}
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FORM_DEFFECTIVE_STATUS));
this.panel1 = new System.Windows.Forms.Panel();
this.cmdMonth = new DevExpress.XtraEditors.SimpleButton();
this.cmdYear = new DevExpress.XtraEditors.SimpleButton();
this.cmdBack = new System.Windows.Forms.Button();
this.lblDate = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.timer2 = new System.Windows.Forms.Timer(this.components);
this.chart1 = new ChartDirector.WinChartViewer();
this.chart2 = new ChartDirector.WinChartViewer();
this.axfpSpread = new AxFPUSpreadADO.AxfpSpread();
this.uC_MONTH_SELECTION1 = new OS_DSF.UC.UC_MONTH_SELECTION();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chart1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.chart2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.axfpSpread)).BeginInit();
this.SuspendLayout();
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Turquoise;
this.panel1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
this.panel1.Controls.Add(this.cmdMonth);
this.panel1.Controls.Add(this.cmdYear);
this.panel1.Controls.Add(this.cmdBack);
this.panel1.Controls.Add(this.lblDate);
this.panel1.Controls.Add(this.label1);
this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.MaximumSize = new System.Drawing.Size(1920, 109);
this.panel1.MinimumSize = new System.Drawing.Size(1920, 109);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(1920, 109);
this.panel1.TabIndex = 0;
//
// cmdMonth
//
this.cmdMonth.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
this.cmdMonth.Appearance.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
this.cmdMonth.Appearance.Font = new System.Drawing.Font("Calibri", 27.75F, System.Drawing.FontStyle.Bold);
this.cmdMonth.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
this.cmdMonth.Appearance.Options.UseBackColor = true;
this.cmdMonth.Appearance.Options.UseFont = true;
this.cmdMonth.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Flat;
this.cmdMonth.Enabled = false;
this.cmdMonth.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("cmdMonth.ImageOptions.Image")));
this.cmdMonth.Location = new System.Drawing.Point(1512, 5);
this.cmdMonth.Name = "cmdMonth";
this.cmdMonth.Size = new System.Drawing.Size(175, 48);
this.cmdMonth.TabIndex = 68;
this.cmdMonth.Text = "Day";
//
// cmdYear
//
this.cmdYear.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
this.cmdYear.Appearance.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
this.cmdYear.Appearance.Font = new System.Drawing.Font("Calibri", 27.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.cmdYear.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
this.cmdYear.Appearance.Options.UseBackColor = true;
this.cmdYear.Appearance.Options.UseFont = true;
this.cmdYear.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Flat;
this.cmdYear.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("cmdYear.ImageOptions.Image")));
this.cmdYear.Location = new System.Drawing.Point(1512, 56);
this.cmdYear.Name = "cmdYear";
this.cmdYear.Size = new System.Drawing.Size(175, 48);
this.cmdYear.TabIndex = 69;
this.cmdYear.Text = "Month";
this.cmdYear.Click += new System.EventHandler(this.cmdYear_Click);
//
// cmdBack
//
this.cmdBack.BackColor = System.Drawing.Color.Turquoise;
this.cmdBack.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("cmdBack.BackgroundImage")));
this.cmdBack.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
this.cmdBack.FlatAppearance.BorderColor = System.Drawing.Color.Yellow;
this.cmdBack.FlatAppearance.BorderSize = 0;
this.cmdBack.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.cmdBack.Location = new System.Drawing.Point(1314, 5);
this.cmdBack.Name = "cmdBack";
this.cmdBack.Size = new System.Drawing.Size(108, 101);
this.cmdBack.TabIndex = 67;
this.cmdBack.UseVisualStyleBackColor = false;
this.cmdBack.Click += new System.EventHandler(this.cmdBack_Click);
//
// lblDate
//
this.lblDate.BackColor = System.Drawing.Color.Turquoise;
this.lblDate.Dock = System.Windows.Forms.DockStyle.Right;
this.lblDate.Font = new System.Drawing.Font("Calibri", 32.25F, System.Drawing.FontStyle.Bold);
this.lblDate.ForeColor = System.Drawing.Color.White;
this.lblDate.ImageAlign = System.Drawing.ContentAlignment.TopLeft;
this.lblDate.Location = new System.Drawing.Point(1676, 0);
this.lblDate.Name = "lblDate";
this.lblDate.Size = new System.Drawing.Size(244, 109);
this.lblDate.TabIndex = 46;
this.lblDate.Text = "lblDate";
this.lblDate.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.lblDate.Click += new System.EventHandler(this.lblDate_Click);
//
// label1
//
this.label1.BackColor = System.Drawing.Color.Turquoise;
this.label1.Font = new System.Drawing.Font("Calibri", 45.25F, System.Drawing.FontStyle.Bold);
this.label1.ForeColor = System.Drawing.Color.White;
this.label1.Location = new System.Drawing.Point(8, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(1108, 103);
this.label1.TabIndex = 0;
this.label1.Text = "Defective Status by Process && Reason";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// timer2
//
this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
//
// chart1
//
this.chart1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.chart1.Location = new System.Drawing.Point(1221, 116);
this.chart1.Name = "chart1";
this.chart1.Size = new System.Drawing.Size(683, 448);
this.chart1.TabIndex = 64;
this.chart1.TabStop = false;
//
// chart2
//
this.chart2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.chart2.Location = new System.Drawing.Point(1221, 575);
this.chart2.Name = "chart2";
this.chart2.Size = new System.Drawing.Size(683, 451);
this.chart2.TabIndex = 65;
this.chart2.TabStop = false;
//
// axfpSpread
//
this.axfpSpread.DataSource = null;
this.axfpSpread.Location = new System.Drawing.Point(5, 158);
this.axfpSpread.Name = "axfpSpread";
this.axfpSpread.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("axfpSpread.OcxState")));
this.axfpSpread.Size = new System.Drawing.Size(1207, 870);
this.axfpSpread.TabIndex = 63;
//
// uC_MONTH_SELECTION1
//
this.uC_MONTH_SELECTION1.AutoSize = true;
this.uC_MONTH_SELECTION1.Location = new System.Drawing.Point(5, 111);
this.uC_MONTH_SELECTION1.Name = "uC_MONTH_SELECTION1";
this.uC_MONTH_SELECTION1.Size = new System.Drawing.Size(472, 46);
this.uC_MONTH_SELECTION1.TabIndex = 66;
//
// FORM_DEFFECTIVE_STATUS
//
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.None;
this.ClientSize = new System.Drawing.Size(1916, 1054);
this.Controls.Add(this.uC_MONTH_SELECTION1);
this.Controls.Add(this.chart2);
this.Controls.Add(this.chart1);
this.Controls.Add(this.panel1);
this.Controls.Add(this.axfpSpread);
this.Font = new System.Drawing.Font("Malgun Gothic", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.KeyPreview = true;
this.Name = "FORM_DEFFECTIVE_STATUS";
this.Text = "FORM_DEFFECTIVE_STATUS";
this.Activated += new System.EventHandler(this.FORM_DEFFECTIVE_STATUS_Activated);
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.FORM_DEFFECTIVE_STATUS_FormClosing);
this.Load += new System.EventHandler(this.FORM_DEFFECTIVE_STATUS_Load);
this.VisibleChanged += new System.EventHandler(this.FORM_DEFFECTIVE_STATUS_VisibleChanged);
this.panel1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.chart1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chart2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.axfpSpread)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
private void Display_Grid(AxFPUSpreadADO.AxfpSpread _axfpSpread, DataTable _dt)
{
_axfpSpread.RowsFrozen = 2;
if (_sProcess == "CMP")
{
_axfpSpread.BringToFront();
int iNumberRow = _dt.Rows.Count;
if (iNumberRow > 99)
{
iNumberRow = 99;
}
for (int iRow = 0; iRow < iNumberRow; iRow++)
{
if (_dt.Rows[iRow]["DIV"].ToString() == "0")
{
_axfpSpread.Col = -1;
_axfpSpread.Row = iRow + 2;
_axfpSpread.BackColor = Color.LightGray;
}
_axfpSpread.SetText(1, iRow + 2, _dt.Rows[iRow]["MODEL_NAME"].ToString());
if (_dt.Rows[iRow]["PLAN_QTY"].ToString() != "0")
{
_axfpSpread.SetText(2, iRow + 2, _dt.Rows[iRow]["PLAN_QTY"].ToString());
}
else
{
_axfpSpread.SetText(2, iRow + 2, "");
}
if (_dt.Rows[iRow]["BEF_QTY"].ToString() != "0")
{
_axfpSpread.SetText(3, iRow + 2, _dt.Rows[iRow]["BEF_QTY"].ToString());
}
else
{
_axfpSpread.SetText(3, iRow + 2, "");
}
if (_dt.Rows[iRow]["IN_QTY"].ToString() != "0")
{
_axfpSpread.SetText(4, iRow + 2, _dt.Rows[iRow]["IN_QTY"].ToString());
}
else
{
_axfpSpread.SetText(4, iRow + 2, "");
}
if (_dt.Rows[iRow]["OUT_QTY"].ToString() != "0")
{
_axfpSpread.SetText(5, iRow + 2, _dt.Rows[iRow]["OUT_QTY"].ToString());
}
else
{
_axfpSpread.SetText(5, iRow + 2, "");
}
if (_dt.Rows[iRow]["INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(6, iRow + 2, _dt.Rows[iRow]["INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(6, iRow + 2, "");
}
if (_dt.Rows[iRow]["LEADTIME"].ToString() != "0")
{
_axfpSpread.SetText(7, iRow + 2, _dt.Rows[iRow]["LEADTIME"].ToString());
}
else
{
_axfpSpread.SetText(7, iRow + 2, "");
}
}
for (int iRow = _dt.Rows.Count + 1; iRow < _axfpSpread.MaxRows; iRow++)
{
_axfpSpread.set_RowHeight(iRow + 1, 0);
}
}
if (_sProcess == "PHP")
{
int iNumberRow = _dt.Rows.Count;
if (iNumberRow > 99)
{
iNumberRow = 99;
}
for (int iRow = 0; iRow < iNumberRow; iRow++)
{
if (_dt.Rows[iRow]["DIV"].ToString() == "0")
{
_axfpSpread.Col = -1;
_axfpSpread.Row = iRow + 3;
_axfpSpread.BackColor = Color.LightGray;
}
_axfpSpread.SetText(1, iRow + 3, _dt.Rows[iRow]["MODEL_NAME"].ToString());
if (_dt.Rows[iRow]["PLAN_QTY"].ToString() != "0")
{
_axfpSpread.SetText(2, iRow + 3, _dt.Rows[iRow]["PLAN_QTY"].ToString());
}
else
{
_axfpSpread.SetText(2, iRow + 3, "");
}
if (_dt.Rows[iRow]["INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(3, iRow + 3, _dt.Rows[iRow]["INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(3, iRow + 3, "");
}
if (_dt.Rows[iRow]["LEADTIME"].ToString() != "0")
{
_axfpSpread.SetText(4, iRow + 3, _dt.Rows[iRow]["LEADTIME"].ToString());
}
else
{
_axfpSpread.SetText(4, iRow + 3, "");
}
if (_dt.Rows[iRow]["UV_INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(5, iRow + 3, _dt.Rows[iRow]["UV_INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(5, iRow + 3, "");
}
if (_dt.Rows[iRow]["UV_LT"].ToString() != "0")
{
_axfpSpread.SetText(6, iRow + 3, _dt.Rows[iRow]["UV_LT"].ToString());
}
else
{
_axfpSpread.SetText(6, iRow + 3, "");
}
if (_dt.Rows[iRow]["SP_INV_QTY"].ToString() != "0")
{
_axfpSpread.SetText(7, iRow + 3, _dt.Rows[iRow]["SP_INV_QTY"].ToString());
}
else
{
_axfpSpread.SetText(7, iRow + 3, "");
}
if (_dt.Rows[iRow]["SP_LT"].ToString() != "0")
{
_axfpSpread.SetText(8, iRow + 3, _dt.Rows[iRow]["SP_LT"].ToString());
}
else
{
_axfpSpread.SetText(8, iRow + 3, "");
}
}
for (int iRow = _dt.Rows.Count + 1; iRow < _axfpSpread.MaxRows; iRow++)
{
_axfpSpread.set_RowHeight(iRow + 1, 0);
}
}
}
public void MachineBodyTop(int arg_icol, int arg_irow, int arg_idt, DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
arg_grid.SetCellBorder(arg_icol, arg_irow, arg_icol, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
// arg_grid.SetCellBorder(arg_icol, arg_irow, arg_icol + 1, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
arg_grid.SetCellBorder(arg_icol, arg_irow, arg_icol, arg_irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
arg_grid.set_RowHeight(arg_irow, _iHeight);
arg_grid.Col = arg_icol;
arg_grid.Row = arg_irow;
arg_grid.Text = arg_dt.Rows[arg_idt]["MOLD_SIZE_CD"].ToString().Replace("/", "/\n");
if (arg_dt.Rows[arg_idt]["USE_YN"].ToString() == "N")
{
arg_grid.BackColor = Color.LightGray;
iNoUse++;
//_dtColor.Rows[row_index][column_index] = "5";
}
else if (arg_dt.Rows[arg_idt]["MOLD_SIZE_CD"].ToString() == "" || arg_dt.Rows[arg_idt]["MOLD_SIZE_CD"].ToString().ToUpper() == "NO PLAN")
{
if (arg_dt.Rows[arg_idt]["PLAN_FIX_YN"].ToString() == "Y")
{
arg_grid.BackColor = Color.LightCyan;
// _dtColor.Rows[row_index][column_index] = "8";
}
else
{
arg_grid.BackColor = Color.Red;
iNoPlan++;
//_dtColor.Rows[row_index][column_index] = "4";
}
}
else if (arg_dt.Rows[arg_idt]["MOLD_SIZE_CD"].ToString().Split('/').Length > 1)
{
arg_grid.BackColor = Color.Yellow;
arg_grid.ForeColor = Color.Black;
iMoldChange++;
iPlan++;
//_dtColor.Rows[row_index][column_index] = "6";
}
else
{
arg_grid.BackColor = Color.FromArgb(0, 255, 0);
iPlan++;
//_dtColor.Rows[row_index][column_index] = "3";
}
}
catch (Exception)
{}
}
private void MachineHeadTop(int arg_icol, int arg_irow, int arg_idt, DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
arg_grid.Col = arg_icol;
arg_grid.Row = arg_irow;
arg_grid.Text = "Line " + arg_dt.Rows[arg_idt]["LINE_NAME"].ToString();
arg_grid.Font = new System.Drawing.Font("Calibri", 12, FontStyle.Bold);
axGridTop.set_RowHeight(arg_irow, 20);
arg_grid.BackColor = Color.DodgerBlue;
arg_grid.ForeColor = Color.White;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.AddCellSpan(arg_icol, arg_irow, Convert.ToInt32(arg_dt.Rows[arg_idt]["NUM_MINI_LINE"]), 1);
//arg_grid.SetCellBorder(icol, irow, icol + 2, irow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexOutline, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
// arg_grid.SetCellBorder(icol, irow, icol + 3, irow + 1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
//arg_grid.SetCellBorder(icol, irow, icol + 2, irow +1, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
//arg_grid.SetCellBorder(icol, irow, icol + 2, irow, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexTop, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
//arg_irow++;
//arg_grid.Row = arg_irow;
//arg_grid.Col = arg_icol;
//arg_grid.Text = "STA";
//arg_grid.BackColor = Color.LightSkyBlue;
//// arg_grid.ForeColor = Color.White;
//arg_grid.Font = new System.Drawing.Font("Calibri", 15, FontStyle.Bold);
//arg_grid.Col = arg_icol + 1;
//arg_grid.Text = "L";
//arg_grid.BackColor = Color.LightSkyBlue;
//// arg_grid.ForeColor = Color.White;
//arg_grid.Font = new System.Drawing.Font("Calibri", 15, FontStyle.Bold);
//arg_grid.Col = arg_icol + 2;
//arg_grid.Text = "R";
//arg_grid.BackColor = Color.LightSkyBlue;
//// arg_grid.ForeColor = Color.White;
//arg_grid.Font = new System.Drawing.Font("Calibri", 15, FontStyle.Bold);
}
catch
{ }
}
private void create_grid(AxFPUSpreadADO.AxfpSpread arg_Grid, DataTable dtData)//, DataTable dtGrid)
{
try
{
arg_Grid.Visible = false;
int iMaxCol = dtData.Columns.Count - 1;
arg_Grid.MaxRows = 3;
arg_Grid.MaxRows = dtData.Rows.Count + 3;
/*
*
* // arg_Grid.MaxRows = dtData.Rows.Count -2;
* // axGrid.ClearRange(0, 4, 100, 100, false);
*
* arg_Grid.Reset();
* arg_Grid.DisplayColHeaders = false;
* arg_Grid.DisplayRowHeaders = false;
* arg_Grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
* arg_Grid.ColHeaderRows = 0;
*
* arg_Grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
* arg_Grid.Font = new System.Drawing.Font("Calibri", 10.25F, FontStyle.Bold);
*
* arg_Grid.RowsFrozen = 3;
* arg_Grid.ColsFrozen = 1;
*
* //arg_Grid.Row = 1;
* // arg_Grid.BackColor = Color.Gray;
* // arg_Grid.ForeColor = Color.White;
* arg_Grid.AddCellSpan(2, 1, 4, 1);
* arg_Grid.AddCellSpan(6, 1, 4, 1);
* arg_Grid.AddCellSpan(10, 1, 4, 1);
* arg_Grid.AddCellSpan(14, 1, 4, 1);
* arg_Grid.AddCellSpan(18, 1, 4, 1);
* arg_Grid.AddCellSpan(22, 1, 4, 1);
* arg_Grid.AddCellSpan(26, 1, 4, 1);
*
* //// cells
* arg_Grid.TypeEditMultiLine = true;
* arg_Grid.MaxCols = iMaxCol;
* arg_Grid.SetCellBorder(1, 1, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
* arg_Grid.SetCellBorder(1, 1, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
* arg_Grid.SetCellBorder(1, 1, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexRight, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
* arg_Grid.SetCellBorder(1, 2, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
* arg_Grid.SetCellBorder(1, 2, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
* arg_Grid.SetCellBorder(1, 2, iMaxCol, arg_Grid.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexRight, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid);
*
* //for (int i = 1; i < arg_Grid.MaxRows; i++)
* //{
*
* // arg_Grid.Row = i;
* // // arg_Grid.Col = 1;
* // arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignRight;
* // if (i == 1)
* // {
* // arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
* // arg_Grid.Font = new System.Drawing.Font("Calibri", 12.25F, FontStyle.Bold);
* // arg_Grid.BackColor = Color.Gray;
* // arg_Grid.ForeColor = Color.White;
* // }
* // else if (i == 2)
* // {
* // arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
* // arg_Grid.Font = new System.Drawing.Font("Calibri", 10.25F, FontStyle.Bold);
* // arg_Grid.BackColor = Color.LightGray;
* // arg_Grid.ForeColor = Color.White;
* // }
* // else if (i == 3)
* // {
* // arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
* // arg_Grid.Font = new System.Drawing.Font("Calibri", 10.25F, FontStyle.Bold);
* // arg_Grid.BackColor = Color.LightSalmon;
* // arg_Grid.ForeColor = Color.White;
* // }
* // //else if (i > 3)
* // //{
* // // arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignRight;
* // // arg_Grid.BackColor = Color.White;
* // // arg_Grid.ForeColor = Color.Black;
* // //}
*
* // else
* // {
* // arg_Grid.BackColor = Color.White;
* // arg_Grid.ForeColor = Color.Black;
* // }
* // arg_Grid.set_RowHeight(i, 25);
*
* //}
* arg_Grid.Row = -1;
* arg_Grid.Col = 1;
*/
/// -----------row header------------------------------
arg_Grid.Row = 1;
arg_Grid.set_RowHeight(1, 30);
int iDtRow = dtData == null || dtData.Rows.Count == 0 ? 50 : dtData.Rows.Count;
// int iDtCol = dtData == null || dtData.Columns.Count == 0 ? 29 : dtData.Columns.Count;
if (iDtRow > 8)
{
//iColName = "COL_WIDTH_SCOLL";
arg_Grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsVertical;
arg_Grid.ScrollBarWidth = 20;
}
else
{
arg_Grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsNone;
}
// arg_Grid.MaxRows = iDtRow + arg_Grid.RowsFrozen;
for (int i = 0; i < iMaxCol; i++)
{
arg_Grid.Col = i + 1;
}
///
/// --------add data------------------------------
///
if (dtData == null || dtData.Rows.Count == 0)
{
return;
}
else
{
double[] totalAvg = new double[dtData.Columns.Count];
double temp = 0.0;
for (int icol = 0; icol < dtData.Columns.Count; icol++)
{
arg_Grid.SetText(icol + 1, 1, dtData.Columns[icol + 1].ColumnName.Replace("'", "").Split('\n')[0]);
if (icol < dtData.Columns.Count - 2)
{
arg_Grid.SetText(icol + 2, 2, dtData.Columns[icol + 2].ColumnName.Replace("'", "").Split('\n')[1]);
}
if (icol == 1)
{
arg_Grid.set_ColWidth(1, 26.5);
}
if (icol >= 2)
{
arg_Grid.set_ColWidth(icol, 7.25);
}
arg_Grid.SetText(1, 1, "Week");
arg_Grid.SetText(1, 2, "Model");
// arg_Grid.SetText( 1, 3, "Total");
for (int i = 0; i < dtData.Rows.Count - 1; i++)
{
//if (icol >= 2 && i >= 3)
//{
// arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignRight;
// // arg_Grid.Font = new System.Drawing.Font("Calibri", 10.25F, FontStyle.Regular);
//}
// Rate.
if (dtData.Columns[icol + 1].ColumnName.Contains("%"))
{
double.TryParse(dtData.Rows[i][icol + 1].ToString(), out temp);
if (!string.IsNullOrWhiteSpace(dtData.Rows[i][icol + 1].ToString()) && temp > 0)
{
string rate = dtData.Rows[i][icol + 1].ToString() + "%";
arg_Grid.SetText(icol + 1, i + 3, rate);
}
}
// Remains.
else
{
double.TryParse(dtData.Rows[i][icol + 1].ToString(), out temp);
if (temp > 0)
{
arg_Grid.SetText(icol + 1, i + 3, FormatNumber(dtData.Rows[i][icol + 1].ToString()));
}
else
{
arg_Grid.SetText(icol + 1, i + 3, dtData.Rows[i][icol + 1].ToString());
}
}
//if (icol == 1)
//{
// arg_Grid.Col = 1;
// arg_Grid.Row = i;
// arg_Grid.Font = new Font(arg_Grid.Font.FontFamily, arg_Grid.Font.Size, FontStyle.Bold);
//}
//if (icol >= 2 && i > 4)
//{
// arg_Grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignRight;
// arg_Grid.Font = new System.Drawing.Font("Calibri", 10.25F, FontStyle.Regular);
//}
}
}
// this.axGrid.Show();
// WarehouseMaterialSystem.ClassLib.WinAPI.AnimateWindow(this.axDetail.Handle, 400, WarehouseMaterialSystem.ClassLib.WinAPI.getSlidType("5"));
}
}
catch (Exception)
{
}
}
private void DisplayGridTop(DataTable arg_dt, AxFPUSpreadADO.AxfpSpread arg_grid)
{
try
{
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
// Set Default Grid
arg_grid.Visible = false;
arg_grid.Reset();
arg_grid.BorderStyle = FPUSpreadADO.BorderStyleConstants.BorderStyleNone;
arg_grid.DisplayColHeaders = false;
arg_grid.DisplayRowHeaders = false;
arg_grid.ActiveCellHighlightStyle = FPUSpreadADO.ActiveCellHighlightStyleConstants.ActiveCellHighlightStyleOff;
arg_grid.ColHeaderRows = 0;
arg_grid.ScrollBars = FPUSpreadADO.ScrollBarsConstants.ScrollBarsNone;
arg_grid.Font = new System.Drawing.Font("Calibri", 10);
arg_grid.set_RowHeight(1, 0.5);
arg_grid.set_ColWidth(1, 0.5);
arg_grid.TypeHAlign = FPUSpreadADO.TypeHAlignConstants.TypeHAlignCenter;
arg_grid.TypeVAlign = FPUSpreadADO.TypeVAlignConstants.TypeVAlignCenter;
arg_grid.TypeEditMultiLine = true;
arg_grid.SetCellBorder(1, 1, 150, axGridTop.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
arg_grid.SetCellBorder(1, 1, 150, axGridTop.MaxRows, FPUSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPUSpreadADO.CellBorderStyleConstants.CellBorderStyleBlank);
for (int ic = 2; ic <= 150; ic++)
{
arg_grid.set_ColWidth(ic, 4.0);
}
int row_s = 2;
int irow = row_s;
int icol = 2;
MachineHeadTop(icol, irow, 0, arg_dt, arg_grid);
irow = row_s + 1;
MachineBodyTop(icol, irow, 0, arg_dt, arg_grid);
for (int i = 1; i < arg_dt.Rows.Count; i++)
{
if (arg_dt.Rows[i]["LINE_ID"].ToString() == arg_dt.Rows[i - 1]["LINE_ID"].ToString())
{
if (arg_dt.Rows[i]["MINI_LINE_ID"].ToString() == arg_dt.Rows[i - 1]["MINI_LINE_ID"].ToString())
{
irow++;
}
else
{
irow = row_s + 1;
icol++;
}
MachineBodyTop(icol, irow, i, arg_dt, arg_grid);
}
else
{
axGridTop.set_ColWidth(icol + 1, 0.5);
icol += 2;
irow = row_s;
MachineHeadTop(icol, irow, i, arg_dt, arg_grid);
irow = row_s + 1;
MachineBodyTop(icol, irow, i, arg_dt, arg_grid);
}
}
}
catch
{ }
finally
{
arg_grid.Visible = true;
}
}
