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("派奖成功!");
}
