ddddddd

string sqlCmd = string.Format(@"select c.cardnum 卡号,o.membername 会员姓名,o.mobilephone 手机号码,h.kjdje 可用积点金额,sum(c.kjdje)-h.kjdje 已用积点金额,count(c.cardnum)小票数量,sum(c.xsje) 销售合计,sum(c.kjdje) 积点合计
                            from cardup c,cardzh h,cardinfo o
                            where c.cardnum=h.cardnum and c.cardnum=o.cardnum and c.cardnum {0}
                            group by c.cardnum,o.membername,o.mobilephone,h.kjdje
                            having count(c.cardnum)>={1} and (sum(c.kjdje)>={2} and sum(c.kjdje)<={3})", kh, numericUpDown1.Value,textBoxJdjeks.Text,textBoxJdjejs.Text);  
            DataSet ds = new DataSet();
            using (OracleDataAdapter da1 = new OracleDataAdapter(sqlCmd, db._conn))
            {
                da1.Fill(ds, "mcardup");
            }

            sqlCmd = @"select * from RE_KYKFX K order by K.卡号 desc";
            using (OracleDataAdapter da1 = new OracleDataAdapter(sqlCmd, db._conn))
            {
                da1.Fill(ds, "scardup");
            }
            DataColumn parentCol = ds.Tables["mcardup"].Columns["卡号"];
            DataColumn childCol = ds.Tables["scardup"].Columns["卡号"];
            try
            {
                //记录明细必须和gridControl1中gridView2前面的名字完全一样
                ds.Relations.Add("记录明细", parentCol, childCol, false);  // 添加主从关系到数据集中
            }
            catch (Exception)
            {

                throw;
            }
            gridControl1.DataSource = ds.Tables["mcardup"].DefaultView;  // DataGridView 显示
            gridView1.PopulateColumns();