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