/// <summary>
/// 查询总条数
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int InduyCountPageList(string Induy)
{
string num = "";
string sql = "select count(InfoID) from MerchantInfoTab where IndustryClassList like '%" + Induy + "%' ";
num = Convert.ToString(SearchDBHelper.GetSingle(sql));
return(Convert.ToInt32(num));
}
/// <summary>
/// 查询总条数
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int InduyCountPage(int areid, string Induy)
{
string num = "";
string sql = "select count(InfoID) from MerchantInfoTab where ProvinceID=@areid and IndustryClassList like '%" + Induy + "%' ";
SqlParameter[] para =
{
new SqlParameter("@areid", SqlDbType.Int, 8)
};
para[0].Value = areid;
num = Convert.ToString(SearchDBHelper.GetSingle(sql, para));
return(Convert.ToInt32(num));
}
/// <summary>
/// 翻译所属类型
/// </summary>
/// <param name="typeID"></param>
/// <returns></returns>
public string Type(int typeID)
{
string num = "";
string sql = "select TypeName from NewsTypeTab where TypeID=@typeID";
SqlParameter[] para =
{
new SqlParameter("@typeID", SqlDbType.Int, 8)
};
para[0].Value = typeID;
num = Convert.ToString(SearchDBHelper.GetSingle(sql, para));
return(num);
}
/// <summary>
/// 根据区域获取总条数
/// </summary>
/// <param name="Induy">区域</param>
/// <returns></returns>
public int GetCountByProvinceID(string ProvinceID)
{
string sql = "select count(InfoID) FROM CatialInfoTab where ProvinceID like '%" + ProvinceID + "%' ";
return(Convert.ToInt32(SearchDBHelper.GetSingle(sql)));
}
/// <summary>
/// 根据行业和区域获取总条数
/// </summary>
/// <param name="IndustryBID">行业</param>
/// <param name="Province">区域</param>
/// <returns></returns>
public int GetCountByIndustryBIDAndProvinceID(string IndustryBID, string ProvinceID)
{
string sql = "select count(InfoID) from CatialInfoTab where ProvinceID like '%" + ProvinceID + "%' and IndustryBID like '%" + IndustryBID + "%' ";
return(Convert.ToInt32(SearchDBHelper.GetSingle(sql)));
}
/// <summary>
/// 根据行业获取总条数
/// </summary>
/// <param name="Induy">行业</param>
/// <returns></returns>
public int GetCountByIndustryBID(string IndustryBID)
{
string sql = "select count(InfoID) FROM MainInfoTabTest where IndustryBID like '%" + IndustryBID + "%' ";
return(Convert.ToInt32(SearchDBHelper.GetSingle(sql)));
}
