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