/// <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> /// 巡查异常下拉列表 /// </summary> /// <returns></returns> public IEnumerable<SelectListItem> GetExceptionTypeList() { var exceptionService = new ExceptionTypeService(); IEnumerable<SelectListItem> pigTypeList = exceptionService.FindAll().Select(exceptionItem => new SelectListItem { Text = exceptionItem.Name, Value = exceptionItem.Id + string.Empty, }).OrderBy(m => m.Text); return pigTypeList; }
//判断类型是否重复 public bool JudgeNameByType(string name, 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 customerService = new CustomerService(); if (typename == "治疗") { if (cureTypeService.FindByName(name) == null) return true; } if (typename == "单位") { if (unitService.FindByName(name) == null) return true; } if (typename == "药物") { if (medicineService.FindByName(name) == null) return true; } if (typename == "异常") { if (excetionTypeService.FindByName(name).Count == 0) return true; } if (typename == "饲料") { if (fodderTypeService.FindByName(name) == null) return true; } if (typename == "生猪") { if (pigTypeService.FindByName(name) == null) return true; } if (typename == "防疫") { if (preventionTypeService.FindByName(name) == null) return true; } if (typename == "猪舍") { if (pigHouseTypeService.FindByName(name) == null) return true; } if (typename == "任务状态") { if (taskStatusTypeService.FindByName(name) == null) return true; } if (typename == "任务类型") { if (taskTypeService.FindByName(name) == null) return true; } if (typename == "角色") { if (roleTypeService.FindByName(name) == null) return true; } if (typename == "客户名称") { if (customerService.FindByName(name) == null) return true; } return false; }
/// <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 BasicInfoModel ReadBasicInfo(string type) { var basicInfoModel = new BasicInfoModel {Type = type}; var names = new List<NameModel>(); basicInfoModel.Names = names; if (type == "治疗") { List<cure_type> cureTypes = new CureTypeService().FindAll(); foreach (cure_type cureType in cureTypes) { var nameModel = new NameModel {Name = cureType.Name, Id = cureType.Id}; names.Add(nameModel); } } else if (type == "药物") { List<medicine> medicineTypes = new MedicineService().FindAll(); foreach (medicine medicineType in medicineTypes) { var nameModel = new NameModel {Name = medicineType.Name, Id = medicineType.Id}; names.Add(nameModel); } } else if (type == "单位") { List<unit> unitTypes = new UnitService().FindAll(); foreach (unit unitType in unitTypes) { var nameModel = new NameModel {Name = unitType.Name, Id = unitType.Id}; names.Add(nameModel); } } else if (type == "异常") { List<exception_type> exceptionTypes = new ExceptionTypeService().FindAll(); foreach (exception_type exceptionType in exceptionTypes) { var nameModel = new NameModel {Name = exceptionType.Name, Id = exceptionType.Id}; names.Add(nameModel); } } else if (type == "饲料") { List<fodder_type> fodderTypes = new FodderTypeService().FindAll(); foreach (fodder_type fodderType in fodderTypes) { var nameModel = new NameModel {Name = fodderType.Name, Id = fodderType.Id}; names.Add(nameModel); } } else if (type == "生猪") { List<pig_type> pigTypes = new PigTypeService().FindAll(); foreach (pig_type pigType in pigTypes) { var nameModel = new NameModel {Name = pigType.Name, Id = pigType.Id}; names.Add(nameModel); } } else if (type == "防疫") { List<prevention_type> preventionTypes = new PreventionTypeService().FindAll(); foreach (prevention_type preventionType in preventionTypes) { var nameModel = new NameModel { Name = preventionType.Name, Id = preventionType.Id, MedicineId = preventionType.MedicineId, Quality = Convert.ToInt32(preventionType.Quality), UnitId = preventionType.UnitId }; names.Add(nameModel); } } else if (type == "猪舍") { List<pig_house_type> pigHouseTypes = new PigHouseTypeService().FindAll(); foreach (pig_house_type pigHouseType in pigHouseTypes) { var nameModel = new NameModel {Name = pigHouseType.Name, Id = pigHouseType.Id}; names.Add(nameModel); } } else if (type == "任务状态") { List<task_status_type> taskStatusTypes = new TaskStatusTypeService().FindAll(); foreach (task_status_type taskStatusType in taskStatusTypes) { var nameModel = new NameModel {Name = taskStatusType.Name, Id = taskStatusType.Id}; names.Add(nameModel); } } else if (type == "任务类型") { List<task_type> taskTypes = new TaskTypeService().FindAll(); foreach (task_type taskType in taskTypes) { var nameModel = new NameModel {Name = taskType.Name, Id = taskType.Id}; names.Add(nameModel); } } else if (type == "角色") { List<role_type> roleTypes = new RoleTypeService().FindAll(); foreach (role_type roleType in roleTypes) { var nameModel = new NameModel {Name = roleType.Name, Id = roleType.Id}; names.Add(nameModel); } } else if (type == "客户名称") { List<customer> customerTypes = new CustomerService().FindAll(); foreach (customer customer in customerTypes) { var nameModel = new NameModel {Name = customer.Name, Id = customer.Id}; names.Add(nameModel); } } if (names.Count == 0) { var nullNameModel = new NameModel(); names.Add(nullNameModel); } return basicInfoModel; }
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); } } }