/// <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; }