/// <summary>
/// 更新广告实体
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public bool Update(AdvertisementInfo ad)
{
StringBuilder sql = new StringBuilder();
sql.Append("update [Advertisement] set Title=@Title and AdImgUrl=@AdImgUrl and LinkUrl=@LinkUrl and UpdatedDate=@UpdatedDate and UpdatedBy=@UpdatedBy");
sql.Append(" where Id=@Id");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Title",SqlDbType.NVarChar,50),
new SqlParameter("@AdImgUrl",SqlDbType.NVarChar,100),
new SqlParameter("@LinkUrl",SqlDbType.NVarChar,100),
new SqlParameter("@UpdatedDate",SqlDbType.DateTime),
new SqlParameter("@UpdatedBy",SqlDbType.NVarChar,20)
};
parms[0].Value = ad.Title;
parms[1].Value = ad.Image_Url;
parms[2].Value = ad.Link_Url;
parms[3].Value = ad.Updated_Date;
parms[4].Value = ad.Updated_By;
int val = SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms);
return val > 0;
}
/// <summary>
/// 增加一个广告
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public bool Insert(AdvertisementInfo ad)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into [Advertisement](Title,AdImgUrl,LinkUrl,CreatedDate,CreatedBy)");
sql.Append("values(@Title,@AdImgUrl,@LinkUrl,@CreatedDate,@CreatedBy)");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Title",SqlDbType.NVarChar,50),
new SqlParameter("@AdImgUrl",SqlDbType.NVarChar,100),
new SqlParameter("@LinkUrl",SqlDbType.NVarChar,100),
new SqlParameter("@CreatedDate",SqlDbType.DateTime),
new SqlParameter("@CreatedBy",SqlDbType.NVarChar,20)
};
parms[0].Value = ad.Title;
parms[1].Value = ad.Image_Url;
parms[2].Value = ad.Link_Url;
parms[3].Value = ad.Created_Date;
parms[4].Value = ad.Created_By;
int val = SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms);
return val > 0;
}
/// <summary>
/// 根据Ad_Id获取广告信息
/// </summary>
/// <param name="Ad_Id"></param>
/// <returns></returns>
public AdvertisementInfo GetById(int Ad_Id)
{
AdvertisementInfo ad = new AdvertisementInfo();
StringBuilder sql = new StringBuilder();
sql.Append("select Ad_Id,image_url,title,Link_Url from BigDog_Advertisement where Ad_Id='" + Ad_Id + "'");
DataTable dt = new DataTable();
dt = OracleHelper.GetDS(sql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
ad.Id = Convert.ToInt32(dt.Rows[0][0]);
ad.Image_Url = dt.Rows[0][1].ToString();
ad.Title = dt.Rows[0][2].ToString();
ad.Link_Url = dt.Rows[0][3].ToString();
return ad;
}
else
{
ad = null;
return ad;
}
}
/// <summary>
/// 插入一条广告
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public bool Insert(AdvertisementInfo ad)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into BigDog_Advertisement(Ad_Id,image_url,title,Link_Url,created_date)values");
sql.Append("(BigDog_Advertisement_seq.nextval,@Image_Url,@Title,@Link_Url,sysdate)");
OleDbParameter[] parms = new OleDbParameter[]{
new OleDbParameter("@Image_Url",OleDbType.VarChar,100),
new OleDbParameter("@Title",OleDbType.VarChar,50),
new OleDbParameter("@Link_Url",OleDbType.VarChar,100)
};
parms[0].Value = ad.Image_Url;
parms[1].Value = ad.Title;
parms[2].Value = ad.Link_Url;
return OracleHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
/// <summary>
/// 更新广告实体
/// </summary>
/// <param name="ad"></param>
/// <returns></returns>
public bool Update(AdvertisementInfo ad)
{
StringBuilder sql = new StringBuilder();
sql.Append("update BigDog_Advertisement set Image_Url=@Image_Url,Title=@Title,Link_Url=@Link_Url,updated_date=sysdate where");
sql.Append(" Ad_Id=@Ad_Id");
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("@Image_Url",OleDbType.VarChar,100),
new OleDbParameter("@Title",OleDbType.VarChar,50),
new OleDbParameter("@Link_Url",OleDbType.VarChar,100),
new OleDbParameter("@Ad_Id",OleDbType.Integer)
};
return OracleHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
public static bool Update(AdvertisementInfo ad)
{
return Dal.Update(ad);
//return true;
}
public static bool Insert(AdvertisementInfo ad)
{
return true;
}
