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");
}
