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