gyhlw_dotnet/网站项目/VRS/Management/VSAT/StudentManage.aspx.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;

namespace VRS.Management.VSAT
{
    public partial class StudentManage : BaseListPage
    {
        DataService.BLL.admin_user bll = new DataService.BLL.admin_user();
        DataService.BLL.admin_log log = new DataService.BLL.admin_log();
        protected override void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                excel.HRef = "~/Upload/Excel/学员管理模板.xls";
                BindMajors(dpMajor, "");
                BindGrade(grade, "");
                DataLoad();
            }
        }

        protected override void DataLoad()
        {
            StringBuilder query = new StringBuilder(" 1 = 1 ");
            if (!string.IsNullOrWhiteSpace(login_name.Text.Trim()))
            {
                query.AppendFormat(" AND login_name LIKE '%{0}%' ", login_name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(real_name.Text.Trim()))
            {
                query.AppendFormat(" AND real_name LIKE '%{0}%' ", real_name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(id_card.Text.Trim()))
            {
                query.AppendFormat(" AND id_card LIKE '%{0}%' ", id_card.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(dpMajor.SelectedValue))
            {
                query.AppendFormat(" AND major = '{0}' ", dpMajor.SelectedValue);
            }
            if (!string.IsNullOrWhiteSpace(grade.SelectedValue))
            {
                query.AppendFormat(" AND grade = '{0}' ", grade.SelectedValue);
            }

            var data = bll.GetUsrUsers(query.ToString());
            dataList.DataSource = data;
            dataList.Rebind();
        }

        protected override void GridList_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {
            DataLoad();
        }

        protected override void GridList_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
        {
            DataLoad();
        }

        protected override void GridList_SortCommand(object sender, GridSortCommandEventArgs e)
        {
            DataLoad();
        }

        protected override void GrdList_DeleteCommand(object sender, GridCommandEventArgs e)
        {
            string Id = (e.Item as GridDataItem).OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString();
            if (Id.Equals("admin"))
            {
                RadAjaxManager1.Alert("admin账户无法删除！");
                return;
            }
            var model = bll.GetModel(Id);
            if (bll.Delete(Id))
            {
                log.write_log("删除学员成功。" + "姓名：" + model.real_name + "，学员ID：" + Id);
            }
            DataLoad();
        }

        protected override void AjaxManager_AjaxRequest(object sender, AjaxRequestEventArgs e)
        {

        }

        protected void btnSelect_Click(object sender, EventArgs e)
        {
            DataLoad();
        }

        protected void btnDelete_Click(object sender, EventArgs e)
        {
            var model = bll.GetModel(IdInput.Value);
            if (bll.Delete(IdInput.Value))
            {
                log.write_log("学员删除成功。" + "姓名：" + model.real_name + "，学员ID：" + IdInput.Value);
            }
            DataLoad();
        }
        /// <summary>
        /// 导出excel
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnExport_Click(object sender, EventArgs e)
        {
           
            string filePath = Server.MapPath("~/Download/");
            if (!Directory.Exists(filePath))
            {
                Directory.CreateDirectory(filePath);
            }
            string fileName = string.Format("{0}.xls", "学员列表_"+DateTime.Now.ToString("yyyyMMddHHmmss"));
            filePath = filePath + fileName;
          
            StringBuilder query = new StringBuilder(" 1 = 1 ");
            if (!string.IsNullOrWhiteSpace(login_name.Text.Trim()))
            {
                query.AppendFormat(" AND login_name LIKE '%{0}%' ", login_name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(real_name.Text.Trim()))
            {
                query.AppendFormat(" AND real_name LIKE '%{0}%' ", real_name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(id_card.Text.Trim()))
            {
                query.AppendFormat(" AND id_card LIKE '%{0}%' ", id_card.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(dpMajor.SelectedValue))
            {
                query.AppendFormat(" AND major = '{0}' ", dpMajor.SelectedValue);
            }
            var data = bll.GetUsrUsers(query.ToString());
            var source = data.Tables[0];
            //学号 姓名 性别 身份证号 出生日期 专业	年级	手机号码	备注
            var table = new DataTable();
            table.Columns.Add("入学");
            table.Columns.Add("专业");
            table.Columns.Add("学号");
            table.Columns.Add("姓名");
            table.Columns.Add("性别");
            table.Columns.Add("身份证号");
            table.Columns.Add("手机号码");
            table.Columns.Add("备注");
       
            for(var  i =0;i< source.Rows.Count;i++)
            {
                var row = table.NewRow();
                var res = source.Rows[i];
                row["入学"] = res["grade"];
                row["专业"] = res["major"];
                row["学号"] = res["login_name"];
                row["姓名"] = res["real_name"];
                row["性别"] = res["sex"];
                row["身份证号"] = res["id_card"];
                row["手机号码"] = res["mobile"];
                row["备注"] = res["r1"];
                table.Rows.Add(row);
            }

            VRS.Util.Import.DateTableToExcel(table, filePath);
            FileInfo fileInfo = new FileInfo(filePath);
            Response.Clear();
            Response.ClearContent();
            Response.ClearHeaders();
            Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
            Response.AddHeader("Content-Length", fileInfo.Length.ToString());
            Response.AddHeader("Content-Transfer-Encoding", "binary");
            Response.ContentType = "application/octet-stream";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
            Response.WriteFile(fileInfo.FullName);
            Response.Flush();
            Response.End();
        }

      
    }
}