//获取歌曲库类别 public SoundSongK selectSongK() { SoundSongK sk = new SoundSongK(); string cmdText = "select category1,category2,category3,id from songk where id=1"; DataTable dt = new DataTable(); dt = sqlhelper.ExecuteQuery(cmdText, CommandType.Text); sk.Category1 = dt.Rows[0]["category1"].ToString(); sk.Category2 = dt.Rows[0]["category2"].ToString(); sk.Category3 = dt.Rows[0]["category3"].ToString(); return sk; }
//歌曲库页类别修改 public bool upSongK(SoundSongK sk) { bool flag = false; string cmdText = "Pr_UpSongK"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@Category1", sk.Category1), new SqlParameter("@Category2", sk.Category2), new SqlParameter("@Category3", sk.Category3) }; int res = (sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure)); if (res > 0) { flag = true; } return flag; }
public bool upSongK(SoundSongK sk) { return sdao.upSongK(sk); }