/// <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());
}
