internal static bool Delete(int id)
{
string sqlCmd = string.Format("update Info set IsDelete=1 where InfoId={0}", id.ToString());
return(MysqlHelper.ExecuteNonQuery(sqlCmd) > 0);
}
internal static bool Insert(int id, int channelId)
{
string sqlCmd = string.Format("insert Channel_Info_Relation(ChannelId,InfoId,CreateTime) values ({0},{1},{2})", channelId.ToString(), id.ToString(), "now()");
return(MysqlHelper.ExecuteNonQuery(sqlCmd) > 0);
}
internal static bool Edit(int userId, int infoId, int channelId, int ShowSort, string infoTitle, string infoContent, bool Enable, string TitleImg)
{
string sqlCmd = string.Format("update Info set ShowSort={0},InfoTitle='{1}',InfoContent='{2}',TitleImg='{3}',Enable={4},ModifyTime=now(),ModifyBy={5} where InfoId={6}", ShowSort.ToString(), infoTitle, infoContent, TitleImg, Enable ? "1" : "0", userId.ToString(), infoId.ToString());
return(MysqlHelper.ExecuteNonQuery(sqlCmd) > 0);
}
