/// <summary>
/// 查看巡查信息
/// </summary>
/// <param name="taskNumber">任务编号</param>
/// <param name="employeeName">人员名字</param>
/// <param name="time">巡查时间</param>
/// <returns></returns>
public InspectInfo CheckInspectInfo(string taskNumber, string employeeName, DateTime time)
{
var inspectionService = new InspectionService();
var inspectionExceptionService = new InspectionExceptionService();
var exceptionService = new ExceptionTypeService();
task task = new TaskService().FindByTaskNumber(taskNumber);
var checkInspectInfo = new InspectInfo();
checkInspectInfo.InspectDetail = new List<InspectDetail>();
checkInspectInfo.TaskNumber = taskNumber;
checkInspectInfo.EmployeeName = employeeName;
if (task != null)
{
foreach (
inspection inspectionItem in
inspectionService.FindByTaskId(task.Id).OrderByDescending(m => m.Time).Where(
m => m.employee.Name.Equals(employeeName)))
{
if (!time.Date.Equals(inspectionItem.Time.Date)) continue;
List<inspection_exception> exceptionList =
inspectionExceptionService.FindByInspectionId(inspectionItem.Id);
if (exceptionList.Count > 0)
foreach (var exceptionItem in inspectionExceptionService.GetPigstyInfoNums(inspectionItem))
{
checkInspectInfo.InspectDetail.Add(new InspectDetail
{
PigHouse =
inspectionItem.pig_house.pig_house_type.Name
+ inspectionItem.pig_house.Number,
Pigsty = exceptionItem.Value,
DetailTime = inspectionItem.Time,
InspectionException =
exceptionService.Find(exceptionItem.Key).Name
});
}
else
checkInspectInfo.InspectDetail.Add(new InspectDetail
{
PigHouse =
inspectionItem.pig_house.pig_house_type.Name
+ inspectionItem.pig_house.Number,
Pigsty = "",
DetailTime = inspectionItem.Time,
InspectionException = "正常"
});
}
return checkInspectInfo;
}
return null;
}
/// <summary>
/// 根据类型id查找关联它的表是否为0
/// </summary>
/// <param name="typeid">类型id</param>
/// <param name="typename">类型名字</param>
/// <returns></returns>
public string GetRelationtById(long typeid, string typename)
{
var cureTypeService = new CureTypeService();
var medicineService = new MedicineService();
var unitService = new UnitService();
var fodderTypeService = new FodderTypeService();
var excetionTypeService = new ExceptionTypeService();
var pigTypeService = new PigTypeService();
var pigHouseTypeService = new PigHouseTypeService();
var taskStatusTypeService = new TaskStatusTypeService();
var taskTypeService = new TaskTypeService();
var roleTypeService = new RoleTypeService();
var preventionTypeService = new PreventionTypeService();
var roleAuthorityService = new RoleAuthorityService();
var customerService = new CustomerService();
if (typeid == 0)
{
return "不存在于数据库,可以删除";
}
try
{
if (typename == "治疗")
{
cureTypeService.Delete(cureTypeService.Find(typeid));
}
if (typename == "单位")
{
unitService.Delete(unitService.Find(typeid));
}
if (typename == "药物")
{
medicineService.Delete(medicineService.Find(typeid));
}
if (typename == "异常")
{
excetionTypeService.Delete(excetionTypeService.Find(typeid));
}
if (typename == "饲料")
{
fodderTypeService.Delete(fodderTypeService.Find(typeid));
}
if (typename == "生猪")
{
if (pigTypeService.Find(typeid).Name == "母猪" || pigTypeService.Find(typeid).Name == "公猪")
{
return "不可删除";
}
pigTypeService.Delete(pigTypeService.Find(typeid));
}
if (typename == "防疫")
{
preventionTypeService.Delete(preventionTypeService.Find(typeid));
}
if (typename == "猪舍")
{
pigHouseTypeService.Delete(pigHouseTypeService.Find(typeid));
}
if (typename == "任务状态")
{
if (taskStatusTypeService.Find(typeid).Name == "未完成" ||
taskStatusTypeService.Find(typeid).Name == "已完成" ||
taskStatusTypeService.Find(typeid).Name == "正在进行")
{
return "不可删除";
}
taskStatusTypeService.Delete(taskStatusTypeService.Find(typeid));
}
if (typename == "任务类型")
{
if (taskTypeService.Find(typeid).Name == "喂饲" || taskTypeService.Find(typeid).Name == "防疫" ||
taskTypeService.Find(typeid).Name == "巡查" || taskTypeService.Find(typeid).Name == "治疗" ||
taskTypeService.Find(typeid).Name == "销售" || taskTypeService.Find(typeid).Name == "转栏" ||
taskTypeService.Find(typeid).Name == "添加生猪")
{
return "不可删除";
}
taskTypeService.Delete(taskTypeService.Find(typeid));
}
if (typename == "角色")
{
foreach (role_authority c in roleAuthorityService.FindByRoleTypeId(typeid))
roleAuthorityService.Delete(roleAuthorityService.Find(c.Id));
roleTypeService.Delete(roleTypeService.Find(typeid));
}
if (typename == "客户名称")
{
customerService.Delete(customerService.Find(typeid));
}
}
catch (Exception)
{
return "不可删除";
}
return "";
}
public void ExceptionTypeSaveChanges(BasicInfoModel model)
{
var exceptionTypeService = new ExceptionTypeService();
List<exception_type> exceptionTypes = exceptionTypeService.FindAll();
foreach (exception_type exceptionType in exceptionTypes)
{
int idFlag = 0;
int nameFlag = 0;
string newname = "";
foreach (NameModel name in model.Names)
{
if (exceptionType.Id == name.Id)
{
idFlag = 1;
if (exceptionType.Name.Equals(name.Name))
{
nameFlag = 1;
}
else
{
newname = name.Name;
}
}
}
//若存在此Id,但是name变化了的，则需要修改数据库
if (idFlag == 1)
{
if (nameFlag == 0)
{
if (newname == "")
{
throw new Exception();
}
exception_type modifyCure = exceptionTypeService.Find(exceptionType.Id);
modifyCure.Name = newname;
exceptionTypeService.Update(modifyCure);
}
}
}
//如果model里的Id为0，说明是新建的类型
foreach (NameModel name in model.Names)
{
if (name.Id == 0 && exceptionTypeService.FindByName(name.Name).Count == 0)
{
var newExcpetionType = new exception_type {Name = name.Name};
exceptionTypeService.Insert(newExcpetionType);
}
}
}