public bool Add(AdvertisementTypeInfo ad_Type)
{
StringBuilder sql = new StringBuilder();
sql.Append(" insert into BigDog_Advertisement_Type(Ad_Id,Type_Name,Created_Date,Creator)");
sql.Append(" values(@Ad_Id,@Type_Name,@Created_Date,@Creator)");
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("@Ad_Id",OleDbType.Integer),
new OleDbParameter("@Type_Name",OleDbType.VarChar,50),
new OleDbParameter("@Created_Date",OleDbType.Date),
new OleDbParameter("@Creator",OleDbType.VarChar,50)
};
return OracleHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
public bool Update(AdvertisementTypeInfo ad_Type)
{
StringBuilder sql = new StringBuilder();
sql.Append(" update BigDog_Advertisement_Type");
return true;
}
public AdvertisementTypeInfo GetById(int id)
{
AdvertisementTypeInfo ad_type = new AdvertisementTypeInfo();
return ad_type;
}