private void btnSearch_Click(object sender, EventArgs e)
        {
            string  riqi = dtpTouzhuDate.Value.Date.ToString("yyyy-MM-dd");
            DataSet ds   = new TouzhuSpfDAL().SearchTouzhuSpf(riqi);

            dgTouzhuSpf.DataSource = ds.Tables[0];
        }
        private void btnTouzhu_Click(object sender, EventArgs e)
        {
            //先获取选中的两行
            List <DataGridViewRow> rows = new List <DataGridViewRow>();

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (row.DefaultCellStyle.BackColor == Color.Green)
                {
                    rows.Add(row);
                }
            }
            TouzhuSpfDAL dal = new TouzhuSpfDAL();
            TouzhuSpf    spf = new TouzhuSpf();

            long batchid = Convert.ToInt64(DateTime.Now.ToString("MMddhhmmss") + DateTime.Now.Millisecond);

            spf.BatchID = batchid;
            spf.Beishu  = 1000;
            spf.Riqi    = rows[0].Cells["时间"].Value.ToString() + "," + rows[1].Cells["时间"].Value.ToString();
            spf.Zhudui  = rows[0].Cells["主队"].Value.ToString() + "," + rows[1].Cells["主队"].Value.ToString();
            spf.Kedui   = rows[0].Cells["客队"].Value.ToString() + "," + rows[1].Cells["客队"].Value.ToString();
            spf.Result  = rows[0].Cells["预测结果"].Value.ToString() + "," + rows[1].Cells["预测结果"].Value.ToString();
            spf.Rangqiu = rows[0].Cells["让球数"].Value.ToString() + "," + rows[1].Cells["让球数"].Value.ToString();
            spf.Peilv   = rows[0].Cells["赔率"].Value.ToString() + "," + rows[1].Cells["赔率"].Value.ToString();

            spf.Lucky       = -1;
            spf.OperateTime = DateTime.Now;
            spf.Operator    = "系统随机推荐";
            dal.InsertTouzhuSpf(spf);

            MessageBox.Show("投注成功!");
        }
        private void BindGrid()
        {
            DataSet ds = new TouzhuSpfDAL().SearchTouzhuSpf("");

            dgTouzhuSpf.DataSource = ds.Tables[0];
        }