protected void exportFile_ServerClick(object sender, EventArgs e) { string group = group_id.Value; if (string.IsNullOrEmpty(group)) { return; } GROUPMEMDETAIL[] detail = GetGroupDetail(ToUInt(group)); if (detail != null) { System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine("姓名,学号,班级,学院"); for (int i = 0; i < detail.Length; i++) { GROUPMEMDETAIL mb = detail[i]; System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, mb.szTrueName); sbText = AppendCSVFields(sbText, mb.szPID); sbText = AppendCSVFields(sbText, mb.szClassName); sbText = AppendCSVFields(sbText, mb.szDeptName); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "成员名单.csv"); swCSV.Close(); Response.End(); } }
private void InitGroup() { string group = group_id.Value; if (string.IsNullOrEmpty(group)) { return; } GROUPREQ req = new GROUPREQ(); //req.dwGetType = (uint)GROUPREQ.DWGETTYPE.GROUPGET_BYID; //req.szGetKey = group; req.dwGroupID = ToUInt(group); req.dwReqProp = (uint)GROUPMEMDETAILREQ.DWREQPROP.GROUPMEMDETAILREQ_NEEDDEL; UNIGROUP[] rlt; if (m_Request.Group.GetGroup(req, out rlt) == REQUESTCODE.EXECUTE_SUCCESS) { if (rlt.Length > 0) { minUser = rlt[0].dwMinUsers; maxUser = rlt[0].dwMaxUsers; min_user.Value = minUser.ToString(); if (minUser > 0) { groupVol += "<span class='grey uni_trans uni_trans'>至少:</span><span class='red'>" + minUser + "</span> "; } if (maxUser > 0 && maxUser < 1000) { groupVol += "<span class='grey uni_trans'>最多:</span><span class='red'>" + maxUser + "</span> "; } //int pg = 10; GROUPMEMBER[] mbs = rlt[0].szMembers; groupName = group_name.Value = rlt[0].szName; mb_num.Value = "0"; //GetGroupMemCount(rlt[0].dwID).ToString(); GROUPMEMDETAIL[] detail = GetGroupDetail(rlt[0].dwGroupID); if (detail != null) //成员详细列表 { mb_num.Value = detail.Length.ToString(); for (int i = 0; i < detail.Length; i++) { GROUPMEMDETAIL d = detail[i]; //<td>" + (d.dwSex == 0 ? "保密" : (d.dwSex == 1 ? "男" : "女")) + "</td> mbDetail += "<tr><td>" + d.szTrueName + "</td><td>" + d.szPID + "</td><td>" + d.szClassName + "</td><td>" + d.szDeptName + "</td></tr>"; } } if (mbs != null)//成员列表 { UNIACCOUNT acc; if (Session["LOGIN_ACCINFO"] != null) { acc = (UNIACCOUNT)Session["LOGIN_ACCINFO"]; } else { acc.dwAccNo = null; } for (int i = 0; i < mbs.Length; i++) { //if (i % pg == 0) //{ // if (i != 0) mbList += "</tbody>"; // //pageCtrl += "<li><span>" + (i / pg + 1) + "</span></li>"; // mbList += "<tbody>"; //} bool my = acc.dwAccNo == mbs[i].dwMemberID; mbList += "<tr key='" + mbs[i].dwMemberID + "' kind='" + mbs[i].dwKind + "' class='it " + (my ? "my" : "") + "'><td class='ellipsis'>" + mbs[i].szName + " <span class='grey'>(" + mbs[i].szMemo + ")</span></td><td class='text-center grey click item_toggle'>" + (my ? "<span class='glyphicon glyphicon-user'></span>" : "<span class='glyphicon glyphicon-ok'></span>") + "</td></tr>"; //if (i == mbs.Length - 1) mbList += "</tbody>"; } } } } else { MsgBox(m_Request.szErrMsg); } }