/// <summary>
/// 创建主题
/// </summary>
/// <param name="theme"></param>
/// <returns></returns>
public int createTheme(Model.huodinfo theme)
{
try
{
SqlParameter[] paramer = new SqlParameter[] {
new SqlParameter("@category", SqlDbType.NVarChar, 50),
new SqlParameter("@themeName", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@userId", SqlDbType.NVarChar, 32),
new SqlParameter("@show", SqlDbType.NVarChar, 2),
new SqlParameter("@icon", SqlDbType.NVarChar, 300),
new SqlParameter("@point", SqlDbType.NVarChar, 2),
};
paramer[0].Value = theme.leibie ?? "";
paramer[1].Value = theme.huodName ?? "";
paramer[2].Value = theme.huodContext ?? "";
paramer[3].Value = theme.yonghubianhao ?? "";
paramer[4].Value = theme.kejian ?? "";
paramer[5].Value = theme.tubian ?? "";
paramer[6].Value = theme.jinghua ?? "";
int aa = Convert.ToInt32(DB.ExecuteScalar(cs, "createTheme", paramer));
return(aa);
}
catch (Exception ex)
{
return(-1);
}
}
public int deletehuodong(Model.huodinfo huod)
{
try
{
SqlParameter[] parme = new SqlParameter[] {
new SqlParameter("@themeID", SqlDbType.Int),
};
parme[0].Value = huod.huodId;
return(DB.ExecuteNonQuery(cs, "deleteThemeById", parme));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 更新活动表 myhome
/// </summary>
/// <param name="hd"></param>
/// <returns></returns>
public int getupdatehuodong_DLL(Model.huodinfo hd)
{
try
{
SqlParameter[] paramer = new SqlParameter[] {
new SqlParameter("@themeID", SqlDbType.Int),
new SqlParameter("@themeName", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@category", SqlDbType.NVarChar, 50)
};
paramer[0].Value = hd.huodId;
paramer[1].Value = hd.huodName ?? "";
paramer[2].Value = hd.huodContext ?? "";
paramer[3].Value = hd.leibie ?? "";
int a = DB.ExecuteNonQuery(cs, "updateTheme", paramer);
return(a);
}
catch (Exception ex)
{
return(0);
}
}
