/// <summary> /// to get district names /// </summary> /// <returns></returns> private void GetDistrictName() { DistrictBLL BLLobj = new DistrictBLL(); ddlDistrictName.DataSource = BLLobj.GetDistrict(); ddlDistrictName.DataTextField = "DISTRICTNAME"; ddlDistrictName.DataValueField = "DISTRICTID"; ddlDistrictName.DataBind(); //DDLSearchDistrictName.DataSource = BLLobj.GetDistrict(); //DDLSearchDistrictName.DataTextField = "DISTRICTNAME"; //DDLSearchDistrictName.DataValueField = "DISTRICTID"; //DDLSearchDistrictName.DataBind(); }
public string ImportSuppliesData() { int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { count = 0; HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(); wb.Open(Server.MapPath("~/Resource/temp/" + fileName), file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx") ? Aspose.Cells.FileFormatType.Excel2007Xlsx : Aspose.Cells.FileFormatType.Excel2003); Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); //判断表头是否正确,以免使用错误模板 var sheet = wb.Worksheets[0]; if (sheet.Cells[2, 0].StringValue != "物资类型" || sheet.Cells[2, 1].StringValue != "物资名称" || sheet.Cells[2, 2].StringValue != "规格型号" || sheet.Cells[2, 3].StringValue != "数量" || sheet.Cells[2, 4].StringValue != "单位" || sheet.Cells[2, 5].StringValue != "存放区域" || sheet.Cells[2, 6].StringValue != "存放地点" || sheet.Cells[2, 7].StringValue != "主要功能") { return(message); } //List<SuppliesEntity> slist = new List<SuppliesEntity>(); for (int i = 3; i <= sheet.Cells.MaxDataRow; i++) { count++; SuppliesEntity entity = new SuppliesEntity(); if (string.IsNullOrWhiteSpace(sheet.Cells[i, 1].StringValue)) { falseMessage += "</br>" + "第" + (i + 1) + "行物资名称不能为空,未能导入."; error++; continue; } if (string.IsNullOrWhiteSpace(sheet.Cells[i, 3].StringValue)) { falseMessage += "</br>" + "第" + (i + 1) + "行数量不能为空,未能导入."; error++; continue; } entity.SUPPLIESTYPENAME = sheet.Cells[i, 0].StringValue; var item = new DataItemDetailBLL().GetDataItemListByItemCode("'MAE_SUPPLIESTYPE'").Where(x => x.ItemName == entity.SUPPLIESTYPENAME).ToList().FirstOrDefault(); if (item != null) { entity.SUPPLIESTYPE = item.ItemValue; } entity.SUPPLIESNAME = sheet.Cells[i, 1].StringValue; entity.Models = sheet.Cells[i, 2].StringValue; entity.NUM = Convert.ToInt32(sheet.Cells[i, 3].StringValue); entity.SUPPLIESUNTILNAME = sheet.Cells[i, 4].StringValue; var itemUnit = new DataItemDetailBLL().GetDataItemListByItemCode("'MAE_SUPPLIESUNTIL'").Where(x => x.ItemName == entity.SUPPLIESUNTILNAME).ToList().FirstOrDefault(); if (itemUnit != null) { entity.SUPPLIESUNTIL = itemUnit.ItemValue; } if (!string.IsNullOrWhiteSpace(sheet.Cells[i, 5].StringValue)) { DistrictEntity district = districtbll.GetDistrict(user.OrganizeId, sheet.Cells[i, 5].StringValue); if (district == null) { falseMessage += "</br>" + "第" + (i + 1) + "行区域不是系统内区域,未能导入."; error++; continue; } else { entity.WorkAreaCode = district.DistrictCode; entity.WorkAreaName = district.DistrictName; } } entity.STORAGEPLACE = sheet.Cells[i, 6].StringValue; entity.MAINFUN = sheet.Cells[i, 7].StringValue; entity.CREATEDATE = DateTime.Now; entity.DEPARTID = user.DeptId; entity.DEPARTNAME = user.DeptName; entity.USERID = user.UserId; entity.USERNAME = user.UserName; entity.SUPPLIESCODE = suppliesbll.GetMaxCode(); //entity.Create(); suppliesbll.SaveForm(entity.ID, entity); var entityInorOut = new InoroutrecordEntity { USERID = entity.USERID, USERNAME = entity.USERNAME, DEPARTID = entity.DEPARTID, DEPARTNAME = entity.DEPARTNAME, INOROUTTIME = DateTime.Now, SUPPLIESCODE = entity.SUPPLIESCODE, SUPPLIESTYPE = entity.SUPPLIESTYPE, SUPPLIESTYPENAME = entity.SUPPLIESTYPENAME, SUPPLIESNAME = entity.SUPPLIESNAME, SUPPLIESUNTIL = entity.SUPPLIESUNTIL, SUPPLIESUNTILNAME = entity.SUPPLIESUNTILNAME, NUM = entity.NUM, STORAGEPLACE = entity.STORAGEPLACE, MOBILE = entity.MOBILE, SUPPLIESID = entity.ID, STATUS = 0 }; var inoroutrecordbll = new InoroutrecordBLL(); inoroutrecordbll.SaveForm("", entityInorOut); //slist.Add(entity); } message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条。"; if (error > 0) { message += "</br>" + falseMessage; } } return(message); }
public string ImportTrainLib() { try { if (OperatorProvider.Provider.Current().IsSystem) { return("超级管理员无此操作权限"); } string orgId = OperatorProvider.Provider.Current().OrganizeId; int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(); wb.Open(Server.MapPath("~/Resource/temp/" + fileName), file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx")?Aspose.Cells.FileFormatType.Excel2007Xlsx:Aspose.Cells.FileFormatType.Excel2003); var sheet = wb.Worksheets[0]; if (sheet.Cells[1, 1].StringValue != "工作任务" || sheet.Cells[1, 2].StringValue != "风险等级" || sheet.Cells[1, 3].StringValue != "作业类型" || sheet.Cells[1, 4].StringValue != "作业岗位" || sheet.Cells[1, 5].StringValue != "任务描述" || sheet.Cells[1, 6].StringValue != "资源准备" || sheet.Cells[1, 7].StringValue != "作业区域" || sheet.Cells[1, 8].StringValue != "工序" || sheet.Cells[1, 9].StringValue != "潜在危险" || sheet.Cells[1, 10].StringValue != "防范措施") { return(message); } var RiskLibList = new List <RisktrainlibEntity>(); var RiskDetailList = new List <RisktrainlibdetailEntity>(); var date = DateTime.Now; for (int i = 2; i <= sheet.Cells.MaxDataRow; i++) { var entity = new RisktrainlibEntity(); entity.Create(); entity.WorkTask = sheet.Cells[i, 1].StringValue; entity.RiskLevel = sheet.Cells[i, 2].StringValue; switch (entity.RiskLevel) { case "重大风险": entity.RiskLevelVal = "1"; break; case "较大风险": entity.RiskLevelVal = "2"; break; case "一般风险": entity.RiskLevelVal = "3"; break; case "低风险": entity.RiskLevelVal = "4"; break; default: break; } entity.WorkType = sheet.Cells[i, 3].StringValue; entity.WorkPost = sheet.Cells[i, 4].StringValue; entity.WorkDes = sheet.Cells[i, 5].StringValue; entity.Resources = sheet.Cells[i, 6].StringValue; entity.WorkArea = sheet.Cells[i, 7].StringValue; entity.DataSources = "2"; if (string.IsNullOrEmpty(sheet.Cells[i, 1].StringValue)) { entity.ID = RiskLibList[i - 1 - 2].ID; } RiskLibList.Add(entity); } for (int i = 2; i <= sheet.Cells.MaxDataRow; i++) { var dentity = new RisktrainlibdetailEntity(); if (sheet.Cells[i, 8].StringValue.Length > 1000) { falseMessage += "</br>" + "第" + (i + 1) + "行工序字符长度超长,未能导入."; error++; continue; } if (sheet.Cells[i, 9].StringValue.Length > 1000) { falseMessage += "</br>" + "第" + (i + 1) + "行存在风险字符长度超长,未能导入."; error++; continue; } if (sheet.Cells[i, 10].StringValue.Length > 1000) { falseMessage += "</br>" + "第" + (i + 1) + "行管理措施字符长度超长,未能导入."; error++; continue; } dentity.Process = sheet.Cells[i, 8].StringValue; dentity.AtRisk = sheet.Cells[i, 9].StringValue; dentity.Controls = sheet.Cells[i, 10].StringValue; dentity.Create(); dentity.WorkId = RiskLibList[i - 2].ID; RiskDetailList.Add(dentity); } RiskLibList = RiskLibList.Where(x => x.WorkTask != "").ToList(); for (int i = 0; i < RiskLibList.Count; i++) { if (!string.IsNullOrWhiteSpace(RiskLibList[i].WorkType)) { var data = new DataItemDetailBLL().GetDataItemListByItemCode("'StatisticsType'"); string worktype = string.Empty; var list = RiskLibList[i].WorkType.Split(','); for (int k = 0; k < list.Length; k++) { var entity = data.Where(x => x.ItemName == list[k].Trim()).FirstOrDefault(); if (entity != null) { if (string.IsNullOrWhiteSpace(worktype)) { RiskLibList[i].WorkTypeCode += entity.ItemValue + ","; worktype += entity.ItemName + ","; } else { if (!worktype.Contains(entity.ItemName)) { RiskLibList[i].WorkTypeCode += entity.ItemValue + ","; worktype += entity.ItemName + ","; } } } //if (entity != null) //{ // RiskLibList[i].WorkTypeCode += entity.ItemValue + ","; //} //else //{ // RiskLibList[i].WorkType.Replace(list[k], ""); //} } if (!string.IsNullOrWhiteSpace(RiskLibList[i].WorkTypeCode)) { RiskLibList[i].WorkTypeCode = RiskLibList[i].WorkTypeCode.Substring(0, RiskLibList[i].WorkTypeCode.Length - 1); RiskLibList[i].WorkType = worktype.Substring(0, worktype.Length - 1); } } if (string.IsNullOrWhiteSpace(RiskLibList[i].WorkArea)) { //falseMessage += "</br>" + "第" + (i+1) + "行区域为空,未能导入."; //error++; //continue; } else { DistrictEntity disEntity = districtBLL.GetDistrict(orgId, RiskLibList[i].WorkArea); if (disEntity == null) { //电厂没有该区域则不赋值 RiskLibList[i].WorkArea = ""; } else { RiskLibList[i].WorkAreaId = disEntity.DistrictID; } } } risktrainlibbll.InsertImportData(RiskLibList, RiskDetailList); //risktrainlibbll.InsertRiskTrainLib(RiskLibList); //risktrainlibdetailbll.InsertRiskTrainDetailLib(RiskDetailList); count = RiskDetailList.Count; message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; //DataTable dt = cells.ExportDataTable(0, 0, cells.MaxDataRow, cells.MaxColumn + 1, true); } return(message); } catch (Exception ex) { throw new Exception(ex.Message); } //return null; }