/// <summary>
/// 根据广告ID获得广告信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ADModule GetAdById(string id)
{
DataTable data = new SqlDBHelper().ExecuteQuery(String.Format(GetAdByIdSqlCmdTemplate, id));
ADModule ad = new ADModule()
{
ADSysno = id.ToString().Trim(),
ADName = data.Rows[0]["ADName"].ToString().Trim(),
Status = int.Parse(data.Rows[0]["Status"].ToString().Trim()),
OrderNum = int.Parse(data.Rows[0]["OrderNum"].ToString().Trim()),
ADImg = data.Rows[0]["ADImg"].ToString().Trim(),
ADLink = data.Rows[0]["ADLink"].ToString().Trim(),
PostionId = int.Parse(data.Rows[0]["PositionID"].ToString().Trim()),
};
return(ad);
}
/// <summary>
/// 修改一个广告
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public static bool UpdateAd(ADModule ad)
{
string sqlCmd = String.Format(UpdateADSqlCmdTemplate, ad.ADName, ad.PostionId, ad.Status, ad.ADImg, ad.ADLink, ad.OrderNum, ad.ADSysno);
try
{
if (new SqlDBHelper().ExecuteNonQuery(sqlCmd) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 修改一个广告
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public static bool UpdateAd(ADModule ad)
{
string sqlCmd = String.Format(UpdateADSqlCmdTemplate, ad.ADName, ad.PostionId, ad.Status, ad.ADImg, ad.ADLink, ad.OrderNum, ad.ADSysno);
try
{
if (new SqlDBHelper().ExecuteNonQuery(sqlCmd) > 0)
{
return true;
}
else
{
return false;
}
}
catch
{
return false;
}
}
/// <summary>
/// 根据广告ID获得广告信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ADModule GetAdById(string id)
{
DataTable data = new SqlDBHelper().ExecuteQuery(String.Format(GetAdByIdSqlCmdTemplate, id));
ADModule ad = new ADModule()
{
ADSysno = id.ToString().Trim(),
ADName = data.Rows[0]["ADName"].ToString().Trim(),
Status = int.Parse(data.Rows[0]["Status"].ToString().Trim()),
OrderNum = int.Parse(data.Rows[0]["OrderNum"].ToString().Trim()),
ADImg = data.Rows[0]["ADImg"].ToString().Trim(),
ADLink = data.Rows[0]["ADLink"].ToString().Trim(),
PostionId = int.Parse(data.Rows[0]["PositionID"].ToString().Trim()),
};
return ad;
}
