/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(NoticeMOD mod)
{
string sqlCommandString = "Update Notice Set Title=@Title, contents=@contents";
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@Title", mod.Title);
arParams[1] = new SqlParameter("@contents", mod.Contents);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(NoticeMOD mod)
{
string sqlCommandString = "Insert Into Notice(title,contents)Values(@title,@contents)";
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@title", mod.Title);
arParams[1] = new SqlParameter("@contents", mod.Contents);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 根据主键id查询信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static NoticeMOD GetmodByid(int id)
{
NoticeMOD mod = new NoticeMOD();
string sqlcommandString = "select * from Notice where imgId=" + id;
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString);
if (reader.Read())
{
mod.Contents = reader["Contents"].ToString();
mod.Title = reader["Title"].ToString();
mod.NoticeId = Convert.ToInt32(reader["NoticeId"].ToString());
}
reader.Close();
return mod;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(NoticeMOD mod)
{
return NoticeDAO.Updatemod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(NoticeMOD mod)
{
return NoticeDAO.Insertmod(mod);
}