コード例 #1
0
        /// <summary>
        /// 运算
        /// </summary>
        /// <param name="sourcedt">明细记录DT</param>
        /// <returns></returns>
        public DataTable Generatedt(DataTable sourcedt)
        {
            var resultdt = new DataTable();
            var id       = 1;

            try
            {
                //获取导出临时表
                resultdt = dbList.Get_FinalEmptydt();
                //循环将对应数据获取
                foreach (DataRow rows in sourcedt.Rows)
                {
                    var newrow = resultdt.NewRow();
                    newrow[0]  = rows[0];               //供方
                    newrow[2]  = id;                    //序号
                    newrow[4]  = rows[4];               //物料编码
                    newrow[5]  = rows[5];               //物料描述
                    newrow[6]  = rows[6];               //单位
                    newrow[7]  = rows[7];               //送货数量
                    newrow[14] = rows[12];              //制单人
                    newrow[15] = rows[13];              //发货人
                    id++;
                    resultdt.Rows.Add(newrow);
                }
            }
            catch (Exception)
            {
                resultdt.Rows.Clear();
                resultdt.Columns.Clear();
            }
            return(resultdt);
        }