public override string ToString()
{
return(String.Concat(new string[]
{ " ProductID:", ProductID.ToString(),
" Description ", Description,
" Quantity: ", QTY.ToString(),
" Unit Price: ", UnitPrice.ToString(),
" CategoryID: ", CategoryID.ToString() }));
}
/// <summary>
/// 加载栈料列表+低料预警列表
/// </summary>
private void LoadStackMaterialList(string programName)
{
if (programName == string.Empty)
{
return;
}
CDBConnection.SQL = "SELECT A.Code PROGRAM_NAME, B.ID,B.Code, B.[Address], B.CompoentNO, B.QTY-B.UsedQTY AS QTY " +
"FROM TB_QMS_ProgramList A, TB_QMS_ProgramList B " +
"WHERE A.Code ='" + programName + "' and A.ID=B.ParentID";
DataTable dtStack = CDBConnection._GetGrdInfo(CDBConnection.SQL);
// 加载栈位物料列表
TreeListView.NodeCollection collection = this.listMaterial.Nodes;
this.listMaterial.BeginUpdate();
collection.Clear();
foreach (DataRow drStack in dtStack.Rows)
{
string ID = drStack[1].ToString();
string address = drStack[3].ToString();
string material = drStack[4].ToString();
int QTY;
try
{
QTY = Int32.Parse(drStack[5].ToString());
}
catch
{
QTY = 0;
}
// 添加栈位物料父节点
// Node.m_data[3] = { staclID, MaterialName, QTY }
Node node = new Node(new object[3] {
address, material, QTY.ToString()
});
node.TextColor = (QTY > 0) ? Color.Green : Color.Black;
// 加载替换物料子节点
CDBConnection.SQL = "SELECT CompoentNO from TB_QMS_ReplaceComponentList where MainID='" + ID + "'";
DataTable dtSub = CDBConnection._GetGrdInfo(CDBConnection.SQL);
foreach (DataRow drSub in dtSub.Rows)
{
Node subNode = new Node(new object[2] {
address, drSub[0].ToString()
});
node.Nodes.Add(subNode);
}
collection.Add(node);
}
this.listMaterial.EndUpdate();
// 加载低料预警列表
this.chartWarning.Clear();
foreach (DataRow drQty in dtStack.Rows)
{
string stackNO = drQty[3].ToString().Trim();
if (stackNO == null || stackNO == string.Empty)
{
continue;
}
string strQTY = drQty[5].ToString().Trim();
if (strQTY == null || strQTY == string.Empty)
{
continue;
}
int QTY = int.Parse(strQTY.ToString());
int MinQTY = 100; // assume
this.chartWarning.Add(QTY, MinQTY, stackNO);
}
RedrawWarningChart();
}
