private void btnPaijiang_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dgTouzhuSpf.Rows) { long batchid = Convert.ToInt64(row.Cells["id"].Value); string type = "竞彩足球"; double jiangjin = Convert.ToDouble(row.Cells["jiangjin"].Value); if(jiangjin != 0) { Income income = new Income(); income.Amount = jiangjin; income.IncomeType = "中奖"; income.TouzhuID = batchid; income.TouzhuType = type; income.Operator = "吴林"; income.OperateTime = DateTime.Now; income.id = batchid; IncomeDAL dal = new IncomeDAL(); //如果没有排过奖 if(dal.HasPaijiang(income)==0) { dal.InsertIncome(income); } } } MessageBox.Show("派奖成功!"); }