/// <summary> /// 初始化 /// </summary> private void DataInit() { //获取分页参数并强转 pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page")); EyouSoft.Model.SourceStructure.MGuideSearchModel search = new EyouSoft.Model.SourceStructure.MGuideSearchModel(); //导游姓名 string guidName = Utils.GetQueryStringValue("txtguidName"); if (!string.IsNullOrEmpty(guidName)) { search.Name = guidName; } //性别 string gener = Utils.GetQueryStringValue("seGender"); if (!string.IsNullOrEmpty(gener) && gener != "-1") { search.Gender = (EyouSoft.Model.EnumType.GovStructure.Gender)Enum.Parse(typeof(EyouSoft.Model.EnumType.GovStructure.Gender), gener); } //类别 string type = Utils.GetQueryStringValue("seType"); if (!string.IsNullOrEmpty(type) && type != "-1") { search.GuideCategory = (EyouSoft.Model.EnumType.SourceStructure.GuideCategory)Enum.Parse(typeof(EyouSoft.Model.EnumType.SourceStructure.GuideCategory), type); } //级别 string leavel = Utils.GetQueryStringValue("seLevel"); if (!string.IsNullOrEmpty(leavel) && leavel != "-1") { search.Level = (EyouSoft.Model.EnumType.SourceStructure.GuideLevel)Enum.Parse(typeof(EyouSoft.Model.EnumType.SourceStructure.GuideLevel), leavel); } //语种 string language = Utils.GetQueryStringValue("txtguidlanguage"); if (!string.IsNullOrEmpty(language)) { search.Language = language; } IList <EyouSoft.Model.SourceStructure.MGuideListModel> userList = new EyouSoft.BLL.SourceStructure.BSource().GetGuideShowModel(search, this.SiteUserInfo.CompanyId, pageIndex, pageSize, ref recordCount); if (userList != null && userList.Count > 0) { this.replist.DataSource = userList; this.replist.DataBind(); BindPage(); } else { this.litdatamsg.Text = "<tr><td align='center' colspan='12'>没有相关数据!</td></tr>"; this.ExporPageInfoSelect1.Visible = false; this.ExporPageInfoSelect2.Visible = false; } }
/// <summary> /// 导出 /// </summary> protected void ToXls() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } StringBuilder s = new StringBuilder(); EyouSoft.Model.SourceStructure.MGuideSearchModel search = new EyouSoft.Model.SourceStructure.MGuideSearchModel(); //导游姓名 string guidName = Utils.GetQueryStringValue("txtguidName"); if (!string.IsNullOrEmpty(guidName)) { search.Name = guidName; } //性别 string gener = Utils.GetQueryStringValue("seGender"); if (!string.IsNullOrEmpty(gener) && gener != "-1") { search.Gender = (EyouSoft.Model.EnumType.GovStructure.Gender)Enum.Parse(typeof(EyouSoft.Model.EnumType.GovStructure.Gender), gener); } //类别 string type = Utils.GetQueryStringValue("seType"); if (!string.IsNullOrEmpty(type) && type != "-1") { search.GuideCategory = (EyouSoft.Model.EnumType.SourceStructure.GuideCategory)Enum.Parse(typeof(EyouSoft.Model.EnumType.SourceStructure.GuideCategory), type); } //级别 string leavel = Utils.GetQueryStringValue("seLevel"); if (!string.IsNullOrEmpty(leavel) && leavel != "-1") { search.Level = (EyouSoft.Model.EnumType.SourceStructure.GuideLevel)Enum.Parse(typeof(EyouSoft.Model.EnumType.SourceStructure.GuideLevel), leavel); } //语种 string language = Utils.GetQueryStringValue("txtguidlanguage"); if (!string.IsNullOrEmpty(language)) { search.Language = language; } IList <EyouSoft.Model.SourceStructure.MGuideListModel> userList = new EyouSoft.BLL.SourceStructure.BSource().GetGuideShowModel(search, this.SiteUserInfo.CompanyId, pageIndex, pageSize, ref recordCount); if (userList != null && userList.Count > 0) { s.Append("<table id='liststyle' width='100%'>"); s.Append("<tr><td align='center' class='th-line'>姓名</td>"); s.Append("<td align='center' class='th-line'>性别</td>"); s.Append("<td align='center' class='th-line'>类别</td>"); s.Append("<td align='center' class='th-line'>级别</td>"); s.Append("<td align='center' class='th-line'>语种</td>"); s.Append("<td align='center' class='th-line'>手机</td>"); s.Append("<td align='center' class='th-line'>带团次数</td>"); s.Append("<td align='center' class='th-line'>带团天数</td>"); s.Append("<td align='center' class='th-line'>挂靠单位</td>"); s.Append("<td align='center' class='th-line'>擅长路线</td>"); s.Append("<td align='center' class='th-line'>年审状态</td></tr>"); foreach (var item in userList) { s.Append("<tr><td align='center' >" + item.Name + "</td>"); s.Append("<td align='center'>" + item.Gender.ToString() + "</td>"); string str = string.Empty; if (item.SourceGuideCategoryList != null && item.SourceGuideCategoryList.Count > 0) { for (int i = 0; i < item.SourceGuideCategoryList.Count; i++) { if (i == item.SourceGuideCategoryList.Count - 1) { str += item.SourceGuideCategoryList[i].GuideCategory; } else { str += item.SourceGuideCategoryList[i].GuideCategory + ","; } } } s.Append("<td align='center'>" + str + "</td>"); s.Append("<td align='center'>" + item.Level + "</td>"); s.Append("<td align='center'>" + item.Language + "</td>"); s.Append("<td align='center'>" + item.Mobile + "</td>"); s.Append("<td align='center'>" + item.Counts + "</td>"); s.Append("<td align='center'>" + item.Days + "</td>"); s.Append("<td align='center'>" + item.AnchoredCom.ToString() + "</td>"); s.Append("<td align='center'>" + item.TourExperience + "</td>"); s.Append("<td align='center'>" + (item.AnnualReview == true ? "已审" : "未审") + "</td>"); s.Append("</tr>"); } s.Append("</table>"); } ResponseToXls(s.ToString()); }