/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, ToolequipmentEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception ex)
{
throw;
}
}
public string ImportTools(string tooltype, string DepartmentId)
{
try
{
int error = 0;
string message = "请选择格式正确的文件再导入!";
string falseMessage = "";
int count = 0;
if (HttpContext.Request.Files.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));
Aspose.Cells.Cells cells = wb.Worksheets[0].Cells;
DataTable dt = cells.ExportDataTable(1, 0, cells.MaxDataRow, cells.MaxColumn + 1, true);
List <ToolequipmentEntity> toolequipmentList = new List <ToolequipmentEntity>();
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
DataTable userTable = new UserBLL().GetTable(user.OrganizeId);
#region 安全工器具导入
if (tooltype == "2")
{
foreach (DataRow row in dt.Rows)
{
if (row[0].ToString() == "序号")
{
continue;
}
else
{
ToolequipmentEntity toolequipment = new ToolequipmentEntity();
toolequipment.ToolType = tooltype;
if (tooltype == "2")
{
switch (row[1].ToString())
{
case "电气安全工器具":
toolequipment.EquipmentType = "1";
break;
case "机械、化学工器具":
toolequipment.EquipmentType = "2";
break;
}
}
else
{
toolequipment.EquipmentType = "0";
}
toolequipment.EquipmentValue = row[2].ToString();
toolequipment.EquipmentName = dataitemdetailBll.GetItemValue(toolequipment.EquipmentValue);
toolequipment.Specifications = row[3].ToString();
toolequipment.OutputDeptName = row[4].ToString();
string factorydate = row[5].ToString();
try
{
if (!string.IsNullOrEmpty(factorydate))
{
toolequipment.FactoryDate = DateTime.Parse(factorydate);
}
else
{
toolequipment.FactoryDate = null;
}
}
catch (Exception)
{
toolequipment.FactoryDate = null;
}
toolequipment.EquipmentNo = row[6].ToString();
string strcheckdate = row[7].ToString();
DateTime?checkdate;
try
{
if (!string.IsNullOrEmpty(strcheckdate))
{
checkdate = DateTime.Parse(strcheckdate);
}
else
{
checkdate = null;
}
}
catch (Exception)
{
checkdate = null;
}
string strnextcheckdate = row[8].ToString();
DateTime?nextcheckdate;
try
{
if (!string.IsNullOrEmpty(strnextcheckdate))
{
nextcheckdate = DateTime.Parse(strnextcheckdate);
}
else
{
nextcheckdate = null;;
}
}
catch (Exception)
{
nextcheckdate = null;;
}
toolequipment.CheckDate = checkdate;
toolequipment.NextCheckDate = nextcheckdate;
if (nextcheckdate != null && checkdate != null && nextcheckdate >= checkdate)
{
toolequipment.CheckDateCycle = nextcheckdate.ToDate().Subtract(checkdate.ToDate()).Days.ToString();
}
string checkUserName = row[9].ToString().Trim();
string strwhere = "realname ='" + checkUserName + "' ";
DataRow[] checkUser = userTable.Select(strwhere);
if (checkUser.Length > 0)
{
toolequipment.OperUser = checkUserName;
toolequipment.OperUserId = checkUser[0]["userid"].ToString();
}
DepartmentEntity department;
if (!string.IsNullOrEmpty(DepartmentId))
{
department = departmentBLL.GetEntity(DepartmentId);
}
else
{
department = departmentBLL.GetEntity(user.DeptId);
}
toolequipment.ControlDept = department.FullName;
toolequipment.ControlDeptCode = department.EnCode;
toolequipment.ControlDeptId = department.DepartmentId;
toolequipmentList.Add(toolequipment);
}
}
}
#endregion
#region 手工器具导入
else if (tooltype == "3")
{
foreach (DataRow row in dt.Rows)
{
if (row[0].ToString() == "序号")
{
continue;
}
else
{
ToolequipmentEntity toolequipment = new ToolequipmentEntity();
toolequipment.ToolType = tooltype;
toolequipment.EquipmentType = "0";
toolequipment.EquipmentValue = row[1].ToString();
toolequipment.EquipmentName = dataitemdetailBll.GetItemValue(toolequipment.EquipmentValue);
toolequipment.EquipmentNo = row[2].ToString();
toolequipment.Specifications = row[3].ToString();
toolequipment.Quantity = row[4].ToString();
toolequipment.Unit = row[5].ToString();
toolequipment.Depositary = row[6].ToString();
string createUserName = row[7].ToString().Trim();
string strwhere = "realname ='" + createUserName + "' ";
DataRow[] createUser = userTable.Select(strwhere);
if (createUser.Length > 0)
{
toolequipment.CreateUserName = createUserName;
toolequipment.CreateUserId = createUser[0]["userid"].ToString();
}
string createDate = row[8].ToString();
try
{
if (!string.IsNullOrEmpty(createDate))
{
toolequipment.CreateDate = DateTime.Parse(createDate);
}
else
{
toolequipment.CreateDate = DateTime.Now;
}
}
catch (Exception)
{
toolequipment.CreateDate = DateTime.Now;;
}
//部门班组
DepartmentEntity department;
if (!string.IsNullOrEmpty(DepartmentId))
{
department = departmentBLL.GetEntity(DepartmentId);
}
else
{
department = departmentBLL.GetEntity(user.DeptId);
}
toolequipment.BelongDept = department.FullName;
toolequipment.BelongDeptCode = department.EnCode;
toolequipment.BelongDeptId = department.DepartmentId;
toolequipmentList.Add(toolequipment);
}
}
}
#endregion
foreach (var toolequipment in toolequipmentList)
{
toolequipmentBll.SaveForm(Guid.NewGuid().ToString(), toolequipment);
count++;
}
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public object GetToolDetail([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
int pageSize = res.Contains("pagesize") ? int.Parse(dy.data.pagesize.ToString()) : 10; //每页条数
int pageIndex = res.Contains("pageindex") ? int.Parse(dy.data.pageindex.ToString()) : 1; //请求页码
string userId = dy.userid;
string keyValue = res.Contains("id") ? dy.data.id : "";
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator curUser = OperatorProvider.Provider.Current();
if (null == curUser)
{
return(new { code = -1, count = 0, info = "请求失败,请登录!" });
}
ToolequipmentEntity toolequipment = toolequipmentBll.GetEntity(keyValue);
object data = new object();
int records = -1;
if (toolequipment != null)
{
object obj = new
{
id = toolequipment.Id,
createuserid = toolequipment.CreateUserId,
createuserdeptcode = toolequipment.CreateUserDeptCode,
createuserorgcode = toolequipment.CreateUserOrgCode,
createdate = toolequipment.CreateDate,
createusername = toolequipment.CreateUserName,
modifydate = toolequipment.ModifyDate,
modifyuserid = toolequipment.ModifyUserId,
modifyusername = toolequipment.ModifyUserName,
equipmentvalue = toolequipment.EquipmentValue,
equipmentname = toolequipment.EquipmentName,
equipmenttype = toolequipment.EquipmentType,
equipmentno = toolequipment.EquipmentNo,
securitymanageruser = toolequipment.SecurityManagerUser,
securitymanageruserid = toolequipment.SecurityManagerUserId,
telephone = toolequipment.Telephone,
specifications = toolequipment.Specifications,
district = toolequipment.District,
districtid = toolequipment.DistrictId,
districtcode = toolequipment.DistrictCode,
depositary = toolequipment.Depositary,
checkdate = toolequipment.CheckDate,
nextcheckdate = toolequipment.NextCheckDate,
validitydate = toolequipment.ValidityDate,
operuser = toolequipment.OperUser,
operuserid = toolequipment.OperUserId,
ischeck = toolequipment.IsCheck,
outputdeptname = toolequipment.OutputDeptName,
factoryno = toolequipment.FactoryNo,
factorydate = toolequipment.FactoryDate,
state = toolequipment.State,
controluserid = toolequipment.ControlUserId,
controlusername = toolequipment.ControlUserName,
controldept = toolequipment.ControlDept,
controldeptid = toolequipment.ControlDeptId,
controldeptcode = toolequipment.ControlDeptCode,
checkdatecycle = toolequipment.CheckDateCycle,
acceptance = toolequipment.Acceptance,
tooltype = toolequipment.ToolType,
appraise = toolequipment.Appraise,
descriptionfileid = toolequipment.DescriptionFileId,
contractfileid = toolequipment.ContractFileId,
belongdept = toolequipment.BelongDept,
belongdeptid = toolequipment.BelongDeptId,
belongdeptcode = toolequipment.BelongDeptCode
};
List <FileInfoEntity> descriptionfile = fileInfoBLL.GetFileList(toolequipment.DescriptionFileId);
List <FileInfoEntity> contractfile = fileInfoBLL.GetFileList(toolequipment.ContractFileId);
string strurl = new DataItemDetailBLL().GetItemValue("imgUrl");
List <object> objects = new List <object>();
foreach (FileInfoEntity itemEntity in descriptionfile)
{
objects.Add(new
{
fileid = itemEntity.FileId,
filepath = strurl + itemEntity.FilePath.Replace("~", ""),
filename = itemEntity.FileName,
recid = itemEntity.RecId
});
}
foreach (FileInfoEntity itemEntity in contractfile)
{
objects.Add(new
{
fileid = itemEntity.FileId,
filepath = strurl + itemEntity.FilePath.Replace("~", ""),
filename = itemEntity.FileName,
recid = itemEntity.RecId
});
}
DataTable recordlist = GetToolRecordList(toolequipment.Id, pageIndex, pageSize, out records);
List <object> recordfiles = new List <object>();
if (recordlist.Rows.Count > 0)
{
foreach (DataRow recordEntity in recordlist.Rows)
{
List <FileInfoEntity> fileinfos = fileInfoBLL.GetFileList(recordEntity["Id"].ToString());
if (fileinfos.Count > 0)
{
foreach (var fileInfoEntity in fileinfos)
{
recordfiles.Add(new
{
fileid = fileInfoEntity.FileId,
filepath = strurl + fileInfoEntity.FilePath.Replace("~", ""),
filename = fileInfoEntity.FileName,
recid = fileInfoEntity.RecId
});
}
}
}
}
//检查记录信息与附件信息
object toolrecord = new
{
recordlist = recordlist,
recordfile = recordfiles
};
data = new
{
tooldetail = obj,
toolrecord = toolrecord,
toolfile = objects,
};
}
//var recordentity = toolrecordbll.GetList("").Where(p => p.ToolEquipmentId == keyValue).ToList();
//List<object> toolrecord = new List<object>();
//foreach (var entity in recordentity)
//{
// toolrecord.Add(new
// {
// id = entity.Id,
// createuserid = entity.CreateUserId,
// createuserdeptcode = entity.CreateUserDeptCode,
// createuserorgcode = entity.CreateUserOrgCode,
// createdate = entity.CreateDate,
// createusername = entity.CreateUserName,
// modifydate = entity.ModifyDate,
// modifyuserid = entity.ModifyUserId,
// modifyusername = entity.ModifyUserName,
// nextcheckdate = entity.NextCheckDate,
// equipmentname = entity.EquipmentName,
// equipmentno = entity.EquipmentNo,
// operuserid = entity.OperUserId,
// voltagelevel = entity.VoltageLevel,
// operuser = entity.OperUser,
// appraise = entity.Appraise,
// trialvoltage = entity.TrialVoltage,
// checkdate = entity.CheckDate,
// toolequipmentid = entity.ToolEquipmentId,
// specification = entity.Specification,
// checkproject = entity.CheckProject
// });
//}
return(new { Code = 0, Count = records, Info = "获取数据成功", data = data });
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
public ActionResult SaveForm(string keyValue, ToolequipmentEntity entity)
{
toolequipmentBll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
