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