protected void Page_Load(object sender, EventArgs e)
{
try
{
DataTable siteset = SqlHalper.QueryDataTable("SELECT * FROM [SiteInfo] WHERE yuming='" + HttpContext.Current.Request.Url.Host + "'", ConfigurationManager.ConnectionStrings["damirendb"].ToString());
if (siteset.Rows.Count == 0)
{
Response.Write("<div style='text-align:center;'><a href='/admin/SiteSet.aspx'><span style='color:red;'>请登陆并设置网站信息！</span></a></div>");
}
else
{
wzjieshao = siteset.Rows[0]["jieshao"].ToString();
wzguanjianzi = siteset.Rows[0]["guanjianzi"].ToString();
wzbiaoti = siteset.Rows[0]["biaoti"].ToString();
wzyuming = siteset.Rows[0]["yuming"].ToString();
qq = siteset.Rows[0]["qq"].ToString();
mail = siteset.Rows[0]["youxiang"].ToString();
userid = siteset.Rows[0]["id"].ToString();
logo = siteset.Rows[0]["logo"].ToString();
}
}
catch {
Response.Write("<div style='text-align:center;'><a href='/admin/SiteSet.aspx'><span style='color:red;'>请登陆并设置网站信息！</span></a></div>");
}
//以下设置菜单栏
DataTable meunlinks = SqlHalper.QueryDataTable("SELECT * from [Links] where [leixing]='米店链接' and userid='" + userid + "' order by shunxu", ConfigurationManager.ConnectionStrings["damirendb"].ToString());
StringBuilder sbuMeunlinks = new StringBuilder();
sbuMeunlinks.Append("<li><a href='http://mibiao.liuzhimin.cn'>老店</a></li>");
sbuMeunlinks.Append("<li class='current'><a href='http://jsgo.cn'>网站首页</a></li>");
if (meunlinks.Rows.Count > 0)
{
foreach (DataRow dr in meunlinks.Rows)
{
if (dr["id"].ToString() != "" && dr["id"] != null)
{
sbuMeunlinks.Append("<li>");
sbuMeunlinks.Append("<a href = '" + dr["dizhi"].ToString() + "''>");
sbuMeunlinks.Append(dr["mingcheng"].ToString());
sbuMeunlinks.Append("</a>");
sbuMeunlinks.Append("</li>");
}
}
}
menu = sbuMeunlinks.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
userid = SqlHalper.ExecuteScalar("SELECT [id] FROM [SiteInfo] where Yuming='" + HttpContext.Current.Request.Url.Host + "'", ConfigurationManager.ConnectionStrings["damirendb"].ToString()).Trim();
if (userid == "")
{
Response.Redirect("Error.aspx");
}
}
catch {
Response.Redirect("Error.aspx");
}
DataTable dt = SqlHalper.QueryDataTable("SELECT * from [Yumings] where [zhuangtai]='未售出' and userid='" + userid + "' order by [biaojia] desc", ConfigurationManager.ConnectionStrings["damirendb"].ToString());
StringBuilder sbu = new StringBuilder();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["yuming"].ToString() != "" && dr["yuming"] != null)
{
sbu.Append("<dd>");
sbu.Append("<a href = 'DomainInfo.aspx?id=" + dr["id"].ToString() + "' target = '_blank'>");
sbu.Append("<i> " + dr["yuming"].ToString() + " </i>");
sbu.Append("<em> " + dr["hanyi"].ToString() + " </em>");
sbu.Append("<span class='fr'> ");
if (dr["biaojia"].ToString() != "" && decimal.Parse(dr["biaojia"].ToString().Trim()) != 0)
{
sbu.Append(double.Parse(dr["biaojia"].ToString()) + " 元");
}
else
{
sbu.Append("议价");
}
sbu.Append("</span>");
sbu.Append("</a>");
sbu.Append("</dd>");
}
}
}
trstring = sbu.ToString();
DataTable dtlinks = SqlHalper.QueryDataTable("SELECT * from [Links] where [leixing]='友情链接' and userid='" + userid + "' order by shunxu", ConfigurationManager.ConnectionStrings["damirendb"].ToString());
StringBuilder sbulinks = new StringBuilder();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dtlinks.Rows)
{
if (dr["id"].ToString() != "" && dr["id"] != null)
{
sbulinks.Append("<span>");
sbulinks.Append("<a href = '" + dr["dizhi"].ToString() + "' target = '_blank'style = 'margin: 0px; '>");
sbulinks.Append(dr["mingcheng"].ToString());
sbulinks.Append("</a>");
sbulinks.Append("</span>");
}
}
}
linksstring = sbulinks.ToString();
}
