DataTable table = SelectTable();
TableCell tableCell;
TableRow tableRow;
for (int i = 0; i < table.Rows.Count; i++)
{
tableRow = new TableRow();
//显示系列
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["系列"].ToString();
if (tableCell.Text.Equals("内销"))
{
if (SaleInCell == null)
{
SaleInCell = tableCell;
SaleInCell.BackColor = System.Drawing.Color.Red;
SaleInCell.RowSpan = 1;
}
else
{
tableCell.Visible = false;
SaleInCell.RowSpan += 1;
}
}
else if (tableCell.Text.Equals("外销"))
{
if (SaleOutCell == null)
{
SaleOutCell = tableCell;
SaleOutCell.RowSpan = 1;
}
else
{
tableCell.Visible = false;
SaleOutCell.RowSpan += 1;
}
}
tableRow.Cells.Add(tableCell);
//显示产品类别
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["产品类别"].ToString();
tableRow.Cells.Add(tableCell);
//显示产品编号
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["产品编号"].ToString();
tableRow.Cells.Add(tableCell);
//显示业务订单
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["业务订单"].ToString();
tableRow.Cells.Add(tableCell);
//显示库存
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["库存"].ToString();
tableRow.Cells.Add(tableCell);
//显示出货数量
tableCell = new TableCell();
tableCell.Text = table.Rows[i]["出货数量"].ToString();
tableRow.Cells.Add(tableCell);
Table1.Rows.Add(tableRow);
}
浙公网安备 33010602011771号