/// <summary>
/// 修改广告信息
/// </summary>
/// <returns></returns>
public long UpdateMessage(Tz888.Model.advertise.ADMessageInfo message, int id)
{
long info;
string sql = "update ADMessageInfo set BID=@BID,TypeName=@TypeName,SerialID=@SerialID,"
+ "size=@size,price=@price,giving=@giving,note=@note,checkid=@checkid where positionID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", SqlDbType.Int, 8),
new SqlParameter("@BID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", SqlDbType.VarChar, 100),
new SqlParameter("@SerialID", SqlDbType.VarChar, 10),
new SqlParameter("@size", SqlDbType.VarChar, 50),
new SqlParameter("@price", SqlDbType.Float, 50),
new SqlParameter("@giving", SqlDbType.DateTime, 50),
new SqlParameter("@note", SqlDbType.VarChar, 1000),
new SqlParameter("@checkid", SqlDbType.Int, 2)
};
para[0].Value = id;
id = message.positionID;
para[1].Value = message.BID;
para[2].Value = message.TypeName;
para[3].Value = message.SerialID;
para[4].Value = message.size;
para[5].Value = message.price;
para[6].Value = message.giving;
para[7].Value = message.note;
para[8].Value = message.checkid;
info = (long)DbHelperSQL.ExecuteSql(sql, para);
return(info);
}
/// <summary>
/// 添加广告信息
/// </summary>
/// <returns></returns>
public long AddMessage(Tz888.Model.advertise.ADMessageInfo message)
{
string sql = "insert into ADMessageInfo(BID,TypeName,SerialID,size,price,giving,note,checkid) values"
+ "(@BID,@TypeName,@SerialID,@size,@price,@giving,@note,@checkid)";
SqlParameter[] para =
{
new SqlParameter("@BID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", SqlDbType.VarChar, 100),
new SqlParameter("@SerialID", SqlDbType.VarChar, 10),
new SqlParameter("@size", SqlDbType.VarChar, 50),
new SqlParameter("@price", SqlDbType.Float, 50),
new SqlParameter("@giving", SqlDbType.DateTime, 50),
new SqlParameter("@note", SqlDbType.VarChar, 1000),
new SqlParameter("@checkid", SqlDbType.Int, 2)
};
para[0].Value = message.BID;
para[1].Value = message.TypeName;
para[2].Value = message.SerialID;
para[3].Value = message.size;
para[4].Value = message.price;
para[5].Value = message.giving;
para[6].Value = message.note;
para[7].Value = message.checkid;
object info = DbHelperSQL.GetSingle(sql, para);
if (info == null)
{
return(1);
}
else
{
return(Convert.ToInt32(info));
}
}
/// <summary>
/// 修改广告信息
/// </summary>
/// <returns></returns>
public long UpdateMessage(Tz888.Model.advertise.ADMessageInfo message, int id)
{
return(dal.UpdateMessage(message, id));
}
/// <summary>
/// 添加广告信息
/// </summary>
/// <returns></returns>
public long AddMessage(Tz888.Model.advertise.ADMessageInfo message)
{
return(dal.AddMessage(message));
}
