通讯录页面在学员没有照片的情况下可以显示默认照片

悬赏园豆：20 [已解决问题] 解决于 2015-07-29 09:17

前台代码：

<head runat="server"> <title>同学录</title> <link href="../css/main.css" rel="stylesheet" /> <link rel="stylesheet" href="../css/css.css" /> <script type="text/javascript" src="../Js/jquery.js"></script> <script language="javascript" type="text/ecmascript"> function Order(field) { if(document.getElementById("hid_OrdFunction").value=="desc") { //alert("a") document.getElementById("hid_OrdFunction").value="asc"; } else { document.getElementById("hid_OrdFunction").value="desc"; } document.getElementById("hid_Field").value=field; <%=this.Page.ClientScript.GetPostBackEventReference(this.Page,"")%>; } </script>

<%--<script type="text/javascript"> function window.onload() { var img = document.getElementById("td").getElementsByTagName("img"); for (var i = 0; i < img.length; i++) { if (img[i].readyState == "uninitialized") { img[i].src = "Index/img/stuphoto.jpg"; } } } $(function () { window.onload(); }); </script>--%>

后台代码：

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using DSOA.Class; using WebBaseLibrary;

namespace ZP_XYZZ.Index { public partial class StudentMateRecords : BasePage { protected bool PhotoClassContactList =false; protected DataTable DTTemp = new DataTable(); protected void Page_Load(object sender, EventArgs e) { SetUser(true); PhotoClassContactList = DSOA.OA_help.SystemConfig.AppSettings["PhotoClassContactList"].ToLower() == "true"; try { MyUser.ClassCollection classList = (MyUser.ClassCollection)myuser.ClassList;

lt_title.Text = classList[0].Name; LoadData(classList[0].ClassID, myuser.UserID, "");

} catch (Exception ex) { Response.Write("Error：" + ex.ToString()); } }

private void LoadData(string sClassID, string sUserID, string StrSort) { try { DataTable tbl = GetDTTbl(sClassID); if (tbl != null && tbl.Rows.Count > 0) { DataTable dtC = GetDTC(tbl);

if (PhotoClassContactList) { string order = string.Empty; if (!String.IsNullOrEmpty((Request.Form["hid_Field"])) && hid_Field.Value != "CLASS") { order = hid_Field.Value + " " + hid_OrdFunction.Value; string[] field = hid_Field.Value.Split('.'); Literal lit = (Literal)Page.FindControl("lit_" + field[field.Length - 1]); if (lit != null) { if (hid_OrdFunction.Value == "asc") { lit.Text = "<img src='../images/up.gif'>"; } else { lit.Text = "<img src='../images/down.gif'>"; } } } else { string[] field = hid_Field.Value.Split('.'); Literal lit = (Literal)Page.FindControl("lit_" + field[field.Length - 1]); if (lit != null) { if (hid_OrdFunction.Value == "asc") { lit.Text = "<img src='../images/up.gif'>"; } else { lit.Text = "<img src='../images/down.gif'>"; } } } DataTable dtA = new DataTable(); dtA = dtC.Clone();//克隆All的结构传递给dt if (!string.IsNullOrEmpty(order)) { foreach (DataRow dr in dtC.Select("1=1", order)) { dtA.Rows.Add(dr.ItemArray); } DTTemp = dtA; PageChangeControl1.DataSource = dtA.DefaultView; Repeater1.DataSource = PageChangeControl1.PageChangedDataSource; Repeater1.DataBind(); } else { DTTemp = dtC; PageChangeControl1.DataSource = dtC.DefaultView; Repeater1.DataSource = PageChangeControl1.PageChangedDataSource; Repeater1.DataBind(); }

Repeater1.Visible = true; Lab_Clew.Visible = false; } } else { if (PhotoClassContactList) { Repeater1.Visible = false; Lab_Clew.Visible = true; } } } catch (Exception ex) { Response.Write("加载数据Error：" + ex.ToString()); } finally { m_cn.Close(); } }

private DataTable GetDTC(DataTable tbl) { DataColumn FIDCOL = new DataColumn("FID"); tbl.Columns.Add(FIDCOL); DataColumn OrderNo = new DataColumn("ORD_NO"); tbl.Columns.Add(OrderNo); DataColumn col = new DataColumn("CLASS"); tbl.Columns.Add(col); DataColumn ROLENAME = new DataColumn("ROLENAME"); tbl.Columns.Add(ROLENAME); DataColumn CLASSNAME = new DataColumn("CLASSNAME"); tbl.Columns.Add(CLASSNAME); foreach (DataRow row in tbl.Rows) { //DateTime d = row["EDIT_TIME"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["EDIT_TIME"]); //if (d.CompareTo(DateTime.Today) >= 0 && d.CompareTo(DateTime.Today.AddDays(1)) < 0) //{ // row["CLASSNAME"] = "Select"; //} string stuyid = row["INFO_ID"].ToString();

string sql = "select name from jw_classrole_rel rel inner join Jw_Classrole cl on rel.fid=cl.id and rel.bcinfo_id=cl.bcinfo_id where rel.rel_id=" + stuyid + " and rel.bcinfo_id=" + myuser.ClassList[0].ClassID;

OleDbCommand cmd = new OleDbCommand(sql, m_cn); OleDbDataReader ODR = cmd.ExecuteReader(); string role = ""; while (ODR.Read()) { role += ODR[0].ToString() + "<br>"; } row["ROLENAME"] = role; ODR.Close();

sql = "select wo.name,rel1.fid,rel1.ord_no from jw_classframework_rel rel1 inner join jw_classframework_rel rel2 on rel1.fid=rel2.id and rel1.bcinfo_id=rel2.bcinfo_id inner join Jw_Classframework wo on rel2.rel_id=wo.id and rel2.bcinfo_id=wo.bcinfo_id where rel1.rel_id=" + stuyid + " and rel1.bcinfo_id=" + myuser.ClassList[0].ClassID; OleDbCommand cmdCl = new OleDbCommand(sql, m_cn); OleDbDataReader ODRCl = cmdCl.ExecuteReader(); string Class = ""; string fid = string.Empty; string orderno = string.Empty; while (ODRCl.Read()) { fid = ODRCl["FID"].ToString(); orderno = ODRCl["ORD_NO"].ToString(); Class += ODRCl["NAME"].ToString() + "<BR>"; } row["FID"] = fid; row["ORD_NO"] = orderno; row["CLASS"] = Class; ODRCl.Close(); }

DataTable dtC = new DataTable(); dtC = tbl.Clone();//克隆All的结构传递给dt int idx = 0;

string strsql = "select * from vw_classframework where bcinfo_id=" + myuser.ClassList[0].ClassID + " "; DataTable tbl1 = m_db.GetDataTable(strsql, m_cn); DataRow[] rows = tbl1.Select(" fid=0 ", "ORD_NO");

foreach (DataRow dr in rows) { strsql = "select t.* ,t1.name as zName from vw_classframework t inner join vw_classframework t1 on t.fid=t1.id where t.bcinfo_id=" + myuser.ClassList[0].ClassID + " and t.fid=" + dr["id"] + " order by t.ord_no "; DataTable dtNew = m_db.GetDataTable(strsql, m_cn); foreach (DataRow drNew in dtNew.Select("fid=" + dr["id"], "ORD_NO")) { foreach (DataRow DR in tbl.Select(" info_id= " + drNew["rel_id"], "ORD_NO")) { dtC.Rows.Add(DR.ItemArray); } } } foreach (DataRow dr in tbl.Select("CLASS = ''")) { dtC.Rows.Add(dr.ItemArray); } return dtC; }

private DataTable GetDTTbl(string sClassID) { string strSql = @"SELECT * FROM ( SELECT G2.BT AS XM,DECODE(XB,'0','男','女') AS XB,XY.SZDW AS DW,XY.ZW,ASCII(SUBSTR(G2.BT,1)) AS SHOWORDER ,SUB.FJH,XY.SJHM,XY.QQ,SUB.FJDH,G2.ID AS INFO_ID,xy.zppath FROM JW_BCGL BC INNER JOIN G_INFOS G ON G.ID = BC.INFO_ID AND G.DELETED <> -1 AND BC.INFO_ID = " + sClassID+@" INNER JOIN SUB_FILE_RELATION SUB ON SUB.FINFO_ID = BC.INFO_ID and sub.xxzt=0 INNER JOIN JW_XYXX XY ON XY.INFO_ID = SUB.INFO_ID INNER JOIN G_INFOS G2 ON G2.ID = XY.INFO_ID AND G2.DELETED <> -1 WHERE XXZT<>1 ) ORDER BY SHOWORDER ASC"; DBInfo(); DataTable tbl = m_db.GetDataTable(strSql, m_cn); return tbl; }

protected void PageChangeControl1_PageChanged(object sender, EventArgs e) { try { MyUser.ClassCollection classList = (MyUser.ClassCollection)myuser.ClassList; LoadData(classList[0].ClassID, myuser.UserID, "");

} catch (Exception ex) { Response.Write("Error：" + ex.ToString()); } } }

}

数据库中有图片就显示出来没有就让他显示默认图片

漫天星星 | 初学一级 | 园豆：114
提问于：2015-07-27 16:56

< >

最佳答案

你前端都有判断语句了，你做一个判断，后台去查询数据，存在就把路径返回，不存在你就返回一个你自己定义的，就OK了

收获园豆：20

稳稳的河 | 老鸟四级 |园豆：4216 | 2015-07-27 17:09

我不会，你能给我写下代码吗？

漫天星星 | 园豆：114 (初学一级) | 2015-07-27 17:14

@漫天星星: 前端：

<div class="block">
<a href="/order/catalog"><img src="你传的" width="55" height="55" alt=""></a>
<p><a href="/order/catalog">Service Bureau ordering</a></p>
</div>

后台：一个方法返回路径就OK，怎么得到数据我过了说了，想动态什么的自己去做下，思路都提供了，没什么难度了

稳稳的河 | 园豆：4216 (老鸟四级) | 2015-07-27 18:09

其他回答(2)

加判断你贴的这代码。。。格式化一下参考稳稳的河

s_p | 园豆：140 (初学一级) | 2015-07-27 17:41

这代码一贴出来，估计大家只能看热闹了

算了 | 园豆：3 (初学一级) | 2015-07-28 23:43

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

通讯录页面在学员没有照片的情况下可以显示默认照片

欢迎，请先登录或者注册。