private void btnAdd_Click(object sender, EventArgs e) { //非空验证 if (txtName.Text == "" || Convert.ToInt32(cmbSingerType.SelectedValue) == -1) { HintMessageBox.Warning_hint("请填写完整带*项的信息!!"); return; } //获取性别 string sex; if (rdoMale.Checked == true) { sex = rdoMale.Text; } else if (rdoFemale.Checked == true) { sex = rdoFemale.Text; } else { sex = rdoCom.Text; } //获取用户输入的值 string name = txtName.Text.Trim(); //获取歌手姓名 int singerType = Convert.ToInt32(cmbSingerType.SelectedValue); //歌手类型 photoPath = photoPath == "" ? System.IO.Path.GetFullPath(ofd.FileName): photoPath; //歌手写真的路径 string describe = txtDescribe.Text.Trim(); //歌手简介 //sql语句 string sql = string.Empty; switch (btnAdd.Text.Trim()) { case "添加": //执行数据库插入操作的sql语句 sql = string.Format("insert singer_info values('{0}','{1}','{2}','{3}','{4}')", name, singerType, sex, photoPath, describe); break; case "修改": sql = string.Format("update dbo.singer_info set singer_name = '{0}',singertype_id = '{1}',singer_sex = '{2}',singer_photo_url = '{3}',singer_Describe = '{4}' where singer_id = '{5}'", name, singerType, sex, photoPath, describe, singer_id); break; } if (db.ExecuteNonQuery(sql) > 0) { HintMessageBox.Information_hint(btnAdd.Text.Trim() + "歌手信息成功!!"); } else { HintMessageBox.Warning_hint(btnAdd.Text.Trim() + "失败!!"); } }
/// <summary> /// 保存修改按钮单击事件 /// </summary> /// <param name="sender">事件源</param> /// <param name="e">事件参数</param> private void btnSave_Click(object sender, EventArgs e) { ////如果歌曲路径字符串为空则更改歌手写真路径 //sql = song_path == string.Empty ? string.Format("update singer_info set singer_photo_url = '{0}'", txtNewPath.Text) : string.Format("update song_info set song_url = '{0}'", txtNewPath.Text); //if (db.ExecuteNonQuery(sql)>0) //{ // HintMessageBox.Information_hint("修改路径成功!!"); // this.Close(); //} //else //{ // HintMessageBox.Information_hint("修改路径失败!!"); //} //需要将数据库中所有的记录查询出来,然后截取路径到文件名。 //显示修改进度条 pnlJinDu.Visible = true; //清空listview视图 lvInfo.Items.Clear(); //sql语句-->查询 string sql = string.Empty; sql = song_path == null?string.Format("select singer_id,singer_photo_url from singer_info", txtNewPath.Text) : string.Format("select song_id,song_url from song_info", txtNewPath.Text); DataSet ds = db.GetDataSet(sql);//获得DataSet对象 //修改每条记录的绝对路径 for (int i = 0; i < ds.Tables["temp"].Rows.Count; i++) { string path = ds.Tables["temp"].Rows[i][1].ToString(); //获取记录的路径 string fileName = path.Substring(path.LastIndexOf("\\") + 1); //获取文件名 int id = Convert.ToInt32(ds.Tables["temp"].Rows[i][0]); //记录的id //sql语句 -->更新数据 string sql_ = singer_photo_path == null?string.Format("update song_info set song_url = '{0}' where song_id = '{1}'", txtNewPath.Text + fileName, id) : string.Format("update singer_info set singer_photo_url = '{0}' where singer_id = '{1}'", txtNewPath.Text + fileName, id); //更新进行更新操作的sql语句 //修改数据到数据库 ListViewItem item = new ListViewItem(); item.Text = path; //修改前的路径 item.SubItems.Add("-->"); item.SubItems.Add(txtNewPath.Text + fileName); //修改后的路径 int result = db.ExecuteNonQuery(sql_); item.SubItems.Add(result > 0 ? "修改成功!": "修改失败!!"); lvInfo.Items.Add(item); } }
private void btnSave_Click(object sender, EventArgs e) { //非空验证 if (txtSongName.Text == "" || txtPinYin.Text == "" || Convert.ToInt32(cmbSongType.SelectedValue) == -1 || txtSongFileName.Text == "") { HintMessageBox.Information_hint("请填写完整带 * 的项!!"); return; } //获取用户输入的值 string songName = txtSongName.Text; string pinYin = txtPinYin.Text; string songFileName = txtSongFileName.Text; int singer = Convert.ToInt32(db.ExecuteScalar(string.Format("select singer_id from dbo.singer_info where singer_Name = '{0}'", txtSinger.Text))); int songtype = Convert.ToInt32(cmbSongType.SelectedValue); int wordNum = Convert.ToInt32(nudWordCount.Value); string sql = ""; switch (btnSave.Text) { case "保存": sql = string.Format("insert dbo.song_info values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", songName, pinYin, wordNum, songtype, singer, songFileName, 0); break; case "保存修改": sql = string.Format("UPDATE [MyKTV].[dbo].[song_info] SET [song_name] = '{0}',[song_ab] ='{1}',[song_word_count] = '{2}',[songtype_id] = '{3}',[singer_id] = '{4}',[song_url] = '{5}' WHERE song_id='{6}'", songName, pinYin, wordNum, songtype, singer, songFileName, song_id); break; } if (db.ExecuteNonQuery(sql) > 0) { HintMessageBox.Information_hint(btnSave.Text + "歌曲成功!!"); } else { HintMessageBox.Warning_hint(btnSave.Text + "歌曲失败!!"); } }