private void comboBox6_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
comboBox12.Items.Clear();
comboBox9.Items.Clear();
modtrack = comboBox6.Text;
modscode = modacode + modtrack;
List<DataTable> dt;
List<ComboBox> CB = new List<ComboBox>(6);
CB.Add(comboBox7);
CB.Add(comboBox8);
CB.Add(comboBox9);
CB.Add(comboBox10);
CB.Add(comboBox11);
CB.Add(comboBox12);
DataSet modOrigin = new DataSet();
try
{
using (sqlAdapter sqladp = new sqlAdapter())
{
sqladp.getDataSet("select origin from [ori],song where ori.oricode=song.oricode and scode='" + modscode + "'",out modOrigin);
modorigin = modOrigin.Tables[0].Rows[0][0].ToString();
sqladp.getDataTables(out dt, "select lyric from [song] where scode='" + modscode + "'",
"select sname from [song] where scode='" + modscode + "'", "select arranger from [song] where scode='" + modscode + "'",
"select style from [song] where scode='" + modscode + "'", "select vocal from [song] where scode='" + modscode + "'",
"select distinct origin from [ori]");
string sql = "select oricode from [ori] where origin = '" + modorigin + "'";
modoricode = sqladp.ExecuteScalar(sql) as string;
}
Program.fillIn(ref dt, ref CB);
comboBox12.SelectedIndex = comboBox12.Items.IndexOf(modorigin);
}
catch(Exception) { MessageBox.Show("无此曲目", "提示"); }
}
private void Form4_Load(object sender, EventArgs e)
{
// imagebytes = ImageToStream(".\\x.jpg");
// imagebytes[0] =0;
imagebytes = new byte[1];
imagebytes[0] = 0;
List<ComboBox> CB = new List<ComboBox>(11);
List<DataTable> dt;
CB.Add(comboBox2);
CB.Add(comboBox3);
CB.Add(comboBox4);
CB.Add(comboBox5);
CB.Add(comboBox6);
CB.Add(comboBox7);
CB.Add(comboBox8);
CB.Add(comboBox9);
CB.Add(comboBox10);
CB.Add(comboBox11);
CB.Add(comboBox12);
using (sqlAdapter sqladp = new sqlAdapter())
{
try
{
sqladp.getDataTables(out dt, "select distinct acode from [album]",
"select distinct gname from [group]", "select distinct aname from [album]",
"select distinct [time] from [album]", "select distinct track from [song]",
"select distinct lyric from [song]", "select distinct sname from [song]",
"select distinct arranger from [song]", "select distinct style from [song]",
"select distinct vocal from [song]", "select distinct origin from [ori]");
Program.fillIn(ref dt, ref CB);
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message);
}
}
//comboBox2.SelectedIndex = 0;
//for (int i = 0; i < ds3.Tables[0].Rows.Count; i++)
//{
// comboBox3.Items.Add(ds3.Tables[0].Rows[i][0]);
//}
//comboBox3.SelectedIndex = 0;
//for (int i = 0; i < ds4.Tables[0].Rows.Count; i++)
//{
// comboBox4.Items.Add(ds4.Tables[0].Rows[i][0]);
//}
//comboBox4.SelectedIndex = 0;
//for (int i = 0; i < ds5.Tables[0].Rows.Count; i++)
//{
// comboBox5.Items.Add(ds5.Tables[0].Rows[i][0]);
//}
//comboBox5.SelectedIndex = 0;
//for (int i = 0; i < ds6.Tables[0].Rows.Count; i++)
//{
// comboBox6.Items.Add(ds6.Tables[0].Rows[i][0]);
//}
//comboBox6.SelectedIndex = 0;
//for (int i = 0; i < ds7.Tables[0].Rows.Count; i++)
//{
// comboBox7.Items.Add(ds7.Tables[0].Rows[i][0]);
//}
//comboBox7.SelectedIndex = 0;
//for (int i = 0; i < ds8.Tables[0].Rows.Count; i++)
//{
// comboBox8.Items.Add(ds8.Tables[0].Rows[i][0]);
//}
//comboBox8.SelectedIndex = 0;
//for (int i = 0; i < ds9.Tables[0].Rows.Count; i++)
//{
// comboBox9.Items.Add(ds9.Tables[0].Rows[i][0]);
//}
//comboBox9.SelectedIndex = 0;
//for (int i = 0; i < ds10.Tables[0].Rows.Count; i++)
//{
// comboBox10.Items.Add(ds10.Tables[0].Rows[i][0]);
//}
//comboBox10.SelectedIndex = 0;
//for (int i = 0; i < ds11.Tables[0].Rows.Count; i++)
//{
// comboBox11.Items.Add(ds11.Tables[0].Rows[i][0]);
//}
//comboBox11.SelectedIndex = 0;
//for (int i = 0; i < ds12.Tables[0].Rows.Count; i++)
//{
// comboBox12.Items.Add(ds12.Tables[0].Rows[i][0]);
//}
//comboBox12.SelectedIndex = 0;
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds6 = new DataSet();
comboBox1.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
comboBox12.Items.Clear();
comboBox9.Items.Clear();
modacode = comboBox2.Text;
modgcode = modacode.Substring(0, 4);
List<DataTable> dt;
List<ComboBox> CB = new List<ComboBox>(4);
CB.Add(comboBox3);
CB.Add(comboBox4);
CB.Add(comboBox5);
CB.Add(comboBox6);
using (sqlAdapter sqladp = new sqlAdapter())
{
try
{
sqladp.getDataTables(out dt,"select distinct gcode from [gas] where acode='" + modacode + "'");
for (int i = 0; i < dt[0].Rows.Count; i++)
{
comboBox1.Items.Add(dt[0].Rows[i][0]);
}
comboBox1.SelectedIndex = 0;
modgcode = comboBox1.Text;
sqladp.getDataTables(out dt, "select gname from [group] where gcode='" + modgcode + "'", "select aname from [album] where acode='" + modacode + "'",
"select [time] from [album] where acode='" + modacode + "'",
"select distinct track from [song],gas where gas.scode=song.scode and acode='" + modacode + "'");
comboBox6.Items.Clear();
Program.fillIn(ref dt, ref CB);
modgcode = comboBox1.Text;
modgname = comboBox3.Text;
modaname = comboBox4.Text;
modtime = comboBox5.Text;
comboBox6.SelectedIndex = 0;
}
catch(Exception) { MessageBox.Show("无此曲目", "提示"); }
}
pictureBox1.Image = null;
// byte[] imagebytes = null;
using (sqlAdapter sqladp = new sqlAdapter())
{
SqlDataReader dr;
sqladp.getExecuteReader(out dr,"select cover from album where acode='" + modacode + "'");
while (dr.Read())
{
imagebytes1 = (byte[])dr.GetValue(0);
}
dr.Close();
}
if (imagebytes1 != null)
{
if (imagebytes1[0] == 0)
{
pictureBox1.Image = touhou_music.Properties.Resources.x;
return;
}
MemoryStream ms = new MemoryStream(imagebytes1);
Bitmap bmpt = new Bitmap(ms);
//Image image = Image.FromStream(ms, true);
//dr.Close();
//closeSQL();
pictureBox1.Image = bmpt;
}
}
private void button1_Click(object sender, EventArgs e)
{
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
comboBox12.Items.Clear();
List<ComboBox> CB = new List<ComboBox>(9);
List<DataTable> dt;
CB.Add(comboBox3);
CB.Add(comboBox4);
CB.Add(comboBox5);
CB.Add(comboBox7);
CB.Add(comboBox8);
CB.Add(comboBox9);
CB.Add(comboBox10);
CB.Add(comboBox11);
CB.Add(comboBox12);
modacode = comboBox2.Text;
modtrack = comboBox6.Text;
modscode = modacode + modtrack;
modgcode = modacode.Substring(0, 4);
using (sqlAdapter sqladp = new sqlAdapter())
{
try
{
sqladp.getDataTables(out dt, "select gname from [group] where gcode='" + modgcode + "'",
"select aname from [album] where acode='" + modacode + "'", "select [time] from [album] where acode='" + modacode + "'",
"select lyric from [song] where scode='" + modscode + "'","select sname from [song] where scode='" + modscode + "'",
"select arranger from [song] where scode='" + modscode + "'","select style from [song] where scode='" + modscode + "'",
"select vocal from [song] where scode='" + modscode + "'",
"select origin from [ori],song where ori.oricode=song.oricode and scode='" + modscode + "'");
for (int i = 0; i < dt.Count; i++)
{
try
{
for (int j = 0; j < dt[i].Rows.Count; j++)
{
CB[i].Items.Add(dt[i].Rows[j][0]);
}
CB.ElementAt(i).SelectedIndex = 0;
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message);
MessageBox.Show("无此曲目", "提示");
}
}
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.Write(ex.Message);
}
//modgname = comboBox3.Text;
//modaname = comboBox4.Text;
//modtime = comboBox5.Text;
// modacode = comboBox2.Text;
// modtrack = comboBox6.Text;
}
}
