private void button3_Click(object sender, EventArgs e)
{
string sql;
modaname2 = comboBox4.Text.Replace("'", "''");
modtime2 = comboBox5.Text;
/* if (modaname2 != modaname)
{
connectSQL();
sql = "update [album] set aname='" + modaname2 + "' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改专辑名成功！", "消息");
}
if (modtime2 != modtime)
{
connectSQL();
sql = "update [album] set time='" + modtime2 + "' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改首发展会成功！", "消息");
}
connectSQL();
sql = "update [album] set cover='@cover' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("cover", SqlDbType.Image);
cmd.Parameters["cover"].Value = imagebytes;
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改专辑图片成功！", "消息");
*/
using (sqlAdapter sqladp = new sqlAdapter())
{
sql = "delete from [album] where acode='" + modacode + "'";
sqladp.ExecuteNonQuery(sql);
sql = "insert into [album] values ('" + modacode + "','" + modaname2 + "','" + modtime2 + "',@cover)";
sqladp.setCommand(sql);
sqladp.Command.Parameters.Add("cover", SqlDbType.Image);
sqladp.Command.Parameters["cover"].Value = imagebytes;
sqladp.Command.ExecuteNonQuery();
}
MessageBox.Show("修改成功！", "消息");
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox2.Text == "" || comboBox4.Text == "" || comboBox6.Text == "" || comboBox3.Text == "" || comboBox8.Text == "" || comboBox9.Text == "")
{
MessageBox.Show("请填写完整带“*”的数据", "提示");
return;
}
//________________________________________________________________________________________________
addacode = comboBox2.Text;
addaname = comboBox4.Text.Replace("'", "''");
addtime = comboBox5.Text;
addgcode = addacode.Substring(0, 4);
addtrack = comboBox6.Text;
addscode = addacode + addtrack;
addgname = comboBox3.Text.Replace("'", "''");
addorigin = comboBox12.Text;
addsname = comboBox8.Text.Replace("'", "''");
addarranger = comboBox9.Text.Replace("'", "''");
addlyric = comboBox7.Text.Replace("'", "''");
addvocal = comboBox11.Text.Replace("'", "''");
addstyle = comboBox10.Text.Replace("'", "''");
using (sqlAdapter sqladp = new sqlAdapter())
{
string sql = "select oricode from [ori] where origin = '" + addorigin + "'";
addoricode = sqladp.ExecuteScalar(sql) as string;
if (addoricode == null)
{
MessageBox.Show("没有找到原曲！", "消息提示");
Form9 Form9 = new Form9();
Form9.ShowDialog();
return;
}
sql = "select acode from [album] where acode = '" + addacode + "'";
object obj = sqladp.ExecuteScalar(sql);
if (obj == null)
{
sql = "insert into [album] values ('" + addacode + "','" + addaname + "','" + addtime + "',@cover)";
sqladp.setCommand(sql);
sqladp.Command.Parameters.Add("cover", SqlDbType.Image);
sqladp.Command.Parameters["cover"].Value = imagebytes;
sqladp.Command.ExecuteNonQuery();
}
sql = "select gcode from [group] where gcode = '" + addgcode + "'";
obj = sqladp.ExecuteScalar(sql);
//对数据库查询出的值进行判断
if (obj == null)
{
sql = "insert into [group] values ('" + addgname + "','" + addgcode + "')";
sqladp.ExecuteScalar(sql);
}
try
{
sql = "insert into [song] values ('" + addsname + "','" + addtrack + "','" + addarranger + "','" + addlyric + "','" + addvocal + "','" + addoricode + "','" + addstyle + "','" + addscode + "','" + DataPool.currentID + "')";
sqladp.ExecuteScalar(sql);
sql = "insert into [gas] values ('" + addgcode + "','" + addacode + "','" + addscode + "')";
sqladp.ExecuteScalar(sql);
MessageBox.Show("提交成功!", "提示信息");
}
catch (Exception)
{
MessageBox.Show("错误", "提示信息");
return;
}
}
}
