ITPub博客

首页 > Linux操作系统 > Linux操作系统 > To create new Datatable

To create new Datatable

原创 Linux操作系统 作者:Burgess_Liu 时间:2008-09-08 21:42:15 0 删除 编辑

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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-05

  • 博文量
    19
  • 访问量
    13994