public string GetLatestArticleQADiv(int Type, int Top) { string sql = "select top " + Top + " sysno,question,createtime from qa where status=0 and type=" + Type + " order by createtime desc"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) { return(""); } StringBuilder sb = new StringBuilder(); sb.Append("<div id=zxzt class=panelr>"); sb.Append("<div class=panelr_title1>"); sb.Append("<div class=title>" + AppEnum.GetQAType(Type) + " <a href='../Service/News.aspx?Type=Article&Type2=" + Type + "' style='color:#205E8A; padding-right:3px;'>更多...</a></div>"); sb.Append("</div>"); sb.Append("<div class=cxgg_content>"); foreach (DataRow dr in ds.Tables[0].Rows) { sb.Append("<div class=cxgg_li><a href='../Service/NewsDetail.aspx?Type=Article&ID=" + Util.TrimIntNull(dr["sysno"].ToString()) + "'>" + Util.TrimNull(dr["question"]) + "</a></div>"); } sb.Append("</div>"); sb.Append("</div>"); return(sb.ToString()); }
public string GetAreaQADiv(Hashtable ht, string Position, int Top) { DataSet ds = OnlineListQAManager.GetInstance().GetOnlineListQADs(ht, Top); int QAType = Int32.Parse(ht["QAType"].ToString()); string QATypeName = AppEnum.GetQAType(QAType); if (!Util.HasMoreRow(ds)) { return(""); } StringBuilder sb = new StringBuilder(); if (Position == "Left") { sb.Append("<div id=fl_yxxt class=panel>"); sb.Append("<div class=panel_title>"); sb.Append("<div class=panel_more><a href='../Service/News.aspx?Type=Article&Type2=" + QAType + "' style='color:#205E8A;' target='_blank'>更多...</a></div>"); sb.Append(QATypeName + "</div>"); sb.Append("<div class=panel_content>"); sb.Append("<div class=c_yxxt>"); foreach (DataRow dr in ds.Tables[0].Rows) { if (Util.TrimNull(dr["Question"]).Length > 20) { sb.Append("<span><a href='../Service/NewsDetail.aspx?Type=Article&ID=" + Util.TrimIntNull(dr["SysNo"]) + "' target='_blank'>" + Util.TrimNull(dr["Question"]).Substring(0, 20) + "..." + "</a></span>"); } else { sb.Append("<span><a href='../Service/NewsDetail.aspx?Type=Article&ID=" + Util.TrimIntNull(dr["SysNo"]) + "' target='_blank'>" + Util.TrimNull(dr["Question"]) + "</a></span>"); } } sb.Append("</div>"); sb.Append("</div>"); sb.Append("</div>"); } else if (Position == "Right") { sb.Append("<div id=fl_ztlb class=panelr>"); sb.Append("<div class=panelr_title>"); sb.Append("<div class=panelr_more><a href='../Service/News.aspx?Type=Article&Type2=" + QAType + "' style='color:#205E8A;' target='_blank'>更多...</a></div>"); sb.Append(QATypeName + "</div>"); sb.Append("<div class=panelr_content>"); sb.Append("<div class=c_zxdc>"); foreach (DataRow dr in ds.Tables[0].Rows) { if (Util.TrimNull(dr["Question"]).Length > 20) { sb.Append("<div class=c_zxgg_li><a href='../Service/NewsDetail.aspx?Type=Article&ID=" + Util.TrimIntNull(dr["SysNo"]) + "' target='_blank'>" + Util.TrimNull(dr["Question"]).Substring(0, 20) + "..." + "</a></div>"); } else { sb.Append("<div class=c_zxgg_li><a href='../Service/NewsDetail.aspx?Type=Article&ID=" + Util.TrimIntNull(dr["SysNo"]) + "' target='_blank'>" + Util.TrimNull(dr["Question"]) + "</a></div>"); } } sb.Append("</div>"); sb.Append("</div>"); sb.Append("</div>"); } return(sb.ToString()); }