向DataSet中追加列

  public  DataSet GetIndentByNum( string  id)
         ... {

            string sql = "select DHZZD.*,SYS_YHB.XM from DHZZD INNER JOIN SYS_YHB ON DHZZD.ZDY = SYS_YHB.YHID where DDBH = '" + id + "'";
            
            try
            ...{
                DataSet ds = null;
                ds = SqlServerHelper.Query(sql);
                ds.Tables[0].Columns.Add("CPMC", typeof(string));
                ds.Tables[0].Columns.Add("KHMC", typeof(string));
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                ...{
                    ds.Tables[0].Rows[i]["CPMC"] = XZD_Product.GetProductNameByNo(ds.Tables[0].Rows[i]["CPBH"].ToString());
                    ds.Tables[0].Rows[i]["KHMC"] = XZD_Custom.GetCustomNameByNo(ds.Tables[0].Rows[i]["KHBH"].ToString());
                }
                return ds;
            }
            catch
            ...{
                return null;
            }
           
        }