//获取歌曲库类别
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);
}
