/// <summary>
/// 获取地区Id
/// </summary>
/// <param name="regionName"></param>
/// <returns></returns>
private int GetRegionId(string regionName)
{
int rtn = 0;
if (!string.IsNullOrEmpty(regionName))
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
var dt = db.ExecuteScalar(string.Format("SELECT TOP 1 id FROM Region WHERE Name='{0}'", regionName));
if (dt != null)
{
int.TryParse(dt.ToString(), out rtn);
}
}
return(rtn);
}
/// <summary>
/// 取得挂网价等数据抓取及映射
/// </summary>
/// <returns></returns>
public string GetCrawl()
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
object 基 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionBidPricing");
object 基映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionBidPricing");
object 调 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionLimitPricing");
object 调映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionLimitPricing");
object 挂 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionPricing");
object 挂映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionPricing");
string str = string.Format("基(<span style='color:red'>{0}</span>/<span style='color:#6699FF'>{1}</span>) 调(<span style='color:red'>{2}</span>/<span style='color:#6699FF'>{3}</span>) 挂(<span style='color:red'>{4}</span>/<span style='color:#6699FF'>{5}</span>)", 基, 基映, 调, 调映, 挂, 挂映);
return(str);
}