62,243
社区成员




Literal1.Text = null;
DataTable dt_sc = orahelp.ExecuteDataTable(sql);
StringBuilder sb = new StringBuilder();
// sb.AppendFormat("<table >");
sb.AppendFormat("<tr align ='center' height='30' style=\"color: #000000\">");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='10%'>部门</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='20%'>人员</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='10%'>人员姓名</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='20%'>人员电话</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='20%'>人员职务</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='10%'>编辑</td>");
sb.AppendFormat("<td class=\"mtabtithead\" nowrap=\"nowrap\" width='10%'>删除</td>");
sb.AppendFormat("</tr>");
if (dt_sc.Rows.Count > 0)
{
for (int i = 0; i < dt_sc.Rows.Count; i++)
{
sb.AppendFormat("<tr height='25 'onmouseover=\"changeto()\" onmouseout=\"changeback()\" >");
sb.AppendFormat("<td class=\"mtabtabtd\">{0}</td>", dt_sc.Rows[i]["bmm"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\">{0}</td>", dt_sc.Rows[i]["ryid"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\">{0}</td>", dt_sc.Rows[i]["ryxm"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\">{0}</td>", dt_sc.Rows[i]["rydh"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\">{0}</td>", dt_sc.Rows[i]["ryzw"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\"><a href=\"ryxx_xg.aspx?ryid={0}& tx={1}\" target=\"_self\" >编辑</a> </td>", dt_sc.Rows[i]["ryid"].ToString(), dt_sc.Rows[i]["rytx"].ToString());//
sb.AppendFormat("<td class=\"mtabtabtd\"><a href=\"#\" onclick=\"del(this,'{0}')\"> 删除</a> </td>", dt_sc.Rows[i]["ryid"].ToString());//
sb.AppendFormat("</tr>");
}
}
// sb.AppendFormat("</table>");
Literal1.Text = sb.ToString();