private void FrmEditSong_Load(object sender, EventArgs e)
{
//绑定组合框
db.BindComboBox(cmbSongType, "select * from song_type", "songtype_name", "songtype_id");
if (song_id == 0)
{
return;
}
//添加信息到文本框中
btnSave.Text = "保存修改";
string sql = string.Format("select song_name,song_ab,song_word_count,songtype_id,song_url,singer_name from dbo.song_info,singer_info where song_id = '{0}' and singer_info.singer_id = song_info.singer_id", song_id);
DataSet ds = db.GetDataSet(sql);
txtSongName.Text = ds.Tables["temp"].Rows[0][0].ToString();
txtPinYin.Text = ds.Tables["temp"].Rows[0][1].ToString();
nudWordCount.Value = Convert.ToInt32(ds.Tables["temp"].Rows[0][2]);
cmbSongType.SelectedValue = Convert.ToInt32(ds.Tables["temp"].Rows[0][3]);
txtSongFileName.Text = ds.Tables["temp"].Rows[0][4].ToString();
txtSinger.Text = ds.Tables["temp"].Rows[0][5].ToString();
}
private void rdoCombination_Load(object sender, EventArgs e)
{
//性别默认选中男
rdoMale.Checked = true;
//绑定组合框
db.BindComboBox(cmbSingerType, "select * from singer_type", "singertype_name", "singertype_id");
//如果不是通过修改歌手信息启动的该窗体,就提前结束该方法
if (singer_id == 0)
{
return;
}
btnAdd.Text = "修改";
string sql = string.Format("select singer_name,singertype_id,singer_sex,singer_photo_url,singer_Describe from dbo.singer_info where singer_id = '{0}'", singer_id);
//添加歌手信息到信息编辑框内
DataSet ds = db.GetDataSet(sql);
txtName.Text = ds.Tables["temp"].Rows[0][0].ToString();
cmbSingerType.SelectedValue = Convert.ToInt32(ds.Tables["temp"].Rows[0][1]);
switch (ds.Tables["temp"].Rows[0][2].ToString())
{
case "男":
rdoMale.Checked = true;
break;
case "女":
rdoFemale.Checked = true;
break;
case "组合":
rdoCom.Checked = true;
break;
}
photoPath = ds.Tables["temp"].Rows[0][3].ToString(); //写真图片的储存路径
if (photoPath != string.Empty) //当路径不为空时
{
picSingerPhoto.Image = Image.FromFile(photoPath);
}
txtDescribe.Text = ds.Tables["temp"].Rows[0][4].ToString();
}