protected void btnExport_Click(object sender, EventArgs e) { List <ProjectJudge> ls = new List <ProjectJudge>(); if (Session["ds"] != null) { ls = (List <ProjectJudge>)Session["ds"]; } DataTable dt = new DataTable(); DataColumn dc1 = new DataColumn("评审姓名", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("备注", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("是否通过", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); foreach (ProjectJudge item in ls) { DataRow row = dt.NewRow(); row["评审姓名"] = TeacherHelper.getTeacherNameByID(item.judge_id); row["备注"] = item.comment.Length == 0?"无":item.comment; row["是否通过"] = item.is_pass == 1?"是":"否"; dt.Rows.Add(row); } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "评审意见列表.xlsx"); }
protected void btnExport_Click(object sender, EventArgs e) { List <ProjectInfo> ls = new List <ProjectInfo>(); if (Session["ds"] != null) { ls = (List <ProjectInfo>)Session["ds"]; } DataTable dt = new DataTable(); DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("项目名称", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("项目类型", System.Type.GetType("System.String")); DataColumn dc4 = new DataColumn("提交者", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("提交时间", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); int count = 1; foreach (ProjectInfo item in ls) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["项目名称"] = item.name; row["项目类型"] = item.category_name; row["提交者"] = item.teacher_name; row["提交时间"] = item.submit_time; dt.Rows.Add(row); count++; } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "项目列表.xls"); }
private static MemoryStream GetMemoryStream(User user) { //var users = Models.User.DefaultSection.Where(user); var users = Models.User.DefaultSection; DataTable dt = ExcleHelper.ToDataTable(users); MemoryStream ms = ExcleHelper.BuildWorkbook(dt); return(ms); }
protected void btnExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); using (var db = new TeachingCenterEntities()) { List <Service> service; DateTime min = new DateTime(1900, 1, 1); DateTime max = new DateTime(2300, 12, 31); if (logmin.Value != "") { min = Convert.ToDateTime(logmin.Value); } if (logmax.Value != "") { max = Convert.ToDateTime(logmax.Value).AddDays(1); } if (dropCategory.SelectedValue != "全部分类") { int category = ServiceHelper.getCategoryID(dropCategory.SelectedValue); service = db.Service.Where(a => a.Service_isdeleted == 0 && a.Service_category == category && a.Service_time >= min && a.Service_time <= max).OrderBy(a => a.Service_isdeal).ThenByDescending(a => a.Service_time).ToList(); } else { service = db.Service.Where(a => a.Service_isdeleted == 0 && a.Service_time >= min && a.Service_time <= max).OrderBy(a => a.Service_isdeal).ThenByDescending(a => a.Service_time).ToList(); } DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("申请人", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("申请时间", System.Type.GetType("System.DateTime")); DataColumn dc4 = new DataColumn("联系方式", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("备注", System.Type.GetType("System.String")); DataColumn dc6 = new DataColumn("审核状态", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); dt.Columns.Add(dc6); int count = 1; foreach (var i in service) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["申请人"] = TeacherHelper.getTeacherNameByID(i.Service_teacher); row["申请时间"] = i.Service_time.ToString(); row["联系方式"] = i.Service_phone.ToString(); row["备注"] = i.Service_remarks.ToString(); row["审核状态"] = i.Service_isdeal == 0 ? "未处理" : "已处理"; dt.Rows.Add(row); } } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "教师服务申请.xls"); }
protected void lbtExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); using (var db = new TeachingCenterEntities()) { DateTime now = DateTime.Now; DateTime last = now.AddYears(-1); int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); //int teacher = 1; var at = from it in db.ActivityTeacher where it.teacher_id == teacher select it; List <Activity> ac = new List <Activity>(); foreach (var i in at) { Activity activity = db.Activity.Single(a => a.Activity_id == i.activity_id && a.Activity_hold_time >= last && a.Activity_hold_time <= now); if (activity.Activity_isdeleted == 0) { ac.Add(activity); } } DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("活动类型", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("活动名称", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("活动地点", System.Type.GetType("System.String")); DataColumn dc4 = new DataColumn("活动时间", System.Type.GetType("System.DateTime")); dt.Columns.Add(dc1); dt.Columns.Add(dc5); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); int count = 1; foreach (var i in ac) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["活动类型"] = ActivityHelper.getCategoryName(i.Activity_categoryid); row["活动名称"] = i.Activity_title; row["活动地点"] = i.Activity_place; row["活动时间"] = i.Activity_hold_time; dt.Rows.Add(row); } } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "我的活动.xls"); }
protected void lbtExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); using (var db = new TeachingCenterEntities()) { List <Service> service; DateTime now = DateTime.Now; DateTime last = now.AddYears(-1); service = db.Service.Where(a => a.Service_isdeleted == 0 && a.Service_teacher == teacher && a.Service_time >= last && a.Service_time < now).OrderBy(a => a.Service_isdeal).ThenByDescending(a => a.Service_time).ToList(); DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc1_1 = new DataColumn("申请类型", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("申请人", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("申请时间", System.Type.GetType("System.DateTime")); DataColumn dc4 = new DataColumn("联系方式", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("备注", System.Type.GetType("System.String")); DataColumn dc6 = new DataColumn("审核状态", System.Type.GetType("System.String")); DataColumn dc7 = new DataColumn("管理员回复", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc1_1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); dt.Columns.Add(dc6); dt.Columns.Add(dc7); int count = 1; foreach (var i in service) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["申请人"] = TeacherHelper.getTeacherNameByID(i.Service_teacher); row["申请类型"] = ServiceHelper.getCategoryName(i.Service_category); row["申请时间"] = i.Service_time.ToString(); row["联系方式"] = i.Service_phone.ToString(); row["备注"] = i.Service_remarks.ToString(); row["审核状态"] = i.Service_isdeal == 0 ? "未处理" : "已处理"; row["管理员回复"] = i.Service_reply; dt.Rows.Add(row); } } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "我的服务.xls"); }
protected void Page_Load(object sender, EventArgs e) { string r = ""; B_ProductionItemBll bpib = new B_ProductionItemBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { HttpFileCollection files = Request.Files; ExcleHelper eh = new ExcleHelper(); string newname = DateTime.Now.ToString("yyyyMMddhhmmssfff"); UpFile uf = new UpFile(); ArrayList efile = new ArrayList(); string url = "/UpFile/ImageMeasure/"; string ur = uf.UpXls(files[0], newname, url, 10240000); if (ur.Length > 1) { string furl = url + ur; string msg = ""; DataTable dt = eh.GetExcelTableByOleDB(furl, "SAP生产统计", true, ref msg); if (msg == "") { if (bpib.UpdateWorkLine(dt) > 0) { r = "S"; } else { r = "F"; } } else { r = "F"; } } else { r = ur; } } else { r = iv.badstr; } Response.Write("{ msg:'" + r + "'}"); Response.End(); }
protected void btnExcel_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); int id = Convert.ToInt16(Request.QueryString["id"]); using (var db = new TeachingCenterEntities()) { List <ActivityTeacher> at = db.ActivityTeacher.Where(a => a.activity_id == id).ToList(); List <Teacher> teacher = new List <Teacher>(); foreach (ActivityTeacher i in at) { Teacher t = db.Teacher.SingleOrDefault(a => a.id == i.teacher_id); teacher.Add(t); } DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("教师工号", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("教师姓名", System.Type.GetType("System.String")); DataColumn dc4 = new DataColumn("教师电话号码", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("教师邮箱", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); int count = 1; foreach (var i in teacher) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["教师工号"] = i.number; row["教师姓名"] = i.name; row["教师电话号码"] = i.phone_number; row["教师邮箱"] = i.email; count++; dt.Rows.Add(row); } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "活动名单.xls"); } }
protected void btnExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); using (var db = new TeachingCenterEntities()) { List <Activity> acsu; DateTime min = new DateTime(1900, 1, 1); DateTime max = new DateTime(2300, 12, 31); if (logmin.Value != "") { min = Convert.ToDateTime(logmin.Value); } if (logmax.Value != "") { max = Convert.ToDateTime(logmax.Value).AddDays(1); } if (txtSearch.Text == "") { if (dropCategory.SelectedValue != "全部分类") { int category = ActivityHelper.getCategoryId(dropCategory.SelectedValue); acsu = db.Activity.Where(a => a.Activity_isdeleted == 0 && a.Activity_categoryid == category && a.Activity_hold_time >= min && a.Activity_hold_time < max).OrderByDescending(a => a.Activity_hold_time).ToList(); } else { acsu = db.Activity.Where(a => a.Activity_isdeleted == 0 && a.Activity_hold_time >= min && a.Activity_hold_time < max).OrderByDescending(a => a.Activity_hold_time).ToList(); } } else { if (dropCategory.SelectedValue != "全部分类") { int category = ActivityHelper.getCategoryId(dropCategory.SelectedValue); acsu = db.Activity.Where(a => a.Activity_isdeleted == 0 && a.Activity_categoryid == category && a.Activity_hold_time >= min && a.Activity_hold_time < max && a.Activity_title.Contains(txtSearch.Text)).OrderByDescending(a => a.Activity_hold_time).ToList(); } else { acsu = db.Activity.Where(a => a.Activity_isdeleted == 0 && a.Activity_hold_time >= min && a.Activity_hold_time < max && a.Activity_title.Contains(txtSearch.Text)).OrderByDescending(a => a.Activity_hold_time).ToList(); } } DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("标题", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("发布人", System.Type.GetType("System.String")); DataColumn dc4 = new DataColumn("活动时间", System.Type.GetType("System.DateTime")); DataColumn dcx = new DataColumn("活动地点", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("人数", System.Type.GetType("System.String")); DataColumn dc6 = new DataColumn("活动类型", System.Type.GetType("System.String")); DataColumn dc7 = new DataColumn("参与名单", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dcx); dt.Columns.Add(dc5); dt.Columns.Add(dc6); dt.Columns.Add(dc7); int count = 1; foreach (var i in acsu) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["标题"] = i.Activity_title; row["活动地点"] = i.Activity_place; row["发布人"] = i.Activity_author; row["活动时间"] = i.Activity_hold_time.ToString(); row["人数"] = i.Activity_nowcount.ToString() + " / " + i.Activity_limitcount.ToString(); row["活动类型"] = ActivityHelper.getCategoryName(i.Activity_categoryid); row["参与名单"] = ActivityHelper.getTeacherList(i.Activity_id); count++; dt.Rows.Add(row); } } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "活动信息.xls"); }