private void btnTouzhu_Click(object sender, EventArgs e)
{
DataGridViewRow row = dgvTaocan.SelectedRows[0];
TouzhuTaocan taocan = new TouzhuTaocan();
string type = row.Cells["Type"].Value.ToString();
int leixing = 0;
if (type == "专家推荐套餐")
{
leixing = 0;
}
else if (type == "数据模型套餐")
{
leixing = 1;
}
taocan.Touzhuleixing = leixing;
taocan.Touzhumingcheng = type;
taocan.Touzhuid = Convert.ToInt32(row.Cells["ID"].Value.ToString()) ;
int beishu = Convert.ToInt32(txtBeishu.Text);
double touru = Convert.ToDouble(row.Cells["Touru"].Value);
double jiangjin = Convert.ToDouble(row.Cells["Jiangjin"].Value);
taocan.Touzhubeishu = beishu;
taocan.Touzhujin = beishu*touru;
taocan.Jiangjin = jiangjin* beishu;
taocan.Lucky = -1;
taocan.Touzhuqishu = Convert.ToInt32(row.Cells["Qishu"].Value.ToString());
taocan.Touzhushijian = Convert.ToDateTime(row.Cells["riqi"].Value);
taocan.OperateTime = DateTime.Now;
taocan.Operator = "system";
new TouzhuTaocanDAL().InsertTouzhutaocan(taocan);
MessageBox.Show("投注成功!");
}
public int InsertTouzhutaocan(TouzhuTaocan touzhutaocan)
{
try
{
string conStr = "server=localhost;User Id=root;database=aicai;" +
"Password=root;Character Set=utf8;";
DataSet ds = new DataSet();
using (MySqlConnection mySqlCon = new MySqlConnection(conStr))
{
mySqlCon.Open();
using (MySqlCommand mySqlCom = mySqlCon.CreateCommand())
{
MySqlDataAdapter da = new MySqlDataAdapter();
string sqlStr = @"
insert into touzhu_taocan(
touzhuleixing,touzhumingcheng,touzhuid,touzhubeishu,touzhujin,jiangjin,lucky,touzhuqishu,touzhushijian,operatetime,operator
)
VALUES
(
?touzhuleixing,?touzhumingcheng,?touzhuid,?touzhubeishu,?touzhujin,?jiangjin,?lucky,?touzhuqishu,?touzhushijian,?operatetime,?operator
)
";
mySqlCom.CommandText = sqlStr;
mySqlCom.Parameters.AddWithValue("?touzhuleixing", touzhutaocan.Touzhuleixing);
mySqlCom.Parameters.AddWithValue("?touzhumingcheng", touzhutaocan.Touzhumingcheng);
mySqlCom.Parameters.AddWithValue("?touzhuid", touzhutaocan.Touzhuid);
mySqlCom.Parameters.AddWithValue("?touzhubeishu", touzhutaocan.Touzhubeishu);
mySqlCom.Parameters.AddWithValue("?touzhujin", touzhutaocan.Touzhujin);
mySqlCom.Parameters.AddWithValue("?jiangjin", touzhutaocan.Jiangjin);
mySqlCom.Parameters.AddWithValue("?lucky", touzhutaocan.Lucky);
mySqlCom.Parameters.AddWithValue("?touzhuqishu", touzhutaocan.Touzhuqishu);
mySqlCom.Parameters.AddWithValue("?touzhushijian", touzhutaocan.Touzhushijian);
mySqlCom.Parameters.AddWithValue("?operator", touzhutaocan.Operator);
mySqlCom.Parameters.AddWithValue("?operatetime", touzhutaocan.OperateTime);
mySqlCom.ExecuteScalar();
return 0;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return -1;
}
