/// <summary>
/// 得到一个对象实体
/// </summary>
public Tz888.Model.Common.DictionaryInfoModel GetModel(string DictionaryCode)
{
SqlParameter[] parameters =
{
new SqlParameter("@DictionaryInfoId", SqlDbType.Int, 4),
};
parameters[0].Value = DictionaryCode;
Tz888.Model.Common.DictionaryInfoModel model = new Tz888.Model.Common.DictionaryInfoModel();
DataSet ds = DbHelperSQL.RunProcedure("DictionaryInfoTab_GetModel", parameters, "ds");
model.DictionaryCode = DictionaryCode;
if (ds.Tables[0].Rows.Count > 0)
{
model.DictionaryInfoName = ds.Tables[0].Rows[0]["DictionaryInfoName"].ToString();
model.DictionaryTypeCode = ds.Tables[0].Rows[0]["DictionaryTypeCode"].ToString();
model.DictionaryInfoParam = ds.Tables[0].Rows[0]["DictionaryInfoParam"].ToString();
model.DictionaryInfoRemark = ds.Tables[0].Rows[0]["DictionaryInfoRemark"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tz888.Model.Common.DictionaryInfoModel model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@DictionaryInfoId", SqlDbType.Int, 4),
new SqlParameter("@DictionaryCode", SqlDbType.Char, 25),
new SqlParameter("@DictionaryInfoName", SqlDbType.NVarChar),
new SqlParameter("@DictionaryTypeCode", SqlDbType.Char, 10),
new SqlParameter("@DictionaryInfoParam", SqlDbType.Char, 12),
new SqlParameter("@DictionaryInfoRemark", SqlDbType.NVarChar)
};
parameters[0].Value = model.DictionaryInfoId;
parameters[1].Value = model.DictionaryCode;
parameters[2].Value = model.DictionaryInfoName;
parameters[3].Value = model.DictionaryTypeCode;
parameters[4].Value = model.DictionaryInfoParam;
parameters[5].Value = model.DictionaryInfoRemark;
DbHelperSQL.RunProcedure("UP_DictionaryInfoTab_Update", parameters, out rowsAffected);
}
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());
}