private void BindGrid(string incomeType) { DataSet ds = new DataSet(); ds = new IncomeDAL().GetIncomeDetails(incomeType); dgvIncome.DataSource = ds.Tables[0]; }
private void GetAllAmount() { IncomeDAL dal = new IncomeDAL(); double chongzhijine = dal.GetTotalAmount("充值"); double goujiangjine = dal.GetTotalAmount("购奖"); double zhongjiangjine = dal.GetTotalAmount("中奖"); lblZongjine.Text = chongzhijine.ToString(); lblGoujiangjine.Text = goujiangjine.ToString(); lblZhongjiangjine.Text = zhongjiangjine.ToString(); lblYue.Text = (chongzhijine + zhongjiangjine - goujiangjine).ToString(); }
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("派奖成功!"); }