public ActionResult ToExcel() { int Status = WebUtil.GetFormValue<int>("Status", 0); string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); string CusName = WebUtil.GetFormValue<string>("CusName", string.Empty); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); PageInfo pageInfo = new PageInfo() { PageIndex = 1, PageSize = int.MaxValue }; OutStorageEntity entity = new OutStorageEntity(); if (Status > 0) { entity.Where(a => a.Status == Status); } if (!OrderNum.IsEmpty()) { entity.Where("OrderNum", ECondition.Like, "%" + OrderNum + "%"); } if (!CusName.IsEmpty()) { entity.Begin<OutStorageEntity>() .And<OutStorageEntity>("CusNum", ECondition.Like, "%" + CusName + "%") .Or<OutStorageEntity>("CusName", ECondition.Like, "%" + CusName + "%") .End<OutStorageEntity>() ; } if (!beginTime.IsEmpty() && !endTime.IsEmpty()) { entity.Where("OrderTime", ECondition.Between, ConvertHelper.ToType<DateTime>(beginTime), ConvertHelper.ToType<DateTime>(endTime)); } entity.And(a => a.StorageNum == this.DefaultStore); Bill<OutStorageEntity, OutStoDetailEntity> bill = new OutStorageOrder(); List<OutStorageEntity> listResult = bill.GetList(entity, ref pageInfo); listResult = listResult == null ? new List<OutStorageEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("出库单编号 ")); dt.Columns.Add(new DataColumn("出库类型")); dt.Columns.Add(new DataColumn("客户名称")); dt.Columns.Add(new DataColumn("关联单号")); dt.Columns.Add(new DataColumn("总数量")); dt.Columns.Add(new DataColumn("总金额")); dt.Columns.Add(new DataColumn("状态")); dt.Columns.Add(new DataColumn("制单人")); dt.Columns.Add(new DataColumn("操作方式")); dt.Columns.Add(new DataColumn("创建时间")); int count = 1; foreach (OutStorageEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.OrderNum; row[2] = EnumHelper.GetEnumDesc<EOutType>(t.OutType); row[3] = t.CusName; row[4] = t.ContractOrder; row[5] = t.Num; row[6] = t.Amount; row[7] = EnumHelper.GetEnumDesc<EAudite>(t.Status); row[8] = t.CreateUserName; row[9] = EnumHelper.GetEnumDesc<EOpType>(t.OperateType); row[10] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("出库管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("出库管理", "出库单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string StorageNum = WebUtil.GetFormValue<string>("StorageName", string.Empty); string LocalName = WebUtil.GetFormValue<string>("LocalName", string.Empty); string LocalType = WebUtil.GetFormValue<string>("LocalType", string.Empty); LocationProvider provider = new LocationProvider(); LocationEntity entity = new LocationEntity(); StorageEntity SEntity = new StorageEntity(); SEntity.Include(a => new { StorageName = a.StorageName }); entity.Left<StorageEntity>(SEntity, new Params<string, string>() { Item1 = "StorageNum", Item2 = "StorageNum" }); if (!StorageNum.IsEmpty()) { entity.Where<LocationEntity>("StorageNum", ECondition.Like, "%" + StorageNum + "%"); } if (!LocalName.IsEmpty()) { entity.Begin<LocationEntity>() .Where<LocationEntity>("LocalName", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalNum", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalBarCode", ECondition.Like, "%" + LocalName + "%") .End<LocationEntity>() ; } if (!LocalType.IsEmpty()) { entity.Where<LocationEntity>("LocalType", ECondition.Like, "%" + LocalType + "%"); } List<LocationEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<LocationEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("库位编号 ")); dt.Columns.Add(new DataColumn("库位名 ")); dt.Columns.Add(new DataColumn("所在仓库 ")); dt.Columns.Add(new DataColumn("库位类型")); dt.Columns.Add(new DataColumn("是否禁用")); dt.Columns.Add(new DataColumn("是否默认")); dt.Columns.Add(new DataColumn("创建时间")); int count = 1; foreach (LocationEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.LocalNum; row[2] = t.LocalName; row[3] = t.StorageName; row[4] = EnumHelper.GetEnumDesc<ELocalType>(t.LocalType); row[5] = EnumHelper.GetEnumDesc<EBool>(t.IsForbid); row[6] = EnumHelper.GetEnumDesc<EBool>(t.IsDefault); row[7] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("库位管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("库位管理", "库位", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string SupNum = WebUtil.GetFormValue<string>("SupNum", string.Empty); SupplierProvider provider = new SupplierProvider(); SupplierEntity entity = new SupplierEntity(); List<SupplierEntity> list = provider.GetList(); if (!list.IsNullOrEmpty()) { List<SupplierEntity> listResult = list.Where(a => a.SupNum.Contains(SupNum) || a.SupName.Contains(SupNum)).ToList(); listResult = listResult.IsNull() ? new List<SupplierEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("供应商编号")); dt.Columns.Add(new DataColumn("供应商名称")); dt.Columns.Add(new DataColumn("电话")); dt.Columns.Add(new DataColumn("传真")); dt.Columns.Add(new DataColumn("Email")); dt.Columns.Add(new DataColumn("联系人")); dt.Columns.Add(new DataColumn("地址")); dt.Columns.Add(new DataColumn("描述")); int count = 1; foreach (SupplierEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.SupNum; row[2] = t.SupName; row[3] = t.Phone; row[4] = t.Fax; row[5] = t.Email; row[6] = t.ContactName; row[7] = t.Address; row[8] = t.Description; dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("供应商管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("供应商管理", "供应商", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!") ; } } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { int Status = WebUtil.GetFormValue<int>("Status", 0); string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); string BadType = WebUtil.GetFormValue<string>("BadType", string.Empty); string ProductType = WebUtil.GetFormValue<string>("ProductType", string.Empty); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); int pageSize = WebUtil.GetFormValue<int>("PageSize", 10); int pageIndex = WebUtil.GetFormValue<int>("PageIndex", 1); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; BadReportEntity entity = new BadReportEntity(); if (Status > 0) { entity.Where(a => a.Status == Status); } if (!OrderNum.IsEmpty()) { entity.Where("OrderNum", ECondition.Like, "%" + OrderNum + "%"); } if (!ProductType.IsEmpty()) { entity.Where("ProductType", ECondition.Eth, ProductType); } if (!BadType.IsEmpty()) { entity.Where("BadType", ECondition.Eth, BadType); } if (!beginTime.IsEmpty() && !endTime.IsEmpty()) { entity.Where("CreateTime", ECondition.Between, ConvertHelper.ToType<DateTime>(beginTime), ConvertHelper.ToType<DateTime>(endTime)); } entity.And(a => a.StorageNum == this.DefaultStore); Bill<BadReportEntity, BadReportDetailEntity> bill = new BadOrder(); List<BadReportEntity> listResult = bill.GetList(entity, ref pageInfo); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("单据编号")); dt.Columns.Add(new DataColumn("报损类型")); dt.Columns.Add(new DataColumn("关联单号")); dt.Columns.Add(new DataColumn("报损数量")); dt.Columns.Add(new DataColumn("状态")); dt.Columns.Add(new DataColumn("操作方式")); dt.Columns.Add(new DataColumn("创建人")); dt.Columns.Add(new DataColumn("创建时间")); int count = 1; foreach (BadReportEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.OrderNum; row[2] = EnumHelper.GetEnumDesc<EBadType>(t.BadType); row[3] = t.ContractOrder; row[4] = t.Num; row[5] = EnumHelper.GetEnumDesc<EAudite>(t.Status); row[6] = EnumHelper.GetEnumDesc<EOpType>(t.OperateType); row[7] = t.CreateUser; row[8] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("报损管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("报损管理", "报损单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string roleName = WebUtil.GetFormValue<string>("roleName", string.Empty); SysRoleProvider provider = new SysRoleProvider(); SysRoleEntity entity = new SysRoleEntity(); List<SysRoleEntity> list = provider.GetList(); List<SysRoleEntity> listResult = new List<SysRoleEntity>(); if (!list.IsNullOrEmpty()) { listResult = list.Where(a => a.RoleNum.Contains(roleName) || a.RoleName.Contains(roleName)).OrderByDescending(a => a.ID).ToList(); } if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号")); dt.Columns.Add(new DataColumn("角色编号")); dt.Columns.Add(new DataColumn("角色名")); dt.Columns.Add(new DataColumn("创建时间")); dt.Columns.Add(new DataColumn("备注")); int count = 1; foreach (SysRoleEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.RoleNum; row[2] = t.RoleName; row[3] = t.CreateTime; row[4] = t.Remark; count++; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("角色管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("角色管理", "角色", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!") ; } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { int status = WebUtil.GetFormValue<int>("Status", 0); string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); int pageSize = Int32.MaxValue; int pageIndex = WebUtil.GetFormValue<int>("PageIndex", 1); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; ReturnOrderEntity entity = new ReturnOrderEntity(); if (status > 0) { entity.Where(a => a.Status == status); } if (!orderNum.IsEmpty()) { entity.Where("OrderNum", ECondition.Like, "%" + orderNum + "%"); } if (!beginTime.IsEmpty() && !endTime.IsEmpty()) { entity.Where("OrderTime", ECondition.Between, ConvertHelper.ToType<DateTime>(beginTime), ConvertHelper.ToType<DateTime>(endTime)); } entity.And(a => a.StorageNum == this.DefaultStore); Bill<ReturnOrderEntity, ReturnDetailEntity> bill = new ReturnOrder(); List<ReturnOrderEntity> listResult = bill.GetList(entity, ref pageInfo); listResult = listResult == null ? new List<ReturnOrderEntity>() : listResult; if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("退货单")); dt.Columns.Add(new DataColumn("退货类型")); dt.Columns.Add(new DataColumn("退货数量")); dt.Columns.Add(new DataColumn("关联单号")); dt.Columns.Add(new DataColumn("状态")); dt.Columns.Add(new DataColumn("制单人")); dt.Columns.Add(new DataColumn("操作方式")); dt.Columns.Add(new DataColumn("创建时间")); foreach (ReturnOrderEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.OrderNum; row[1] = EnumHelper.GetEnumDesc<ECheckType>(t.ReturnType); row[2] = t.Num; row[3] = t.ContractOrder; row[4] = EnumHelper.GetEnumDesc<EAudite>(t.Status); row[5] = t.CreateUserName; row[6] = EnumHelper.GetEnumDesc<EOpType>(t.OperateType); row[7] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("退货单{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("退货管理", "退货单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
/// <summary> /// 导出Excel /// </summary> /// <returns></returns> public ActionResult ToExcel() { int status = WebUtil.GetFormValue<int>("Status", 0); string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); string supName = WebUtil.GetFormValue<string>("SupName", string.Empty); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); int pageSize = Int32.MaxValue; int pageIndex = 1; PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; InStorageEntity entity = new InStorageEntity(); if (status > 0) { entity.Where(a => a.Status == status); } if (!orderNum.IsEmpty()) { entity.Where("OrderNum", ECondition.Like, "%" + orderNum + "%"); } if (!supName.IsEmpty()) { entity.AndBegin<InStorageEntity>() .And<InStorageEntity>("SupNum", ECondition.Like, "%" + supName + "%") .Or<InStorageEntity>("SupName", ECondition.Like, "%" + supName + "%") .End<InStorageEntity>() ; } if (!beginTime.IsEmpty() && !endTime.IsEmpty()) { entity.Where("OrderTime", ECondition.Between, ConvertHelper.ToType<DateTime>(beginTime), ConvertHelper.ToType<DateTime>(endTime)); } Bill<InStorageEntity, InStorDetailEntity> bill = new InStorageOrder(); List<InStorageEntity> listResult = bill.GetList(entity, ref pageInfo); listResult = listResult == null ? new List<InStorageEntity>() : listResult; DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("入库单单号")); dt.Columns.Add(new DataColumn("入库类型")); dt.Columns.Add(new DataColumn("供应商")); dt.Columns.Add(new DataColumn("关联单号")); dt.Columns.Add(new DataColumn("货品总数")); dt.Columns.Add(new DataColumn("总金额")); dt.Columns.Add(new DataColumn("状态")); dt.Columns.Add(new DataColumn("制单人")); dt.Columns.Add(new DataColumn("操作方式")); dt.Columns.Add(new DataColumn("创建时间")); foreach (InStorageEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.OrderNum; row[1] = EnumHelper.GetEnumDesc<EInType>(t.InType); row[2] = t.SupName; row[3] = t.ContractOrder; row[4] = t.Num; row[5] = t.Amount.ToString("0.00")+" 元"; row[6] = EnumHelper.GetEnumDesc<EAudite>(t.Status); row[7] = t.CreateUserName; row[8] = EnumHelper.GetEnumDesc<EOpType>(t.OperateType); row[9] = t.OrderTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("入库单{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("入库管理", "入库单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string ProductName = WebUtil.GetFormValue<string>("ProductName", string.Empty); int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0); int pageSize = WebUtil.GetFormValue<int>("pageSize", 0); string CateNum = WebUtil.GetFormValue<string>("CateNum", string.Empty); ProductProvider provider = new ProductProvider(); ProductEntity entity = new ProductEntity(); if (!ProductName.IsEmpty()) { entity.Where<ProductEntity>("ProductName", ECondition.Like, "%" + ProductName + "%"); } if (!CateNum.IsEmpty()) { entity.Where<ProductEntity>("CateNum", ECondition.Eth, CateNum); } List<ProductEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<ProductEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("产品编号")); dt.Columns.Add(new DataColumn("条码编号")); dt.Columns.Add(new DataColumn("产品名称")); dt.Columns.Add(new DataColumn("类别名称")); dt.Columns.Add(new DataColumn("库存数")); dt.Columns.Add(new DataColumn("预警值下线")); dt.Columns.Add(new DataColumn("预警值上线")); dt.Columns.Add(new DataColumn("单位")); dt.Columns.Add(new DataColumn("平均价格")); dt.Columns.Add(new DataColumn("进口价格")); dt.Columns.Add(new DataColumn("出口价格")); dt.Columns.Add(new DataColumn("净重")); dt.Columns.Add(new DataColumn("毛重")); dt.Columns.Add(new DataColumn("备注")); int count = 1; foreach (ProductEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.SnNum; row[2] = t.BarCode; row[3] = t.ProductName; row[4] = t.CateName; row[5] = t.Num; row[6] = t.MinNum; row[7] = t.MaxNum; row[8] = t.UnitName; row[9] = t.AvgPrice; row[10] = t.InPrice; row[11] = t.OutPrice; row[12] = t.NetWeight.ToString(); row[13] = t.GrossWeight.ToString(); row[14] = t.Remark; dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("产品管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("产品管理", "产品", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToCheckExcel() { string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); List<CheckDataEntity> listResult = new CheckDataProvider().GetCheckOrder(orderNum); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("库位名称")); dt.Columns.Add(new DataColumn("库位编号")); dt.Columns.Add(new DataColumn("产品编码")); dt.Columns.Add(new DataColumn("产品条码")); dt.Columns.Add(new DataColumn("产品名称")); dt.Columns.Add(new DataColumn("批次")); dt.Columns.Add(new DataColumn("盘点数")); foreach (CheckDataEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.LocalName; row[1] = t.LocalNum; row[2] = t.ProductNum; row[3] = t.BarCode; row[4] = t.ProductName; row[5] = t.BatchNum; row[6] = ""; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("盘点管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("盘点管理", "盘点单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string userCode = WebUtil.GetFormValue<string>("userCode", string.Empty); string userName = WebUtil.GetFormValue<string>("userName", string.Empty); string roleNum = WebUtil.GetFormValue<string>("roleNum", string.Empty); string departNum = WebUtil.GetFormValue<string>("departNum", string.Empty); AdminProvider provider = new AdminProvider(); AdminEntity entity = new AdminEntity(); if (!userCode.IsEmpty()) { entity.Where("UserCode", ECondition.Like, userCode + "%"); } if (!userName.IsEmpty()) { entity.Where("UserName", ECondition.Like, userName + "%"); } if (!roleNum.IsEmpty()) { entity.And(a => a.RoleNum == roleNum); } if (!departNum.IsEmpty()) { entity.And(a => a.DepartNum == departNum); } List<AdminEntity> listResult = provider.GetList(entity, ref pageInfo); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("用户名")); dt.Columns.Add(new DataColumn("编号")); dt.Columns.Add(new DataColumn("真名")); dt.Columns.Add(new DataColumn("Email")); dt.Columns.Add(new DataColumn("联系方式")); dt.Columns.Add(new DataColumn("登录次数")); dt.Columns.Add(new DataColumn("部门")); dt.Columns.Add(new DataColumn("角色")); foreach (AdminEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.UserName; row[1] = t.UserCode; row[2] = t.RealName; row[3] = t.Email; row[4] = t.Mobile; row[5] = t.LoginCount; row[6] = t.DepartName; row[7] = t.RoleName; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("员工管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("员工管理", "员工", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { string StorageName = WebUtil.GetFormValue<string>("StorageName", string.Empty); int StorageType = WebUtil.GetFormValue<int>("StorageType", -1); int IsForbid = WebUtil.GetFormValue<int>("IsForbid", -1); PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; StorageProvider provider = new StorageProvider(); StorageEntity entity = new StorageEntity(); if (IsForbid > -1) { entity.Where<StorageEntity>("IsForbid", ECondition.Eth, IsForbid); } if (StorageType > -1) { entity.Where<StorageEntity>("StorageType", ECondition.Eth, StorageType); } if (!StorageName.IsEmpty()) { entity.Begin<StorageEntity>() .Where<StorageEntity>("StorageName", ECondition.Like, "%" + StorageName + "%") .Or<StorageEntity>("StorageNum", ECondition.Like, "%" + StorageName + "%") .End<StorageEntity>() ; } List<StorageEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<StorageEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("仓库编号 ")); dt.Columns.Add(new DataColumn("仓库名 ")); dt.Columns.Add(new DataColumn("仓库类型 ")); dt.Columns.Add(new DataColumn("是否禁用")); dt.Columns.Add(new DataColumn("是否默认")); dt.Columns.Add(new DataColumn("备注")); dt.Columns.Add(new DataColumn("创建时间")); int count = 1; foreach (StorageEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.StorageNum; row[2] = t.StorageName; row[3] = EnumHelper.GetEnumDesc<EStorageType>(t.StorageType); row[4] = EnumHelper.GetEnumDesc<EBool>(t.IsForbid); row[5] = EnumHelper.GetEnumDesc<EBool>(t.IsDefault); row[6] = t.Remark; row[7] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("仓库管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("仓库管理", "仓库", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }