public int GetMatchCount(long InfoID) { Tz888.BLL.Info.MatchInfoBLL bll = new Tz888.BLL.Info.MatchInfoBLL(); int count = bll.GetCount(InfoID, "PC", "") + bll.GetCount(InfoID, "PM", ""); return(count); }
private void LoadMatch() { Tz888.BLL.Info.MatchInfoBLL bll = new Tz888.BLL.Info.MatchInfoBLL(); long intCurrentPage = 1; long intCurrentPageSize = 30; long intTotalCount = 30; this.RfMatch.DataSource = bll.GetMatchList(this._matchType, this._infoID, "*", "", "PublishT Desc,InfoID DESC", ref intCurrentPage, intCurrentPageSize, ref intTotalCount); this.RfMatch.DataBind(); }
private void BindData() { Tz888.BLL.Info.MatchInfoBLL bll = new Tz888.BLL.Info.MatchInfoBLL(); long intCurrentPage = 1; long intCurrentPageSize = 5; long intTotalCount = 5; this.RfInfo.DataSource = bll.GetMatchList(this._matchType, this._infoID, "*", "", "PublishT Desc,InfoID DESC", ref intCurrentPage, intCurrentPageSize, ref intTotalCount); this.RfInfo.DataBind(); DataView dv = new DataView(); dv = bll.GetMatchList(this._matchType, this._infoID, "*", "", "PublishT Desc,InfoID DESC", ref intCurrentPage, intCurrentPageSize, ref intTotalCount); }
public string GetAllOtherInfoByInfoIDForStaticPage(string InfoID, string LoginName) { long lgCurrentPage = 1; long lgPageSize = 0; long lgPageCount = 0; decimal MainPointCount = 0; StringBuilder sOut = new StringBuilder(); string CurrentUserName = ""; CurrentUserName = LoginName; //用户会员资料展示页面 string MemberURL = ""; //用户是否是拓富通会员 bool bIsTofMember = false; if (User.IsInRole("GT1002")) { //拓富通会员 if (CurrentUserName.Trim() != "") { bIsTofMember = true; } } #region 用户的联系方式信息 string PublishMan = ""; string NickName = ""; string SelfWebDomain = "";//网上展厅域名 string InfoTypeName = ""; int FixPriceID = 0; string InfoOriginRoleName = "0"; string ManageTypeID = ""; Tz888.BLL.Common.CommonFunction cf = new Tz888.BLL.Common.CommonFunction(); DataTable dt = cf.GetDTFromTableOrView("MainInfoViw", "infoid", "*", " infoid=" + InfoID, "InfoID", ref lgCurrentPage, lgPageSize, ref lgPageCount); if (dt != null && dt.Rows.Count > 0) { FixPriceID = Convert.ToInt32(dt.Rows[0]["FixPriceID"].ToString().Trim()); MainPointCount = Convert.ToDecimal(dt.Rows[0]["MainPointCount"].ToString().Trim()); InfoOriginRoleName = dt.Rows[0]["InfoOriginRoleName"].ToString().Trim(); PublishMan = dt.Rows[0]["LoginName"].ToString().Trim(); ManageTypeID = dt.Rows[0]["ManageTypeID"].ToString().Trim(); Tz888.BLL.Conn con = new Tz888.BLL.Conn(); DataTable domain = con.GetWebSiteList("SelfCreateWebInfo", "Domain", "LoginName", 1, 1, 0, 1, "LoginName='" + LoginName + "'"); if (domain.Rows.Count > 0) { SelfWebDomain = domain.Rows[0]["Domain"].ToString(); } } string sContract = ""; //免费或已购买的信息的内容 string sFree = "<ul><li><a href=\"javascript:GetContactDetail('" + InfoID + "');\"><img src=\"http://images.topfo.com/Info/Capital/1/images/zibc_23.jpg\" width=\"183\" height=\"30\" /></a> <span>提示:您需要登陆后才能查看联系方式</span></li></ul>"; //收费的信息内容(需要购买才能看) string payDomain = System.Configuration.ConfigurationManager.AppSettings["payDomain"]; Tz888.BLL.Common.DictionaryInfoBLL diBll = new Tz888.BLL.Common.DictionaryInfoBLL(); Tz888.Model.Common.DictionaryInfoModel objDic = new Tz888.Model.Common.DictionaryInfoModel(); objDic = diBll.GetModel("1"); string strMainPointCount = MainPointCount.ToString("c"); string strMainPointCountVip = Convert.ToDecimal(Convert.ToString(Convert.ToDecimal(objDic.DictionaryInfoParam) * MainPointCount)).ToString("c"); //收费的信息类容 string sChange = "<ul><li>资源价格:<span class=\"orange01\"><strong>" + strMainPointCount + "</strong></span>元(拓富通会员价:<span class=\"orange01\"><strong>" + strMainPointCountVip + "</strong></span>元)</li>" + "<li><a href=\"" + payDomain + "/order_item.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src=\"http://images.topfo.com/Info/Capital/1/images/tiem_03.jpg\" /></a> <a href=\"http://membertest.topfo.com/PayManage/shopcar.aspx?InfoID=" + InfoID + "\" class=\"spaces\" target=\"_blank\"><img src=\"http://images.topfo.com/Info/Capital/1/images/tiem_05.jpg\" width=\"162\" height=\"36\" /></a></li>" + "<li><font color=\"#CCCCCC\">支持多种支付方式,资源若无效经中国招商投资网确认后可全额返还所付款项,请放心购买</font></li></ul>"; #endregion //sOut.Append(sContract); //多少人关注 string Hits = "0"; //if (dv != null && dv.Table.Rows.Count > 0) if (dt != null && dt.Rows.Count > 0) { Hits = dt.Rows[0]["hit"].ToString().Trim(); } //sOut.Append("|"); sOut.Append(Hits.Trim()); //多少人收藏,同时更新浏览次数 string ViewCollection = "0"; if (MainPointCount > 0 && FixPriceID > 1) { Tz888.BLL.Info.MatchInfoBLL miBLL = new Tz888.BLL.Info.MatchInfoBLL(); miBLL.dvViewCollectionCount(InfoID);//更新浏览次数 Tz888.BLL.Info.MainInfoBLL mainBLL = new Tz888.BLL.Info.MainInfoBLL(); ViewCollection = mainBLL.GetInfoBuyersCount(Convert.ToInt64(InfoID)).ToString(); } else { Tz888.BLL.Info.MatchInfoBLL miBLL = new Tz888.BLL.Info.MatchInfoBLL(); DataView dvViewCollection = miBLL.dvViewCollectionCount(InfoID); if (dvViewCollection != null && dvViewCollection.Table.Rows.Count > 0) { ViewCollection = Convert.ToInt32(dvViewCollection.Table.Rows[0][0]).ToString(); } } sOut.Append("|"); sOut.Append(ViewCollection.Trim()); //推荐次数 sOut.Append("|"); sOut.Append("3"); //留言条数 Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); int c = dal.GetCount("InfoCommentTab", "InfoID", "InfoID=" + InfoID); sOut.Append("|"); sOut.Append(c.ToString()); sOut.Append("|"); if (MainPointCount > 0 && FixPriceID > 1) { //这是一条收费信息 bool bIsBuy = false; Tz888.BLL.Info.CapitalInfoBLL ciBll = new Tz888.BLL.Info.CapitalInfoBLL(); bIsBuy = ciBll.bIsBuyInfoOfUser(CurrentUserName, InfoID); if (bIsBuy) { sContract = sFree; } else { sContract = sChange; } } else { sContract = sFree; } sOut.Append(sContract); return(sOut.ToString().Trim()); }
public string GetOtherResource(string InfoID) { StringBuilder sOut = new StringBuilder(); string doMainUrl = Tz888.Common.Common.GetWWWDomain(); Tz888.BLL.Info.MatchInfoBLL miBll = new Tz888.BLL.Info.MatchInfoBLL(); long CurrentPage = 1; long TotalCount = 10; DataView dv = miBll.GetMatchList("CC", Convert.ToInt64(InfoID), "InfoID", "", "degree asc", ref CurrentPage, 10, ref TotalCount); int IsVip = this.GetUserGrad(InfoID); if (IsVip == 0) { if (dv != null && dv.Table.Rows.Count > 0) { sOut.Append("<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" + "<tr>" + "<td width=\"52%\" align=\"left\">" + "<font color=\"#888888\"><b>项目名称</b></font></td>" + "<td width=\"16%\" align=\"left\">" + "<font color=\"#888888\"><b>融资金额</b></font></td>" + "<td width=\"32%\" align=\"left\">" + "<font color=\"#888888\"><b>所属行业</b></font></td>" + "</tr>"); Tz888.BLL.Info.V124.CapitalInfoBLL bll = new Tz888.BLL.Info.V124.CapitalInfoBLL(); for (int i = 0; i < dv.Table.Rows.Count; i++) { long tmpId = Convert.ToInt64(dv.Table.Rows[i]["InfoID"]); Tz888.Model.Info.V124.CapitalSetModel model = bll.GetIntegrityModel(tmpId); string industryname = ""; for (int j = 0; j < model.CapitalInfoModel.IndustryBName.Count; j++) { string temp = model.CapitalInfoModel.IndustryBName[j]; if (!string.IsNullOrEmpty(temp)) { if (j != (model.CapitalInfoModel.IndustryBName.Count - 1)) { industryname += temp + " "; } else { industryname += temp; } } } sOut.Append("<tr>" + "<td align=\"left\" bgcolor=\"#f6f6f6\">" + "·<a href=\"" + doMainUrl + "/" + model.MainInfoModel.HtmlFile + "\">" + model.MainInfoModel.Title + "</a> " + model.MainInfoModel.publishT.ToString("yyyy-MM-dd") + "</td>" + "<td align=\"left\" bgcolor=\"#f6f6f6\">" + model.CapitalInfoModel.CapitalName + "</td>" + "<td align=\"left\" bgcolor=\"#f6f6f6\">" + industryname + "</td>" + "</tr>"); } sOut.Append("</table>"); } else { sOut.Append("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"listtab\"><tr><td align=\"center\" class=\"title\">没有相关资源</td></tr></table>"); } } else if (IsVip == 1) { if (dv != null && dv.Table.Rows.Count > 0) { sOut.Append("<div class=\"leftbox\"><ul>"); Tz888.BLL.Info.V124.CapitalInfoBLL bll = new Tz888.BLL.Info.V124.CapitalInfoBLL(); string RowModel = "<li>·<a href=\"{0}\">{1} </a>{2} <span>{3}</span></li>"; for (int i = 0; i < dv.Table.Rows.Count; i++) { long tmpId = Convert.ToInt64(dv.Table.Rows[i]["InfoID"]); Tz888.Model.Info.V124.CapitalSetModel model = bll.GetIntegrityModel(tmpId); string HtmlFile = doMainUrl + "/" + model.MainInfoModel.HtmlFile; string Title = model.MainInfoModel.Title; string PublishTime = model.MainInfoModel.publishT.ToString("yyyy-MM-dd"); string CapitalName = model.CapitalInfoModel.CapitalName; if (i == 5) { sOut.Append("</ul></div><div class=\"leftbox\"><ul>"); } sOut.Append(string.Format(RowModel, HtmlFile, Title, PublishTime, CapitalName)); } sOut.Append("</ul></div>"); } else { sOut.Append(""); } } if (string.IsNullOrEmpty(sOut.ToString())) { sOut.Append("没有相关的资源"); } return(sOut.ToString().Trim()); }
public int GetMatchCount(long InfoID) { //this._infoID = Convert.ToInt64(ViewState["InfoID"]); Tz888.BLL.Info.MatchInfoBLL bll = new Tz888.BLL.Info.MatchInfoBLL(); return(bll.GetCount(InfoID, "MC", "") + bll.GetCount(InfoID, "MP", "")); }
public string GetAllOtherInfoByInfoIDForStaticPage(string InfoID, string LoginName) { #region 互告跟踪记录 ///------------------------------ ///--design by AdSystem_20090620 ///------------------------------ string sitekey = ""; AdSystem.Logic loc = new AdSystem.Logic(); if (HttpContext.Current.Request.Cookies["S"] != null && HttpContext.Current.Request.Cookies["S"].Value.Trim() != "") { sitekey = HttpContext.Current.Request.Cookies["S"].Value.Trim(); HttpContext.Current.Request.Cookies["S"].Expires = DateTime.Now.AddDays(-1); bool flag = loc.setCookie(sitekey, InfoID); if (flag) { loc.Hits_Add(); } } //跟踪浏览的用户 if (LoginName.Trim() != "") { loc.View_Add(InfoID, LoginName); } #endregion #region 信息参数说明 StringBuilder sOut = new StringBuilder(); long lgCurrentPage = 1; long lgPageSize = 0; long lgPageCount = 0; decimal MainPointCount = 0; string CurrentUserName = ""; CurrentUserName = LoginName; string MemberURL = ""; //用户会员资料展示页面 bool bIsTofMember = false; //用户是否是拓富通会员 if (User.IsInRole("GT1002")) { //拓富通会员 if (CurrentUserName.Trim() != "") { bIsTofMember = true; } } string sContract = ""; //1,用户的联系方式信息 | 2,type #endregion #region 获取用户的联系方式信息 string PublishMan = ""; string NickName = ""; string SelfWebDomain = ""; //网上展厅域名 string InfoTypeName = ""; int FixPriceID = 0; string InfoOriginRoleName = "0"; string ManageTypeID = ""; Tz888.BLL.Common.CommonFunction cf = new Tz888.BLL.Common.CommonFunction(); DataTable dt = cf.GetDTFromTableOrView("MainInfoViw", "infoid", "*", " infoid=" + InfoID, "InfoID", ref lgCurrentPage, lgPageSize, ref lgPageCount); if (dt != null && dt.Rows.Count > 0) { FixPriceID = Convert.ToInt32(dt.Rows[0]["FixPriceID"].ToString().Trim()); MainPointCount = Convert.ToDecimal(dt.Rows[0]["MainPointCount"].ToString().Trim()); InfoOriginRoleName = dt.Rows[0]["InfoOriginRoleName"].ToString().Trim(); PublishMan = dt.Rows[0]["LoginName"].ToString().Trim(); ManageTypeID = dt.Rows[0]["ManageTypeID"].ToString().Trim(); Tz888.BLL.Conn con = new Tz888.BLL.Conn(); DataTable domain = con.GetWebSiteList("SelfCreateWebInfo", "Domain", "LoginName", 1, 1, 0, 1, "LoginName='" + PublishMan + "'"); if (domain.Rows.Count > 0) { SelfWebDomain = domain.Rows[0]["Domain"].ToString(); } } string ToSelfWebDomain = ""; string href = ""; if (SelfWebDomain != "") { if (ManageTypeID == "2004") { href = "http://" + SelfWebDomain + ".gov.topfo.com"; } else { href = "http://" + SelfWebDomain + ".co.topfo.com"; } ToSelfWebDomain = "<a href='" + href + "' target='_blank'><img src='/images/huiy_23.jpg' width='206' height='30' /></a>"; } //总站发布的信息 string sManage = "<a href='#88' onclick=\"javascript:GetContactDetail(" + InfoID + ");\" class='spaces' ><img src='/web13/images/project/button_cklxfs.gif' width='150' height='30' align='absmiddle' /></a> " + ToSelfWebDomain + "|1"; //免费的信息的内容 string sFree = "<a href='#88' onclick=\"javascript:GetContactDetail(" + InfoID + ");\" class='spaces' ><img src='/web13/images/project/button_cklxfs.gif' width='150' height='30' align='absmiddle' /></a> " + ToSelfWebDomain + "|1"; //收费的信息内容(需要购买才能看) string payDomain = System.Configuration.ConfigurationManager.AppSettings["payDomain"]; string sChange = "<a href=\"" + payDomain + "/order_item.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src='/web13/images/project/button_ljgm.gif' width=\"130\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a> <a href=\"http://member.topfo.com/PayManage/shopcar.aspx?InfoID=" + InfoID + "\" class=\"spaces\" target=\"_blank\"><img src=\"/web13/images/project/button_flgwc.gif\" width=\"150\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a><br /><font color='#CCCCCC'>支持多种支付方式,资源若无效经中国招商投资网确认后可全额返还所付款项,请放心购买</font><br>" + ToSelfWebDomain + "|2"; if (MainPointCount > 0 && FixPriceID > 1) //当前用户名 { bool bIsBuy = false; //这是一条收费信息 Tz888.BLL.Info.CapitalInfoBLL ciBll = new Tz888.BLL.Info.CapitalInfoBLL(); bIsBuy = ciBll.bIsBuyInfoOfUser(CurrentUserName, InfoID); if (bIsBuy) { if (InfoOriginRoleName == "0") { sContract = sFree; } else { sContract = sManage; } } else { if (bIsTofMember) { //拓富通会员购买了此信息 if (InfoOriginRoleName == "0") { sContract = sFree; } else { sContract = sManage; } } else { //拓富通会员没有购买了此信息 sContract = sChange; } } } else { //这是一条免费信息 if (InfoOriginRoleName == "0") { sContract = sFree; } else { sContract = sManage; } } #endregion sOut.Append(sContract.Trim()); sOut.Append("|"); //3,null #region 点击量 string Hits = "0"; //4,多少人关注 //if (dv != null && dv.Table.Rows.Count > 0) if (dt != null && dt.Rows.Count > 0) { Hits = dt.Rows[0]["hit"].ToString().Trim(); } #endregion sOut.Append("|"); sOut.Append(Hits.Trim()); #region 收藏与浏览量 string ViewCollection = "0"; //5,多少人收藏,同时更新浏览次数 if (MainPointCount > 0 && FixPriceID > 1) { Tz888.BLL.Info.MatchInfoBLL miBLL = new Tz888.BLL.Info.MatchInfoBLL(); miBLL.dvViewCollectionCount(InfoID);//更新浏览次数 Tz888.BLL.Info.MainInfoBLL mainBLL = new Tz888.BLL.Info.MainInfoBLL(); ViewCollection = mainBLL.GetInfoBuyersCount(Convert.ToInt64(InfoID)).ToString(); } else { Tz888.BLL.Info.MatchInfoBLL miBLL = new Tz888.BLL.Info.MatchInfoBLL(); DataView dvViewCollection = miBLL.dvViewCollectionCount(InfoID); if (dvViewCollection != null && dvViewCollection.Table.Rows.Count > 0) { ViewCollection = Convert.ToInt32(dvViewCollection.Table.Rows[0][0]).ToString(); } } #endregion sOut.Append("|"); sOut.Append(ViewCollection.Trim()); #region 查询推荐的次数 ///------------------------------------------ ///-- 20090601 ---------------- 6,查询推荐的次数 ///------------------------------------------ Tz888.BLL.CommendBLL com = new Tz888.BLL.CommendBLL(); long currpage = 1; long pagecount = 1; int count = com.GetListCount("*", "InfoID=" + InfoID.ToString(), "", ref currpage, 1, ref pagecount); #endregion sOut.Append("|"); sOut.Append(count.ToString().Trim()); #region 附件列表 string fujianStr = ""; //7,附件列表 fujianStr = getInfoResourceById(Convert.ToInt64(InfoID), InfoOriginRoleName, MainPointCount, FixPriceID, bIsTofMember); #endregion sOut.Append("|"); sOut.Append(fujianStr.Trim()); sOut.Append("|"); //8,资源价格 sOut.Append(MainPointCount.ToString()); sOut.Append("|"); if (MainPointCount > 0 && FixPriceID > 1)//9,判断是否为收费资源 { sOut.Append("收费"); } else { sOut.Append("免费"); } return(sOut.ToString().Trim()); }