/// <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);
}
public bool SelMerchantInfo(int infoid)
{
string sql = "select count(*) from [Search].[dbo].[MerchantInfoTab] where infoid=@infoid";
SqlParameter[] para =
{
new SqlParameter("@infoid", SqlDbType.Int, 8)
};
para[0].Value = infoid;
bool b = SearchDBHelper.Exists(sql.ToString(), para);
return(b);
}
/// <summary>
/// 根据行业ID跟区域ID获取投资信息
/// </summary>
/// <param name="PageCurrent">当前页</param>
/// <param name="IndustryBID">行业ID</param>
/// <param name="ProvinceID">区域ID</param>
/// <returns>DataTable</returns>
public DataTable GetCatialInfoByIndustryBIDAndProvinceID(int PageCurrent, string IndustryBID, string ProvinceID)
{
string sql = "select top 10 [InfoID] ,[Title],[publishT],[Hit],[FixPriceID],[HtmlFile],[ProvinceID],[CountyID],[IndustryBID],[CityID],"
+ "[CapitalName],[ValidateTerm],[ComAbout] ,[AuditingStatus],[CountryCode] from CatialInfoTab"
+ " where ProvinceID like '%" + ProvinceID + "%' and IndustryBID like '%" + IndustryBID + "%' and infoID not in (select top " + 10 * (PageCurrent - 1) + " infoID from CatialInfoTab"
+ " where ProvinceID like '%" + ProvinceID + "%' and IndustryBID like '%" + IndustryBID + "%' order by publishT desc ) order by publishT desc";
DataSet ds = SearchDBHelper.Query(sql.ToString());
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 根据区域ID获取融资信息
/// </summary>
/// <param name="PageCurrent">当前页</param>
/// <param name="ProvinceID">区域ID</param>
/// <returns>DataTable</returns>
public DataTable GetFinancingByProvinceID(int PageCurrent, string ProvinceID)
{
string sql = "select top 10 [InfoID] ,[Title],[publishT],[Hit],[FixPriceID],[HtmlFile],[ProvinceID],[CountyID],[IndustryBID],[CityID],"
+ "[CapitalTotal],[ValidateTerm],[ComAbout] ,[AuditingStatus] from MainInfoTabTest"
+ " where ProvinceID=" + ProvinceID + " and infoID not in (select top " + 10 * (PageCurrent - 1) + " infoID from MainInfoTabTest"
+ " where ProvinceID=" + ProvinceID + " order by publishT desc) order by publishT desc";
DataSet ds = SearchDBHelper.Query(sql.ToString());
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
/// <summary>
/// //获取招商内容信息 index 条数
/// </summary>
///
#region//DataSet 招商信息集合
public DataSet SelDataSet()
{
string sql = "select a.infoid as ainfoid,*from [Search].[dbo].[MerchantInfoTab] as a inner join [TotpfoMail].[dbo].EmailType b on a.infoid=b.infoid order by b.time desc ";
return(SearchDBHelper.Query(sql.ToString()));
}
/// <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)));
}
public void InduySelStateList(int num, string Induy)
{
StringBuilder sbl = new StringBuilder();
Common.Text common = new Common.Text();
#region 属性封装
string InfoID = "";
string Title;
string publishT = "";
string Hit;
string LoginName;
string FixPriceID;
string HtmlFile;
string ProvinceID;
string CountyID;
string IndustryClassList;
string CityID;
string CapitalTotal = "";
string ValidateTerm = "";
string ZoneAbout;
string isVIP = "";
string CapitalCurrency;
string AuditingStatus = "";
string CountryCode;
#endregion
StringBuilder sb = new StringBuilder();
string sql = "SELECT top 10 [InfoID] ,[Title],[publishT],[Hit],[FixPriceID],[HtmlFile],[ProvinceID],[CountyID],[IndustryClassList],[CityID],"
+ "[CapitalTotal],[ValidateTerm],[ZoneAbout] ,[CapitalCurrency],[AuditingStatus],[CountryCode]FROM [Search].[dbo].[MerchantInfoTab] where IndustryClassList like '%" + Induy + "%' and infoID not in (select top " + 10 * (num - 1) + " infoID from [Search].[dbo].[MerchantInfoTab] where IndustryClassList like '%" + Induy + "%' order by publishT desc ) order by publishT desc";
DataSet ds = SearchDBHelper.Query(sql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < (ds.Tables[0].Rows.Count > 10 ? 10 : ds.Tables[0].Rows.Count); i++)
{
if (ds.Tables[0].Rows[i]["InfoID"].ToString() != "")
{
InfoID = ds.Tables[0].Rows[i]["InfoID"].ToString();
}
Title = ds.Tables[0].Rows[i]["Title"].ToString();
if (ds.Tables[0].Rows[i]["publishT"].ToString() != "")
{
publishT = ds.Tables[0].Rows[i]["publishT"].ToString();
}
if (ds.Tables[0].Rows[i]["Hit"].ToString() != "")
{
Hit = ds.Tables[0].Rows[i]["Hit"].ToString();
}
FixPriceID = ds.Tables[0].Rows[i]["FixPriceID"].ToString();
HtmlFile = ds.Tables[0].Rows[i]["HtmlFile"].ToString();
ProvinceID = ds.Tables[0].Rows[i]["ProvinceID"].ToString();
CountyID = ds.Tables[0].Rows[i]["CountyID"].ToString();
IndustryClassList = ds.Tables[0].Rows[i]["IndustryClassList"].ToString();
CityID = ds.Tables[0].Rows[i]["CityID"].ToString();
if (ds.Tables[0].Rows[i]["CapitalTotal"].ToString() != "")
{
CapitalTotal = ds.Tables[0].Rows[i]["CapitalTotal"].ToString() + "万元";
}
else
{
CapitalTotal = "暂未填写";
}
if (ds.Tables[0].Rows[i]["ValidateTerm"].ToString() != "")
{
ValidateTerm = ds.Tables[0].Rows[i]["ValidateTerm"].ToString();
}
ZoneAbout = ds.Tables[0].Rows[i]["ZoneAbout"].ToString();
CapitalCurrency = ds.Tables[0].Rows[i]["CapitalCurrency"].ToString();
if (ds.Tables[0].Rows[i]["AuditingStatus"].ToString() != "")
{
AuditingStatus = ds.Tables[0].Rows[i]["AuditingStatus"].ToString();
}
CountryCode = ds.Tables[0].Rows[i]["CountryCode"].ToString();
sb.Append("<ul>");
sb.Append("<li>");
sb.Append("<div class=\"ziyuan-list-1\">");
sb.Append("<input type=\"checkbox\" name=\"checkboxRecord\" value=" + InfoID + " />");
sb.Append("</div>");
sb.Append("<div class=\"ziyuan-list-2\"><img src=\"http://search.topfo.com/images/search_34.jpg\" /></div>");
sb.Append("<div class=\"ziyuan-list-3\">");
sb.Append("<h3><a href=\"http://www.topfo.com/" + HtmlFile + "\" class=\"f_lan-bd\" target=\"_blank\"> " + Title.ToString().Trim() + "</a></h3>");
sb.Append("<div style=\" color:#666; margin-bottom:6px\">" + dal.FixLenth(common.ThrowHtml(ZoneAbout), 110, "....") + "</div>");
sb.Append("<div> <span class=\"ziyuan-list-3-a1\">状态：<span class=\"f_org\">[已审核]</span></span>");
sb.Append("<span class=\"ziyuan-list-3-a1\">总金额：<span class=\"f_org\">" + CapitalTotal + "</span></span>");
sb.Append("<span class=\"ziyuan-list-3-a1\">地区：<span class=\"f_org\">" + dal.dvGetProveName(ProvinceID) + " " + dal.dvGetCa(CityID) + "</span></span>");
sb.Append("<span class=\"ziyuan-list-3-b1\">行业：<span class=\"f_org\">" + dal.IndustrySelect(IndustryClassList) + "</span></span> </div>");
sb.Append("<div class=\"f_gray \" style=\"clear:both\">发布时间: " + publishT.Substring(0, 9).Trim() + " 有效时间：" + SelectValidate(ValidateTerm) + "</div>");
sb.Append("</div>");
sb.Append("<div class=\"ziyuan-list-4\">");
sb.Append("<a href=\"http://www.topfo.com/" + HtmlFile + "\" target=\"_blank\"><img src=\"http://search.topfo.com/images/search_38.jpg\" /></a>");
sb.Append(" </div>");
sb.Append(" </li>");
sb.Append("</ul>");
}
string pageIndex = InduyPageList(num, Induy);
InduyHtmlPageList(num, sb.ToString(), pageIndex, Induy);
}
else
{
InduyHtmlPageList(num, sb.ToString(), "暂未搜索到该资源", Induy);
}
}
