/// <summary> /// 查看销售任务 /// </summary> /// <param name="taskNumber">任务编号</param> /// <returns></returns> public SaleTask GetSaleTask(string taskNumber) { var taskService = new TaskService(); var taskEmployeeService = new TaskEmployeeService(); var pigTypeService = new PigTypeService(); task task = taskService.FindByTaskNumber(taskNumber); if (task == null) { return null; } var customerService = new CustomerService(); var checkTask = new SaleTask { TaskNumber = task.TaskNumber, StartTime = task.StartTime, EndTime = task.EndTime, EmployeeName = taskEmployeeService.GetEmployeeNames(task.Id), EmployeeNumber = taskEmployeeService.GetEmployeeNumbers(task.Id), Customer = customerService.Find(task.CustomerId).Name, Status = task.task_status_type.Name, Memo = task.Memo }; List<SaleDetail> saleDetailList = task.sale_task_quality.Select(item => new SaleDetail { PigType = pigTypeService.Find( item.PigTypeId).Name, Price = item.Price, Quantity = item.Quality }).ToList(); if (saleDetailList.Count != 0) { checkTask.SaleDetailList = saleDetailList; } return checkTask; }
/// <summary> /// 获得猪类型下拉列表 /// </summary> /// <returns>返回集合</returns> public IEnumerable<SelectListItem> GetPigTypeList() { var pigTypeService = new PigTypeService(); IEnumerable<SelectListItem> pigTypeList = pigTypeService.FindAll().Select(pigTypeItem => new SelectListItem { Text = pigTypeItem.Name, Value = pigTypeItem.Id + string.Empty, }).OrderBy(m => m.Text); return pigTypeList; }
/// <summary> /// 公猪下拉列表 /// </summary> /// <returns></returns> public IEnumerable<SelectListItem> GetMalePigList() { var pigService = new PigService(); var pigTypeService = new PigTypeService(); pig_type pigType = pigTypeService.FindByName("公猪"); if (pigType == null) return new List<SelectListItem>(); IEnumerable<SelectListItem> pigSelect = pigService.FindByPigTypeId(pigType.Id) .Select(pigtypeItem => new SelectListItem { Text = pigtypeItem. Number, Value = pigtypeItem. Id + string.Empty, }).OrderBy(m => m.Text); return pigSelect; }
//判断类型是否重复 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 JsonResult getPigstyTypes(string pigstys,string pigHouseId) { HashSet<SelectListItem>pigStyType=new HashSet<SelectListItem>(); TransferService transferService= new TransferService(); var pigstyService = new PigstyService(); var pigTypeService=new PigTypeService(); pigStyType.Add(new SelectListItem(){ Text="全部猪",Value="0",Selected=true }); foreach(var str in pigstys.Split(',')){ var pigSty=pigstyService.GetPigsty(int.Parse(str),long.Parse(pigHouseId)); var pigTypeIdList =transferService.FindByPigStyByPigType(pigSty.Id); foreach(var id in pigTypeIdList){ var name=pigTypeService.Find(id).Name; pigStyType.Add(new SelectListItem(){ Text=name,Value=id+"" }); } } return Json(pigStyType, JsonRequestBehavior.AllowGet); }
/// <summary> /// 根据公猪的类型id得到所有的公猪编号和名字 /// </summary> /// <returns>所有的公猪编号和名字</returns> public string GetMaleParentName() { var pigservice = new PigService(); var pigtypeservice = new PigTypeService(); try { long maleparentid = pigtypeservice.FindByName("公猪").Id; return pigservice.GetPigNumberAndNameByPigType(maleparentid); } catch (Exception) { return null; } }
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 PigTypeSaveChanges(BasicInfoModel model) { var typeService = new PigTypeService(); List<pig_type> types = typeService.FindAll(); foreach (pig_type type in types) { int idFlag = 0; int nameFlag = 0; string newname = ""; foreach (NameModel name in model.Names) { if (type.Id == name.Id) { idFlag = 1; if (type.Name.Equals(name.Name)) { nameFlag = 1; } else { newname = name.Name; } } } //若存在此Id,但是name变化了的,则需要修改数据库 if (idFlag == 1) { if (nameFlag == 0) { if (newname == "") { throw new Exception(); } pig_type modifyCure = typeService.Find(type.Id); modifyCure.Name = newname; typeService.Update(modifyCure); } } } //如果model里的Id为0,说明是新建的类型 foreach (NameModel name in model.Names) { if (name.Id == 0 && typeService.FindByName(name.Name) == null) { var newType = new pig_type {Name = name.Name}; typeService.Insert(newType); } } }