public ActionResult SaveFormY(SafetyworksuperviseEntity entity, [System.Web.Http.FromBody] string dataJson)
{
if (dataJson.Length > 0)
{
List <SafetyworksuperviseEntity> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SafetyworksuperviseEntity> >(dataJson);
int s = 0;
DateTime dd = DateTime.Now;
foreach (SafetyworksuperviseEntity data in list)
{
s = s + 1;
data.CreateDate = dd.AddSeconds(s);
safetyworksupervisebll.SaveForm("", data);
}
}
return(Success("操作成功。"));
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, SafetyworksuperviseEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
if (entity.FlowState == "1")
{
UserBLL userbll = new UserBLL();
UserEntity userEntity = userbll.GetEntity(entity.DutyPersonId);//获取责任人用户信息
JPushApi.PushMessage(userEntity.Account, entity.DutyPerson, "GZDB001", "例行安全工作", entity.Id);
}
}
catch (Exception)
{
throw;
}
}
public string ImportData()
{
try
{
int error = 0;
int sussceed = 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);
}
var user = ERCHTMS.Code.OperatorProvider.Provider.Current();
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
string filePath = Server.MapPath("~/Resource/temp/" + fileName);
file.SaveAs(filePath);
DataTable dt = ExcelHelper.ExcelImport(filePath);
DepartmentBLL deptBll = new DepartmentBLL();
UserBLL userbll = new UserBLL();
string supervisedate = string.Empty;
string worktask = string.Empty; string flowstate = "0";//默认下发
string dutydeptname = string.Empty, dutyperson = string.Empty, superviseperson = string.Empty;
string supervisedeptname = string.Empty, finishdate = string.Empty, remark = string.Empty;
string dutydeptid = string.Empty, dutydeptcode = string.Empty, dutypersonid = string.Empty;
string supervisepersonid = string.Empty, supervisedeptid = string.Empty, supervisedeptcode = string.Empty;
int num = 0;
List <SafetyworksuperviseEntity> list = new List <SafetyworksuperviseEntity>();
for (int i = 0; i < dt.Rows.Count; i++)
{
object[] vals = dt.Rows[i].ItemArray;
if (IsEndRow(vals) == true)
{
break;
}
if (i == 0)
{
supervisedate = vals[1].ToString();//督办时间
if (string.IsNullOrEmpty(supervisedate))
{
falseMessage += "第" + (i + 1) + "行:督办时间不能为空！</br>";
error++;
continue;
}
}
else if (i == 1)
{
continue;//第二行是列名,跳过
}
else
{
num++;
if (!string.IsNullOrEmpty(vals[0].ToString()))
{
worktask = vals[0].ToString();//重点工作内容
}
//else {
// falseMessage += "第" + (i + 1) + "行:重点工作内容不能为空！</br>";
// error++;
// continue;
//}
dutydeptname = vals[1].ToString();//责任单位名称
if (string.IsNullOrEmpty(dutydeptname))
{
falseMessage += "第" + (i + 2) + "行:责任单位名称不能为空！</br>";
error++;
continue;
}
var p1 = string.Empty;
var p2 = string.Empty;
bool isSkip = false;
string dname = string.Empty;
//验证所填部门是否存在
var array = dutydeptname.Split('/');
for (int j = 0; j < array.Length; j++)
{
if (j == 0)
{
var entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "厂级" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "部门" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "承包商" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
falseMessage += "第" + (i + 2) + "行:责任部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
dutydeptid = entity.DepartmentId;
dutydeptcode = entity.EnCode;
dutydeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else
{
dutydeptid = entity.DepartmentId;
dutydeptcode = entity.EnCode;
dutydeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else
{
dutydeptid = entity.DepartmentId;
dutydeptcode = entity.EnCode;
dutydeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else if (j == 1)
{
var entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && (x.Nature == "专业" || x.Nature == "承包商" || x.Nature == "分包商") && x.FullName == array[j].ToString() && x.ParentId == p1).FirstOrDefault();
if (entity1 == null)
{
entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "班组" && x.FullName == array[j].ToString() && x.ParentId == p1).FirstOrDefault();
if (entity1 == null)
{
falseMessage += "第" + (i + 2) + "行:责任部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
dutydeptid = entity1.DepartmentId;
dutydeptcode = entity1.EnCode;
dutydeptname = entity1.FullName;
p2 = entity1.DepartmentId;
}
}
else
{
dutydeptid = entity1.DepartmentId;
dutydeptcode = entity1.EnCode;
dutydeptname = entity1.FullName;
p2 = entity1.DepartmentId;
if (entity1.Nature == "承包商")
{
if (!string.IsNullOrEmpty(p1))
{
var d = departmentBLL.GetEntity(p1);
if (d != null)
{
dname = d.FullName;
}
}
}
}
}
else
{
var entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && (x.Nature == "班组" || x.Nature == "承包商" || x.Nature == "分包商") && x.FullName == array[j].ToString() && x.ParentId == p2).FirstOrDefault();
if (entity1 == null)
{
falseMessage += "第" + (i + 2) + "行:责任部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
dutydeptid = entity1.DepartmentId;
dutydeptcode = entity1.EnCode;
dutydeptname = entity1.FullName;
if (entity1.Nature == "承包商")
{
if (!string.IsNullOrEmpty(p2))
{
var d = departmentBLL.GetEntity(p2);
if (d != null)
{
dname = d.FullName;
}
}
}
}
}
}
if (isSkip)
{
continue;
}
//dutydeptcode = deptBll.GetDeptCode(dutydeptname, user.OrganizeId);//获取责任单位code
//if (string.IsNullOrEmpty(dutydeptcode))
//{
// falseMessage += "第" + (i + 1) + "行:责任部门与系统的部门信息不匹配！</br>";
// error++;
// continue;
//}
//else {
// dutydeptid = deptBll.GetEntityByCode(dutydeptcode).DepartmentId;//获取责任单位id
//}
dutyperson = vals[2].ToString();//责任人
if (string.IsNullOrEmpty(dutyperson))
{
falseMessage += "第" + (i + 2) + "行:责任人不能为空！</br>";
error++;
continue;
}
UserInfoEntity userEntity = userbll.GetUserInfoByName(dutydeptname, dutyperson);
if (!string.IsNullOrEmpty(dname))
{
userEntity = userbll.GetUserInfoByName(dname, dutyperson);
}
if (userEntity == null)
{
falseMessage += "第" + (i + 2) + "行:责任人和责任部门信息不匹配！</br>";
error++;
continue;
}
else
{
dutypersonid = userEntity.UserId;
}
supervisedeptname = vals[4].ToString();//督办部门
if (string.IsNullOrEmpty(supervisedeptname))
{
falseMessage += "第" + (i + 2) + "行:督办部门不能为空！</br>";
error++;
continue;
}
p1 = string.Empty;
p2 = string.Empty;
isSkip = false;
dname = string.Empty;
//验证所填部门是否存在
array = supervisedeptname.Split('/');
for (int j = 0; j < array.Length; j++)
{
if (j == 0)
{
var entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "厂级" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "部门" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
entity = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "承包商" && x.FullName == array[j].ToString()).FirstOrDefault();
if (entity == null)
{
falseMessage += "第" + (i + 2) + "行:督办部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
supervisedeptid = entity.DepartmentId;
supervisedeptcode = entity.EnCode;
supervisedeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else
{
supervisedeptid = entity.DepartmentId;
supervisedeptcode = entity.EnCode;
supervisedeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else
{
supervisedeptid = entity.DepartmentId;
supervisedeptcode = entity.EnCode;
supervisedeptname = entity.FullName;
p1 = entity.DepartmentId;
}
}
else if (j == 1)
{
var entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && (x.Nature == "专业" || x.Nature == "承包商" || x.Nature == "分包商") && x.FullName == array[j].ToString() && x.ParentId == p1).FirstOrDefault();
if (entity1 == null)
{
entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && x.Nature == "班组" && x.FullName == array[j].ToString() && x.ParentId == p1).FirstOrDefault();
if (entity1 == null)
{
falseMessage += "第" + (i + 2) + "行:督办部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
supervisedeptid = entity1.DepartmentId;
supervisedeptcode = entity1.EnCode;
supervisedeptname = entity1.FullName;
p2 = entity1.DepartmentId;
}
}
else
{
supervisedeptid = entity1.DepartmentId;
supervisedeptcode = entity1.EnCode;
supervisedeptname = entity1.FullName;
p2 = entity1.DepartmentId;
if (entity1.Nature == "承包商")
{
if (!string.IsNullOrEmpty(p1))
{
var d = departmentBLL.GetEntity(p1);
if (d != null)
{
dname = d.FullName;
}
}
}
}
}
else
{
var entity1 = departmentBLL.GetList().Where(x => x.OrganizeId == user.OrganizeId && (x.Nature == "班组" || x.Nature == "承包商" || x.Nature == "分包商") && x.FullName == array[j].ToString() && x.ParentId == p2).FirstOrDefault();
if (entity1 == null)
{
falseMessage += "第" + (i + 2) + "行:督办部门与系统的部门信息不匹配！</br>";
error++;
isSkip = true;
break;
}
else
{
supervisedeptid = entity1.DepartmentId;
supervisedeptcode = entity1.EnCode;
supervisedeptname = entity1.FullName;
if (entity1.Nature == "承包商")
{
if (!string.IsNullOrEmpty(p2))
{
var d = departmentBLL.GetEntity(p2);
if (d != null)
{
dname = d.FullName;
}
}
}
}
}
}
if (isSkip)
{
continue;
}
//supervisedeptcode = deptBll.GetDeptCode(supervisedeptname, user.OrganizeId);//获取督办部门code
//if (string.IsNullOrEmpty(supervisedeptcode))
//{
// falseMessage += "第" + (i + 1) + "行:督办部门与系统的部门信息不匹配！</br>";
// error++;
// continue;
//}
//else
//{
// supervisedeptid = deptBll.GetEntityByCode(supervisedeptcode).DepartmentId;//获取责任单位id
//}
superviseperson = vals[3].ToString();//督办人
if (string.IsNullOrEmpty(superviseperson))
{
falseMessage += "第" + (i + 2) + "行:督办人不能为空！</br>";
error++;
continue;
}
userEntity = userbll.GetUserInfoByName(supervisedeptname, superviseperson);
if (!string.IsNullOrEmpty(dname))
{
userEntity = userbll.GetUserInfoByName(dname, superviseperson);
}
if (userEntity == null)
{
falseMessage += "第" + (i + 2) + "行:督办人和督办部门信息不匹配！</br>";
error++;
continue;
}
else
{
supervisepersonid = userEntity.UserId;
}
finishdate = vals[5].ToString();//完成时间
if (string.IsNullOrEmpty(finishdate))
{
falseMessage += "第" + (i + 2) + "行:完成时间不能为空！</br>";
error++;
continue;
}
remark = vals[6].ToString();//备注
SafetyworksuperviseEntity entityWork = new SafetyworksuperviseEntity()
{
Id = Guid.NewGuid().ToString(),
SuperviseDate = string.IsNullOrEmpty(supervisedate) ? DateTime.Now : Convert.ToDateTime(supervisedate + "-01"),
WorkTask = worktask,
DutyDeptName = dutydeptname,
DutyDeptId = dutydeptid,
DutyDeptCode = dutydeptcode,
DutyPerson = dutyperson,
DutyPersonId = dutypersonid,
SupervisePerson = superviseperson,
SupervisePersonId = supervisepersonid,
SuperviseDeptName = supervisedeptname,
SuperviseDeptId = supervisedeptid,
SuperviseDeptCode = supervisedeptcode,
FinishDate = Convert.ToDateTime(finishdate),
FlowState = flowstate,
Remark = remark,
};
list.Add(entityWork);
}
}
//count = dt.Rows.Count;
//message = "共有" + num + "条记录,成功导入" + sussceed + "条，失败" + error + "条";
message = "共有" + num + "条记录,失败" + error + "条,请修改后重新导入";
if (error > 0)
{
message += "，错误信息如下：</br>" + falseMessage;
}
else
{
try
{
int s = 0;
DateTime dd = DateTime.Now;
foreach (SafetyworksuperviseEntity item in list)
{
s = s + 1;
item.CreateDate = dd.AddSeconds(s);
safetyworksupervisebll.SaveForm("", item);
sussceed++;
}
message = "共有" + num + "条记录,成功导入" + sussceed + "条";
}
catch (Exception ex)
{
message = "导入失败：" + ex.Message;
}
}
//删除临时文件
System.IO.File.Delete(filePath);
}
return(message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult SaveForm(string keyValue, SafetyworksuperviseEntity entity)
{
safetyworksupervisebll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
