/// <summary> /// 新增报价信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool InserBidInfo(BidInfo info) { if (info == null) { return false; } int result = DAL.InserBidInfo(info); if (result > 0) { return true; } else { return false; } }
/// <summary> /// 新增报价信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public int InserBidInfo(BidInfo info) { string sql = @"insert into bidinfo (Price,ForeclosedId,PriceDate,FromAddress,Contact,Remark) values (@Price,@ForeclosedId,@PriceDate,@FromAddress,@Contact,@Remark)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Price",info.Price), new SqlParameter("@ForeclosedId",info.ForeclosedId), new SqlParameter("@PriceDate",info.PriceDate), new SqlParameter("@FromAddress",info.FromAddress), new SqlParameter("@Contact",info.Contact), new SqlParameter("@Remark",info.Remark) }; int rowAffected = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); if (rowAffected > 0) { sql = "UPDATE dbo.ForeclosedInfo SET HighPrice=(select top 1 Price from bidinfo where foreclosedid = " + info.ForeclosedId + " order by price desc) WHERE ForeclosedId=" + info.ForeclosedId; rowAffected = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); } return rowAffected; }