/// <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;
}
