参考暂存 方法 代码

//显示涨幅
publicstaticstringGet_Markup_Str(objectbuildingid)
...{
intthismonthprice=1;
intlastmonthprice=1;
intbid=Convert.ToInt32(buildingid);
stringSqlStr="select*fromhispricewherebuildingid="+bid;
SqlDataReaderDr=SqlHelper.ExecuteReader(SqlHelper.CONNECTION_STRING,CommandType.Text,SqlStr);
intthismonth=DateTime.Now.Month;
intthisyear=DateTime.Now.Year;
if(Dr.HasRows)
...{
while(Dr.Read())
...{
if((Convert.ToInt32(Dr["hmonth"])==thismonth)&&(Convert.ToInt32(Dr["hyear"])==thisyear))
...{
thismonthprice=Convert.ToInt32(Dr["price"]);
}

if((Convert.ToInt32(Dr["hmonth"])==(thismonth-1))&&(Convert.ToInt32(Dr["hyear"])==thisyear))
...{
thismonthprice=Convert.ToInt32(Dr["price"]);
}

}
}
Dr.Close();

//计算涨幅
floatmark=(thismonthprice-lastmonthprice)/thismonthprice*100;
if(mark>0)
return"<spanstyle='color:#ff0000'>↑</span>"+String.Format("{0:N2}",Math.Abs(mark))+"%";
else
return"<spanstyle='color:#009900'>↓</span>"+String.Format("{0:N2}",Math.Abs(mark))+"%";

}