| public GetCarSales ( string modelid ) : int | ||
| modelid | string | 车型id |
| return | int | |
public int GetCarSales(string modelid)
{
const string sql1 = "select count(1) from car_info where model_id=@modelid and `status`=2 and date_format(sold_time,'%Y-%m')=date_format(now(),'%Y-%m');";
const string sql2 = "select count(1) from car_info_bak where model_id=@modelid and date_format(modifiedtime,'%Y-%m')=date_format(now(),'%Y-%m');";
var num1 = Helper.ExecuteScalar<int>(sql1, new { modelid });
var num2 = Helper.ExecuteScalar<int>(sql2, new { modelid });
return num1 + num2;
}