public CommonService(IFooterRepository footerRepository, ISlideRepository slideRepository,
ISystemConfigRepository systemConfigRepository)
{
_footerRepository = footerRepository;
_slideRepository = slideRepository;
_systemConfigRepository = systemConfigRepository;
}
public CommonService(ISystemConfigRepository systemConfigRepository, ITimeDayRepository timeDayRepository, IHolidayRepository holidayRepository, IUnitOfWork unitOfWork)
{
_unitOfWork = unitOfWork;
_systemConfigRepository = systemConfigRepository;
_timeDayRepository = timeDayRepository;
_holidayRepository = holidayRepository;
}
public CommonService(IFooterRepository footerRepository, ISystemConfigRepository systemConfigRepository, IUnitOfWork unitOfWork, ISlideRepository slideRepository)
{
_footerRepository = footerRepository;
_unitOfWork = unitOfWork;
_systemConfigRepository = systemConfigRepository;
_slideRepository = slideRepository;
}
/// <summary>
/// 取得所有类别列表(已经排序好)
/// </summary>
/// <param name="parent_id">父ID</param>
/// <param name="nav_type">导航类别</param>
/// <param name="isAgent">是否为代理商</param>
/// <returns>DataTable</returns>
public DataTable GetList(int parent_id, string nav_type, bool isAgent, ISystemConfigRepository wxSystemConfigRepository)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,nav_type,name,title,sub_title,link_url,sort_id,is_lock,remark,parent_id,class_list,class_layer,channel_id,action_type,is_sys");
strSql.Append(" FROM " + databaseprefix + "navigation");
strSql.Append(" where nav_type='" + nav_type + "' ");
if (isAgent)
{
string notinStr = wxSystemConfigRepository.GetConfigValue("agentxx");
strSql.Append(" and is_lock=0 and id not in (" + notinStr + ") ");
}
strSql.Append(" order by sort_id asc,id asc");
DataSet ds = DbHelperSQL.Query(strSql.ToString());
DataTable oldData = ds.Tables[0] as DataTable;
if (oldData == null)
{
return(null);
}
//复制结构
DataTable newData = oldData.Clone();
//调用迭代组合成DAGATABLE
GetChilds(oldData, newData, parent_id);
return(newData);
}
public AdministratorController(ITaskHourCostRepository TaskHourCostRepository,
IDepartmentRepository DepartmentRepository,
IUserRepository UserRepository,
IPositionRepository PositionRepository,
IMaterialRepository MaterialRepository,
IHardnessRepository HardnessRepository,
IBrandRepository BrandRepository,
IPhaseRepository PhaseRepository,
IDepPhaseRepository DepPhaseRepository,
IMachinesInfoRepository MachinesInfoRepository,
IMachineRepository MachinesRepository,
ISystemConfigRepository SystemConfigRepository)
{
_taskHourCostRepository = TaskHourCostRepository;
_departmentRepository = DepartmentRepository;
_userRepository = UserRepository;
_posRepository = PositionRepository;
_materialRepository = MaterialRepository;
_hardnessRepository = HardnessRepository;
_brandRepository = BrandRepository;
_phaseRepository = PhaseRepository;
_depphaseRepository = DepPhaseRepository;
_machinesinfoRepository = MachinesInfoRepository;
_machinesRepository = MachinesRepository;
_systemConfigRepository = SystemConfigRepository;
}
public CommonService(IFooterRepository footerRepository, ISystemConfigRepository systemConfigRepository, ISlideRepository slideRepository, IUnitOfWork unitOfWork)
{
this.footerRepository = footerRepository;
this.systemConfigRepository = systemConfigRepository;
this.slideRepository = slideRepository;
this.unitOfWork = unitOfWork;
}
public SettingService(ISettingRepository settingRepository,
IUnitOfWork unitOfWork,
ISystemConfigRepository systemConfigRepository)
{
_settingRepository = settingRepository;
_systemConfigRepository = systemConfigRepository;
this.unitOfWork = unitOfWork;
}
public SystemConfigServices(IDbContextScopeFactory dbContextScopeFactory,
ISystemConfigRepository systemConfigRepository,
IMapper mapper)
{
_dbContextScopeFactory = dbContextScopeFactory;
_systemConfigRepository = systemConfigRepository;
_mapper = mapper;
}
public CommonService(IUnitOfWork unitOfWork, ISlideRepository slideRepository,
IApplicationUserRepository applicationUserRepository,
ISystemConfigRepository systemConfigRepository)
{
_unitOfWork = unitOfWork;
_slideRepository = slideRepository;
_applicationUserRepository = applicationUserRepository;
_systemConfigRepository = systemConfigRepository;
}
public CommonService(IFooterRepository footerRepository,
ISystemConfigRepository systemConfigRepository,
IUnitOfWork unitOfWork,
ISlideRepository slideRepository,
ITagRepository tagRepository,
IAdvertistmentRepository advertistmentRepository,
IProductQuantityRepository productQuantityRepository,
IColorRepository colorRepository,
ISizeRepository sizeRepository,
IPerfumeRepository perfumeRepository)
{
_perfumeRepository = perfumeRepository;
_sizeRepository = sizeRepository;
_productQuantityRepository = productQuantityRepository;
_colorRepository = colorRepository;
_footerRepository = footerRepository;
_unitOfWork = unitOfWork;
_systemConfigRepository = systemConfigRepository;
_slideRepository = slideRepository;
_tagRepository = tagRepository;
_advertistmentRepository = advertistmentRepository;
}
/// <summary>
/// 初始化系统配置服务
/// </summary>
/// <param name="unitOfWork">工作单元</param>
/// <param name="repository">系统配置仓储</param>
public SystemConfigService( IApplicationUnitOfWork unitOfWork, ISystemConfigRepository repository )
: base( unitOfWork, repository ) {
Repository = repository;
}
public WorkFlowModuleService(ISystemConfigRepository systemConfigRepo)
: base(systemConfigRepo)
{
}
/// <summary>
/// 取得所有类别列表
/// </summary>
/// <param name="parent_id">父ID</param>
/// <param name="nav_type">导航类别</param>
/// <returns>DataTable</returns>
public DataTable GetList(int parent_id, string nav_type, bool isAgent, ISystemConfigRepository wxSystemConfigRepository)
{
return this._repository.GetList(parent_id, nav_type, isAgent, wxSystemConfigRepository);
}
public SystemConfigService(ISystemConfigRepository systemConfigRepo)
: base(systemConfigRepo)
{
}
public SystemConfigService(IUnitOfWork unitOfWork, ISystemConfigRepository systemConfigRepository)
{
_systemConfigRepository = systemConfigRepository;
_unitOfWork = unitOfWork;
}
public KeyValueService(ISystemConfigRepository systemConfigRepository, ILoggerHelper logger, IServiceProvider serviceProvider) : base(logger, serviceProvider)
{
this.systemConfigRepository = systemConfigRepository;
}
public SystemConfigService(ISystemConfigRepository systemConfigRepository, IUnitOfWork unitOfWork)
{
this._systemConfigRepository = systemConfigRepository;
this._unitOfWork = unitOfWork;
}
public SystemConfigService(ISystemConfigRepository repository)
{
this._repository = repository;
}
/// <summary>
/// 取得所有类别列表(已经排序好)
/// </summary>
/// <param name="parent_id">父ID</param>
/// <param name="nav_type">导航类别</param>
/// <param name="isAgent">是否为代理商</param>
/// <returns>DataTable</returns>
public DataTable GetList(int parent_id, string nav_type, bool isAgent, ISystemConfigRepository wxSystemConfigRepository)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,nav_type,name,title,sub_title,link_url,sort_id,is_lock,remark,parent_id,class_list,class_layer,channel_id,action_type,is_sys");
strSql.Append(" FROM " + databaseprefix + "navigation");
strSql.Append(" where nav_type='" + nav_type + "' ");
if (isAgent)
{
string notinStr = wxSystemConfigRepository.GetConfigValue("agentxx");
strSql.Append(" and is_lock=0 and id not in (" + notinStr + ") ");
}
strSql.Append(" order by sort_id asc,id asc");
DataSet ds = DbHelperSQL.Query(strSql.ToString());
DataTable oldData = ds.Tables[0] as DataTable;
if (oldData == null)
{
return null;
}
//复制结构
DataTable newData = oldData.Clone();
//调用迭代组合成DAGATABLE
GetChilds(oldData, newData, parent_id);
return newData;
}
public SystemConfigService(ISystemConfigRepository repository)
{
this._repository = repository;
}
public BLLConfig()
{
repSystemConfig = new SystemConfigRepository(DatabaseFactory);
}
public BLLConfig(IDatabaseFactory<MobileContext> iDatabaseFactory)
{
repSystemConfig = new SystemConfigRepository(iDatabaseFactory);
}
public SystemConfigLogic(ISystemConfigRepository systemConfigRepository) : base(systemConfigRepository)
{
_systemConfigRepository = systemConfigRepository;
}
public WorkHourController(ITaskRepository TaskRepository,
IPartRepository PartRepository,
IProjectRepository ProjectRepository,
IUserRepository UserRepository,
ICNCItemRepository CNCItemRepository,
IQCInfoRepository QCInfoRepository,
IWarehouseStockRepository WarehouseStockRepository,
IMachineRepository MachineRepository,
ICNCMachInfoRepository CNCMachInfoRepository,
ISteelGroupProgramRepository SteelGroupProgramRepository,
ISteelProgramRepository SteelProgramRepository,
IEDMSettingRepository EDMSettingRepository,
IEDMDetailRepository EDMDetailRepository,
IQCPointProgramRepository QCPointProgramRepository,
ISystemConfigRepository SystemConfigRepository,
IQCSteelPointRepository QCSteelPointRepository,
ISteelCAMDrawingRepository SteelCAMDrawingRepository,
ISteelDrawingCADPartRepository SteelDrawingCADPartRepository,
ICAMDrawingRepository CAMDrawingRepository,
IProjectPhaseRepository ProjectPhaseRepository,
IPOContentRepository POContentRepository,
IQCTaskRepository QCTaskRepository,
IQCCmmReportRepository QCCmmReportRepository,
IQCCmmFileSettingRepository QCCmmFileSettingRepository,
IPRContentRepository PRContentRepository,
IPurchaseRequestRepository PurchanseRequestRepository,
ICharmillRepository CharmillRepository,
IEDMTaskRecordRepository EDMTaskRepository,
IDepartmentRepository DepartmentRepository,
IMGSettingRepository MGSettingRepository,
IWEDMSettingRepository WEDMSettingRepository,
ITaskHourRepository TaskHourRepository,
IMachinesInfoRepository MachinesInfoRepository,
ITaskTypeRepository TaskTypeRepositroy,
IWH_WorkTypeRepository WorkTypeRepository)
{
_taskRepository = TaskRepository;
_partRepository = PartRepository;
_projectRepository = ProjectRepository;
_userRepository = UserRepository;
_cncItemRepository = CNCItemRepository;
_qcInfoRepository = QCInfoRepository;
_whStockRepository = WarehouseStockRepository;
_machineRepository = MachineRepository;
_machInfoRepository = CNCMachInfoRepository;
_steelGroupProgramRepository = SteelGroupProgramRepository;
_steelProgramRepository = SteelProgramRepository;
_edmSettingRepository = EDMSettingRepository;
_edmDetailRepository = EDMDetailRepository;
_qcPointProgramRepository = QCPointProgramRepository;
_systemConfigRepository = SystemConfigRepository;
_qcSteelPointRepository = QCSteelPointRepository;
_steelCAMDrawingRepository = SteelCAMDrawingRepository;
_steelDrawingCADPartRepository = SteelDrawingCADPartRepository;
_camDrawingRepository = CAMDrawingRepository;
_projectPhaseRepository = ProjectPhaseRepository;
_poContentRepository = POContentRepository;
_qcTaskRepository = QCTaskRepository;
_qcCmmReportRepository = QCCmmReportRepository;
_qcCmmFileSettingRepository = QCCmmFileSettingRepository;
_prContentRepository = PRContentRepository;
_prRepository = PurchanseRequestRepository;
_charmillRepository = CharmillRepository;
_edmRecordRepository = EDMTaskRepository;
_departmentRepository = DepartmentRepository;
_mgSettingRepository = MGSettingRepository;
_wedmSettingRepository = WEDMSettingRepository;
_taskHourRepository = TaskHourRepository;
_machinesinfoRepository = MachinesInfoRepository;
_taskTyprRepository = TaskTypeRepositroy;
_workTyprRepository = WorkTypeRepository;
}
public SystemConfigLogic(ISystemConfigRepository configRepository)
: base(configRepository)
{
_configRepository = configRepository;
}
public TaskGridViewModel(IEnumerable <Task> Tasks,
IUserRepository UserRepository,
string CAMDrawingPath,
ICNCMachInfoRepository MachInfoRepository,
IEDMDetailRepository EDMDetailRepository,
ITaskRepository TaskRepository, IProjectPhaseRepository ProjectPhaseRepository,
IMGSettingRepository MGSettingRepository,
IWEDMSettingRepository WEDMSettingRepository,
ITaskHourRepository TaskHourRepository
, ISystemConfigRepository SystemConfigRepo
, ITaskTypeRepository TasktypeRepo
, IMachinesInfoRepository MachInfoRepo)
{
ProjectPhase _phase;
string _cad, _cam, _workshop, _qc, _planDate;
int _phaseID = 0;
rows = new List <TaskGridRowModel>();
List <WEDMSetting> _wedmSettings = WEDMSettingRepository.WEDMSettings.ToList();
List <MGSetting> _mgSettings = MGSettingRepository.MGSettings.ToList();
List <User> _users = UserRepository.Users.ToList();
List <ProjectPhase> _pjPhases = ProjectPhaseRepository.ProjectPhases.ToList();
List <TaskHour> _taskhours = TaskHourRepository.TaskHours.ToList();
List <MachinesInfo> _machineInfos = MachInfoRepo.MachinesInfo.ToList();
List <TaskType> _tasktypes = TasktypeRepo.TaskTypes.ToList();
List <CNCMachInfo> _cncmachInfos = MachInfoRepository.CNCMachInfoes.ToList();
List <Task> _tasks = TaskRepository.Tasks.ToList();
List <EDMDetail> _edmDetails = EDMDetailRepository.EDMDetails.ToList();
foreach (Task _task in Tasks)
{
WEDMSetting wedmsetting = new WEDMSetting();
MGSetting mgsetting = new MGSetting();
switch (_task.TaskType)
{
case 1:
_phaseID = 8;
break;
case 2:
_phaseID = 9;
break;
case 3:
wedmsetting = _wedmSettings.Where(s => s.ID == _task.ProgramID).FirstOrDefault() ?? new WEDMSetting(); //WEDMSettingRepository.QueryByTaskID(_task.TaskID);
_phaseID = 10;
break;
case 4:
_phaseID = 8;
break;
case 6:
mgsetting = _mgSettings.Where(s => s.ID == _task.ProgramID).FirstOrDefault() ?? new MGSetting(); //MGSettingRepository.QueryByTaskID(_task.TaskID);
_phaseID = 7;
break;
}
_cad = _task.CADUser > 0 ? (_users.Where(u => u.UserID == _task.CADUser).FirstOrDefault() ?? new User()).FullName : ""; //UserRepository.GetUserByID(_task.CADUser).FullName : "";
_cam = _task.CAMUser > 0? (_users.Where(u => u.UserID == _task.CAMUser).FirstOrDefault() ?? new User()).FullName : ""; //UserRepository.GetUserByID(_task.CAMUser).FullName:"";
_workshop = _task.WorkshopUser > 0? (_users.Where(u => u.UserID == _task.WorkshopUser).FirstOrDefault() ?? new User()).FullName : ""; //UserRepository.GetUserByID(_task.WorkshopUser).FullName:"";
_qc = _task.QCUser > 0 ? (_users.Where(u => u.UserID == _task.QCUser).FirstOrDefault() ?? new User()).FullName : ""; //UserRepository.GetUserByID(_task.QCUser).FullName : "";
CNCMachInfo _machinfo = GetCNCMachinfo(_task, _cncmachInfos, _tasks, _edmDetails); //GetCNCMachinfo(_task,MachInfoRepository, TaskRepository, EDMDetailRepository);
decimal TaskHour = 0;
try
{
_phase = _pjPhases.Where(p => p.ProjectID == _task.ProjectID && p.PhaseID == _phaseID).FirstOrDefault() ?? new ProjectPhase();//ProjectPhaseRepository.GetProjectPhases(_task.ProjectID).Where(p => p.PhaseID == _phaseID).FirstOrDefault();
_planDate = _phase.PlanCFinish == new DateTime(1, 1, 1) ? _phase.PlanFinish.ToString("yyyy-MM-dd") :
_phase.PlanCFinish.ToString("yyyy-MM-dd");
}
catch
{
_planDate = "-";
}
try
{
TaskHour = GetTotalHourByTaskID(_taskhours, _task.TaskID);//TaskHourRepository.GetTotalHourByTaskID(_task.TaskID);
}
catch
{
TaskHour = 0;
}
string _machineCode = GetMachineByTask(_taskhours, _machineInfos, _task.TaskID); //TaskHourRepository.GetMachineByTask(_task.TaskID) ?? "";
string Operater = GetOperaterByTaskID(_taskhours, _task.TaskID); //TaskHourRepository.GetOperaterByTaskID(_task.TaskID) ?? "";
SetupTaskStart _setupTask = new SetupTaskStart
{
TaskID = _task.TaskID,
TaskName = _task.TaskName,
State = Enum.GetName(typeof(TaskStatus), _task.State),
MachinesCode = "",
MachinesName = _machineCode,
TotalTime = Convert.ToInt32(TaskHour),
UserID = 0,
UserName = Operater,
};
//string _camDrawingPath = string.Empty;
if (string.IsNullOrEmpty(CAMDrawingPath))
{
if (_task.TaskType == 6)
{
CAMDrawingPath = SystemConfigRepo.GetTaskDrawingPath("CAD");
}
else
{
CAMDrawingPath = SystemConfigRepo.GetTaskDrawingPath();
}
}
string taskType = string.Empty;
int _mgtype = (_tasktypes.Where(t => t.ShortName == "MG" && t.Enable).FirstOrDefault() ?? new TaskType()).TaskID;//(TasktypeRepo.TaskTypes.Where(t => t.ShortName == "MG" && t.Enable).FirstOrDefault() ?? new TaskType()).TaskID;//6
if (_task.TaskType != _mgtype)
{
taskType = (_tasktypes.Where(t => t.TaskID == _task.TaskType && t.Enable).FirstOrDefault() ?? new TaskType()).Name;//TasktypeRepo.TaskTypes.Where(t => t.TaskID == _task.TaskType).Select(t => t.Name).FirstOrDefault();
}
else
{
string _typeID = (_mgtype.ToString() + _task.OldID.ToString());
taskType = (_tasktypes.Where(t => t.TaskID == Convert.ToInt32(_typeID) && t.Enable).FirstOrDefault() ?? new TaskType()).Name;//TasktypeRepo.TaskTypes.ToList().Where(t => t.TaskID == Convert.ToInt32(_typeID)).Select(t => t.Name).FirstOrDefault();
}
rows.Add(new TaskGridRowModel(_task, _cad, _cam, _workshop, _qc, CAMDrawingPath, _planDate, _setupTask, _machinfo, wedmsetting, mgsetting, taskType));
}
}
/// <summary>
/// 取得所有类别列表
/// </summary>
/// <param name="parent_id">父ID</param>
/// <param name="nav_type">导航类别</param>
/// <returns>DataTable</returns>
public DataTable GetList(int parent_id, string nav_type, bool isAgent, ISystemConfigRepository wxSystemConfigRepository)
{
return(this._repository.GetList(parent_id, nav_type, isAgent, wxSystemConfigRepository));
}
public CommonService(ISystemConfigRepository systemConfigRepository, IUnitOfWork unitOfWork)
{
_unitOfWork = unitOfWork;
_systemConfigRepository = systemConfigRepository;
}
