protected void Page_Load(object sender, EventArgs e)
{
RequireLogin();
List<com.hooyes.crc.Model.CRCapply> Company = new List<CRCapply>();
com.hooyes.crc.DAL.RegisterAdmin reg = new RegisterAdmin();
Company = reg.ListModel();
StringBuilder sb = new StringBuilder();
foreach (CRCapply cr in Company)
{
string Vistors = cr.Vistors;
string[] vSpace = { "|#|" };
string[] vComma = { "," };
string[] vS = Vistors.Split(vSpace, StringSplitOptions.None);
string[] vName = vS[0].Split(vComma, StringSplitOptions.None);
string[] vGender = vS[1].Split(vComma, StringSplitOptions.None);
string[] vTitle = vS[2].Split(vComma, StringSplitOptions.None);
string[] vPhone = vS[3].Split(vComma, StringSplitOptions.None);
string[] vCellPhone = vS[4].Split(vComma, StringSplitOptions.None);
for (int i = 0; i < vName.Length; i++)
{
if (!string.IsNullOrEmpty(vName[i]))
{
string CSVLine = vName[i] + "," + Sex(vGender[i]) + "," + vTitle[i] + "," + vPhone[i] + "," + vCellPhone[i];
CSVLine += "," + NoComma(cr.CompanyName) + "," + NoComma(cr.CompanyNameEn) + "," + NoComma(cr.Contact) + "," + NoComma(cr.CompanyType) + "," + NoComma(cr.ProductType) + "," + NoComma(cr.Email) + "," + NoComma(cr.Phone) + "," + NoComma(cr.CellPhone) + "," + NoComma(cr.Fax) + "," + NoComma(cr.CompanyAddress) + "," + NoComma(cr.PostCode);
CSVLine += "," + NoComma(cr.WebSite) + "," + NoComma(cr.Suggestion);
CSVLine+= "," + Invoice(cr.Invoice)+","+Pay(cr.Pay)+","+ NoComma(cr.RegisterTime.ToString("yyyy-MM-dd"));
sb.AppendLine(CSVLine);
}
}
}
Export(sb.ToString());
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="xKeyWord"></param>
protected void InitPage(string xKeyWord)
{
int page = Convert.ToInt32(Request.QueryString.Get("page"));
page = (page <= 0) ? 1 : page;
string keyWord = Request.QueryString.Get("keyWord");
keyWord = (string.IsNullOrEmpty(xKeyWord)) ? keyWord : xKeyWord;
RegisterAdmin reg = new RegisterAdmin();
int CurrentPage = page;
int PageSize =20;
int RecordsCount = reg.count(keyWord);
PageSize = (PageSize > 0) ? PageSize : 1;
int PagesCount = RecordsCount / PageSize;
PagesCount = ((RecordsCount % PageSize) == 0) ? PagesCount : PagesCount + 1;
CurrentPage = (CurrentPage > PagesCount) ? PagesCount : CurrentPage;
List<CRCapply> xList = new List<CRCapply>();
xList = reg.ListModel(PageSize, CurrentPage, keyWord);
string HTMLTemplate = @"
<tr>
<td class='ListTableTdA'><input name='sn' id=""Checkbox{0}"" value='{2}' type=""checkbox"" /></td>
<td class='ListTableTdB'><a href='ModifyInfo.aspx?sn={2}' target='_blank'>{1}</a></td>
<td class='ListTableTdDate'>{9}</td>
<td class='ListTableTdE'><span rel='{2}' pay='{6}' class='{5}'>{3}</span></td>
<td class='ListTableTdF'><span rel='{2}' invoice='{7}' class='{8}'>{4}</span></td>
<td class='ListTableTdC'><a href='Delete.aspx?sn={2}' onclick='return confirm(""确定要删除{1}吗?"")' >删除</a></td>
<td class='ListTableTdD'><a href='ModifyInfo.aspx?sn={2}' target='_blank'>编缉</a></td>
</tr>";
StringBuilder sb = new StringBuilder();
sb.Append("<table class='ListTable'>");
sb.Append(@"<tr class='ListHead'><td><input id=""CheckboxAllC"" onclick='JSCheckAll(this)' type=""checkbox"" />全选</td><td class='AdminTdA'>公司名称</td>
<td>报名时间</td>
<td>交费状态</td><td>开发票</td>
<td>删除</td><td>编辑</td></tr>");
object[] param = new object[10];
for (int i = 0; i < xList.Count; i++)
{
param[0] = i;
param[1] = xList[i].CompanyName;
param[2] = xList[i].sn;
param[3] = xList[i].Pay ? "已付" : "未付";
param[4] = xList[i].Invoice ? "是" : "否";
param[5] = xList[i].Pay ? "pay" : "unpay";
param[6] = xList[i].Pay;
param[7] = xList[i].Invoice;
param[8] = xList[i].Invoice ? "invoice" : "uninvoice";
param[9] = xList[i].RegisterTime.ToString("yyyy-MM-dd");
sb.AppendFormat(HTMLTemplate, param);
}
sb.Append("</table>");
xLiteral1.Text = sb.ToString();
//分页导航
string PageIndexUrl = null;
StringBuilder PageIndexUrlSb = new StringBuilder();
PageIndexUrlSb.Append("default.aspx?");
PageIndexUrlSb.AppendFormat("keyWord={0}&", HttpUtility.UrlEncode(keyWord));
PageIndexUrlSb.Append("page");
PageIndexUrl = PageIndexUrlSb.ToString();
pageLiteral1.Text = com.hooyes.crc.helper.Page.ShowPage(PageIndexUrl, "", RecordsCount, PageSize, CurrentPage, true, "个");
//显示关键字导航
ShowTip(keyWord);
//test
//reg.SetPayStatus("893a0934-7f8e-480e-9095-7d02383437f2", false);
// reg.SetInvoicStatus("893a0934-7f8e-480e-9095-7d02383437f2", true);
}