To create new Datatable:
private DataTable getTable(string client, string shipment, DataTable d)
{
ArrayList list = new ArrayList();
for (int row = 0; row < d.Rows.Count; row++)
{
bool exist = list.Contains(d.Rows[row]["MATNR"].ToString());
if (!exist)
list.Add(d.Rows[row]["MATNR"].ToString());
}
dt.Columns.Add("CLIENT", Type.GetType("System.String"));
dt.Columns.Add("SHPMNT", Type.GetType("System.String"));
dt.Columns.Add("QCIMAT", Type.GetType("System.String"));
dt.Columns.Add("QTY", Type.GetType("System.Int32"));
dt.Columns.Add("SHPDAT", Type.GetType("System.String"));
DataRow dr;
DataRow[] rows = null;
for (int j = 0; j < list.Count; j++)
{
int qty = 0;
rows = d.Select("MATNR='" + list[j].ToString() + "'");
if (rows.Length != 0)
{
foreach (DataRow datarow in rows)
{
qty += Int32.Parse(datarow["LFIMG"].ToString());
}
}
dr = dt.NewRow();
dr["CLIENT"] = client;
dr["SHPMNT"] = shipment;
dr["QCIMAT"] = list[j].ToString();
dr["QTY"] = qty;
dr["SHPDAT"] = rows[0]["ERDAT"].ToString();
dt.Rows.Add(dr);
}
return dt;
}
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15053694/viewspace-442438/ ,如需转载,请注明出处,否则将追究法律责任。