if (!string.IsNullOrEmpty(CUSTOMERNAME))
{
sqlWhere += string.Format(@" and A.CUSTOMERNAME like ‘%{0}%’ ", CUSTOMERNAME);
}
if (!string.IsNullOrEmpty(FACTORYNAME))
{
sqlWhere += string.Format(@" and A.FACTORYNAME = ‘{0}’ ", FACTORYNAME);
}
if (!string.IsNullOrEmpty(CREATEDON))
{
sqlWhere += string.Format(@" and to_date(to_char(A.CREATEDON,‘yyyy-MM-dd’),‘yyyy-MM-dd’) >= to_date(‘{0}’,‘yyyy-MM-dd’)", CREATEDON);
}
if (!string.IsNullOrEmpty(CREATEDON1))
{
sqlWhere += string.Format(@" and to_date(to_char(A.CREATEDON,‘yyyy-MM-dd’),‘yyyy-MM-dd’) <= to_date(‘{0}’,‘yyyy-MM-dd’)", CREATEDON1);
}
if (!string.IsNullOrEmpty(STATE))
{
sqlWhere += string.Format(@" and A.STATE =‘{0}’ ", STATE);
}
//加载要导出的数据
List ListData = new List();
string sql = string.Format(@“select A.* from YH_SPEED_APPLY A {0} order by A.CREATEDON desc”, sqlWhere);
ListData = db.GetHashtable(sql);
//设置要导出的位置
string fileName = string.Format(“YH_SPEED_APPLY_{0}.xlsx”, DateTime.Now.ToString(“yyyyMMddHHmmss”));
string serverPath = Server.MapPath(“~/Upload/DownloadExcal/YH_SPEED_APPLY/”);
if (!Directory.Exists(serverPath))
{
Directory.CreateDirectory(serverPath);
}
string fileUrl = Path.Combine(serverPath, fileName);
FileInfo info = new FileInfo(fileUrl);
if (info.Exists)
{
info.Delete();
info = new FileInfo(fileUrl);
}
using (ExcelPackage package = new ExcelPackage(info))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(“印花车速申请”);
ListToExcel(worksheet, ListData);
package.Save();
}
string path = “/Upload/DownloadExcal/YH_SPEED_APPLY/” + fileName;
Hashtable result = new Hashtable();
result[“url”] = path;
return Json(result);
}
catch (Exception ex)
{
return Content(ex.Message);
}
}
}
//列表转为Excel
public void ListToExcel(ExcelWorksheet excelWorksheet, List list)
{
//定义Excel行数
int lineNumber = 1, columnNumber = 1;
//绘制Excel总标题
excelWorksheet.Cells[lineNumber, 1, lineNumber, 14].Value = “印花车速申请”;
excelWorksheet.Cells[lineNumber, 1, lineNumber, 14].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
excelWorksheet.Cells[lineNumber, 1, lineNumber, 14].Style.Font.SetFromFont(new Font(“宋体”, 20f, FontStyle.Regular));
excelWorksheet.Cells[lineNumber, 1, lineNumber, 14].Merge = true;
//绘制Excel列表标题
lineNumber++; columnNumber = 0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请分厂”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请日期”;
excelWorksheet.Column(columnNumber).Width = 20.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请人”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请类型”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请机台”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “状态”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “客户名称”;
excelWorksheet.Column(columnNumber).Width = 25.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “色号”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “品名”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “米数”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “申请车速”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “磁棒”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “车速申请的原因”;
excelWorksheet.Column(columnNumber).Width = 25.0;
excelWorksheet.Cells[lineNumber, ++columnNumber].Value = “其他备注”;
excelWorksheet.Column(columnNumber).Width = 15.0;
excelWorksheet.Cells[lineNumber, 1, lineNumber, columnNumber].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
//绘制Excel列表
lineNumber++;
if (list.Count > 0)
{
foreach (var items in list)
{
columnNumber = 0;
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“FACTORYNAME”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“CREATEDON”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“CREATEDNAME”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“TYPE”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“MACHINE”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“STATE”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“CUSTOMERNAME”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“COLORCODE”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“PRODUCTNAME”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“METERS”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“SPEED”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“MAGNETICBAR”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“REASON”].ToString());
DrawExcelListCell(excelWorksheet, lineNumber, ++columnNumber, items[“REMARK”].ToString());
excelWorksheet.Row(lineNumber).Height = 20.0;
lineNumber++;
}
}
}
//绘制列表单元格
public void DrawExcelListCell(ExcelWorksheet excelWorksheet, int lineNumber, int columnNumber, string value)
{
using (ExcelRange range = excelWorksheet.Cells[lineNumber, columnNumber])
{
range.Value = value;
range.Style.Font.SetFromFont(new Font(“宋体”, 10f, FontStyle.Regular));
range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
range.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
range.Style.WrapText = true;
}
}
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上前端开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录大纲截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且后续会持续更新
如果你觉得这些内容对你有帮助,可以添加V获取:vip1024c (备注前端)
学习分享,共勉
题外话,毕竟我工作多年,深知技术改革和创新的方向,Flutter作为跨平台开发技术、Flutter以其美观、快速、高效、开放等优势迅速俘获人心
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
-1712900881880)]
学习分享,共勉
题外话,毕竟我工作多年,深知技术改革和创新的方向,Flutter作为跨平台开发技术、Flutter以其美观、快速、高效、开放等优势迅速俘获人心
[外链图片转存中…(img-8CPEL11Q-1712900881881)]
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
[外链图片转存中…(img-7vDGjW98-1712900881881)]