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(); }