//过滤异常数据
 foreach (DataRow errorRow in _errorDt.Rows)
{
        DataRow[] existsRow = dtBar.Select(string.Format("条码='{0}'", errorRow["条码"].ToString().Trim()));
        if (existsRow.Length > 0)
        {
               dtBar.Rows.Remove(existsRow[0]);
        }
}

                //将没有异常的数据添加到数据表(因为DataGridView绑定了dtDetails,所以只要修改数据源dtDetails就可以了)
                    foreach (DataRow row in dtBar.Rows)
                    {
                        //添加正常数据到DataGridView
                        DataRow newRow = dtDetails.NewRow();
                        foreach (DataColumn col in dtDetails.Columns)
                        {
                            if (col.ColumnName == "数量")//当dtBar列名和dtDetails列名不同,但字段内容一致时
                            {
                                newRow["数量"] = row["包装数"].ToString().Trim();
                            }
                            else
                            {
                                newRow[col.ColumnName] = row[col.ColumnName].ToString().Trim();//当dtBar列名和dtDetails列名相同,且字段内容一致时
                            }
                        }
                        dtDetails.Rows.Add(newRow);
                    }

posted on 2012-09-21 10:13  清风暮雨  阅读(278)  评论(0)    收藏  举报