//获得数据 protected string GetHtmlData() { DataTable dt = new DataTable(); StringBuilder condition = new StringBuilder(); if (txtsysUserName.Text.Trim() != "") { condition.AppendFormat(" and (sysUser_Name like '%{0}%')", txtsysUserName.Text.Trim()); } dt = BLL.GetUserList(condition.ToString(), PageIndex, PageSize, out rCount, out pCount).Tables[0]; int i = 0; StringBuilder strHtmlData = new StringBuilder(); strHtmlData.Append("<table class='table_list' cellpadding='0' cellspacing='0' >"); strHtmlData.Append("<tr class='tr_title'>"); strHtmlData.Append("<th style='width:20%;'>实施专员</th>"); strHtmlData.Append("<th style='width:20%;'>联系方式</th>"); strHtmlData.Append("<th>客户</th>"); strHtmlData.Append("<th style='width:15%;'>设置客户</th>"); strHtmlData.Append("</tr>"); for (int j = 0; j < dt.Rows.Count; j++) { i++; string css = string.Empty; if (i % 2 == 0) { css = "tr_con_001"; } else { css = "tr_con_002"; } strHtmlData.Append("<tr class='" + css + "'>"); strHtmlData.Append("<td>" + dt.Rows[j]["SysUser_Name"].ToString() + "</td>"); strHtmlData.Append("<td>" + dt.Rows[j]["SysUser_Tel"].ToString() + "</td>"); strHtmlData.Append("<td>" + GetCustomerInfo_NameCN(dt.Rows[j]["SysUser_ID"].ToString()) + "</td>"); //strHtmlData.Append("<td>" + dt.Rows[j]["SysUser_ID"].ToString() + "</td>"); strHtmlData.Append("<td style='text-align:center'>"); strHtmlData.AppendFormat(" <input type=\"button\" title='设置客户' class=\"btn_modify\" onclick=\"SetCustomerInfo('{0}','{1}');\" />", clsUtility.Encrypt(dt.Rows[j]["SysUser_ID"].ToString()), dt.Rows[j]["SysUser_Name"].ToString()); //strHtmlData.AppendFormat("|"); // strHtmlData.AppendFormat(@"<input type='text' id='txtV_Common_Dict_DoctorInfo' readonly='readonly' // clientidmode='Static' class='txt' style='width:80%;' runat='server' /> // <input type='hidden' id='hidV_Common_Dict_DoctorInfo' clientidmode='Static' runat='server' /> // <input type='button' title='选择人员' onclick='showCommonDict('txtV_Common_Dict_DoctorInfo','hidV_Common_Dict_DoctorInfo','V001','0|0|0','');'/>"); strHtmlData.Append("</td>"); strHtmlData.Append("</tr>"); } strHtmlData.Append("</table>"); if (i == 0) { strHtmlData.Append(" <div class='nodata_div'>暂无数据</div>"); } return(strHtmlData.ToString()); }
//获得数据 protected string GetHtmlData() { DataTable dt = new DataTable(); StringBuilder condition = new StringBuilder(); if (txtsysUserName.Text.Trim() != "") { condition.AppendFormat(" and (sysUser_Name like '%{0}%')", txtsysUserName.Text.Trim()); } if (Consts.AdminID != loginUser.SysUser_ID) { condition.AppendFormat(" and sysUser_ID<>'{0}'", Consts.AdminID); } StringBuilder strHtmlData = new StringBuilder(); try { dt = BLL.GetUserList(condition.ToString(), PageIndex, PageSize, out rCount, out pCount).Tables[0]; int i = 0; strHtmlData.Append("<table class='table table-hover table-bordered'>"); strHtmlData.Append("<thead>"); strHtmlData.Append("<tr>"); strHtmlData.Append("<th>登录名</th>"); strHtmlData.Append("<th>用户名</th>"); strHtmlData.Append("<th>角色名称</th>"); strHtmlData.Append("<th>更新时间</th>"); strHtmlData.Append("<th>操作</th>"); strHtmlData.Append("</tr>"); strHtmlData.Append("</thead>"); strHtmlData.Append("<tbody>"); for (int j = 0; j < dt.Rows.Count; j++) { i++; string css = string.Empty; strHtmlData.Append("<tr>"); strHtmlData.Append("<td>" + dt.Rows[j]["SysUser_LoginName"].ToString() + "</td>"); strHtmlData.Append("<td>" + dt.Rows[j]["SysUser_Name"].ToString() + "</td>"); strHtmlData.Append("<td>" + GetSysRole_Name(dt.Rows[j]["SysUser_ID"].ToString()) + "</td>"); strHtmlData.Append("<td>" + dt.Rows[j]["UpdateTime"].ToString() + "</td>"); strHtmlData.Append("<td class='opera'>"); if (UserFun.Check) { strHtmlData.AppendFormat("<a href='SysUserModuleFunction.aspx?id={0}&dname={1}&iurl={2}'>设置权限</a>" , dt.Rows[j]["SysUser_ID"].ToString() , Server.UrlEncode(dt.Rows[j]["SysUser_Name"].ToString()) , Server.UrlEncode(Request.Url.ToString())); } strHtmlData.AppendFormat("<a href='javascript:;' onclick=\"showPopAddUser('{0}');\" />编辑</a>", clsUtility.Encrypt(dt.Rows[j]["SysUser_ID"].ToString())); strHtmlData.AppendFormat("<a href='javasctipt:;' onclick=\"DeleteItemDesc('{0}')\" />删除</a>", clsUtility.Encrypt(dt.Rows[j]["SysUser_ID"].ToString())); strHtmlData.Append("</td>"); strHtmlData.Append("</tr>"); } strHtmlData.Append("</tbody>"); strHtmlData.Append("</table>"); if (i == 0) { strHtmlData.Append(" <div class='nodata'>暂无数据</div>"); } } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } return(strHtmlData.ToString()); }
public void GetAllUser(HttpContext context) { model.DeleteFlag = Convert.ToInt32(SysEnum.DeleteFlag.NotRemoved); UserList = SUBLL.GetUserList(model); }