/// <summary> /// 根据模具号获得模具基本信息 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>模具基本信息</returns> public MoldBaseInfo GetMoldBaseInfoByNR(string moldNR) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); IAttachmentRepository attachRep = new AttachmentRepository(unitwork); IPositionRepository posiRep = new PositionRepository(unitwork); MoldView m = moldRepostitory.GetMoldViewByMoldNR(moldNR); if (m != null) { MoldBaseInfo mb = new MoldBaseInfo() { MoldNR = m.MoldNR, Name = m.Name, Type = m.TypeName, Position = posiRep.GetByFacilictyNR(moldNR).PositionNR, Producer = m.Producer, Material = m.Material, Weight = m.Weight == null ? string.Empty : m.Weight.ToString(), State = m.State, StateCN = m.StateCN, ProjectId = m.ProjectID, ProjectName = m.ProjectName, Attach = attachRep.GetByMasterNR(moldNR) }; return(mb); } return(null); } }
/// <summary> /// 根据模具警报类型获得模具警报信息 /// </summary> /// <param name="type">模具警报类型</param> /// <returns>模具警报信息列表</returns> public List <MoldWarnInfo> GetMoldWarnInfo(MoldWarnType type) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); List <MoldView> molds = moldRepostitory.GetByWarnType(type); List <MoldWarnInfo> moldWarnInfos = new List <MoldWarnInfo>(); foreach (MoldView m in molds) { MoldWarnInfo moldWarnInfo = new MoldWarnInfo() { MoldNR = m.MoldNR, Type = m.TypeName, ProjectName = m.ProjectName, MaxLendHour = (double)m.MaxLendHour, LendTime = (DateTime)m.LastRecordDate, CurrentPosition = m.StorageRecordNR.HasValue ? moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)m.StorageRecordNR) : string.Empty }; moldWarnInfos.Add(moldWarnInfo); } return(moldWarnInfos); } }
/// <summary> /// set mold cut /// </summary> /// <param name="moldNr"></param> /// <param name="currentCut"></param> /// <param name="totalCut"></param> /// <returns></returns> public string SetMoldCut(string moldNr, string currentCut, string totalCut) { Mold mold = null; try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRep = new MoldRepository(unitwork); mold = moldRep.GetById(moldNr); if (mold != null) { // update mold state mold.CurrentCuttimes = int.Parse(currentCut); mold.Cuttedtimes = int.Parse(totalCut); } unitwork.Submit(); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); } return(moldNr); }
/// <summary> /// 根据搜索条件获得模具基本信息 /// </summary> /// <param name="conditions">搜索条件</param> /// <returns>模具基本信息列表</returns> public List <MoldBaseInfo> GetMoldByMutiConditions(MoldSearchCondition conditions) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); List <MoldView> molds = moldRepostitory.GetByMutiConditions(conditions); List <MoldBaseInfo> moldBaseInfos = new List <MoldBaseInfo>(); foreach (MoldView m in molds) { MoldBaseInfo moldBaseInfo = new MoldBaseInfo() { MoldNR = m.MoldNR, Name = m.Name, Type = m.TypeName, State = m.State, StateCN = m.StateCN, ProjectId = m.ProjectID, ProjectName = m.ProjectName, CurrentPosition = m.StorageRecordNR.HasValue ? moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)m.StorageRecordNR) : string.Empty }; moldBaseInfos.Add(moldBaseInfo); } return(moldBaseInfos); } }
/// <summary> /// 根据模具号、操作员号、起止日期、页码信息获得模具放行信息 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">页码数量</param> /// <returns>模具放行信息列表</returns> public List <MoldReleaseInfo> GetMoldReleaseInfoByMoldNRInPage(string moldNR, int pageIndex, int pageSize, string operatorId, DateTime?startDate, DateTime?endDate) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IReportRepository reportRep = new ReportRepository(unitwork); List <ReportView> reports = reportRep.GetReportViewByMoldNR(moldNR, pageIndex, pageSize, operatorId, startDate, endDate); IAttachmentRepository attachRep = new AttachmentRepository(unitwork); List <MoldReleaseInfo> moldReleaseInfos = new List <MoldReleaseInfo>(); foreach (ReportView r in reports) { MoldReleaseInfo moldReleaseInfo = new MoldReleaseInfo() { TesterName = r.Name, TesterNR = r.OperatorID, Date = r.Date, TargetNR = r.MoldID, ReportType = r.ReportType, ReportTypeCN = r.ReportTypeCN, Attach = attachRep.GetByMasterNR(r.ReportId.ToString()) }; moldReleaseInfos.Add(moldReleaseInfo); } return(moldReleaseInfos); } }
/// <summary> /// 根据库存号判断库存是否存在 /// </summary> /// <param name="posiNr">库存号</param> /// <returns>判断结果</returns> public bool PositionExist(string posiNr) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IPositionRepository posiRep = new PositionRepository(unitwork); return posiRep.PositionExsit(posiNr); } }
/// <summary> /// 根据工作台号判断工作台是否存在 /// </summary> /// <param name="stationId">工作台号</param> /// <returns>判断结果</returns> public bool WorkstationExist(string stationId) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IWorkstationRepository workRep = new WorkstationRepository(unitwork); return workRep.Exist(stationId); } }
/// <summary> /// 根据员工号判断员工是否存在 /// </summary> /// <param name="empId">员工号</param> /// <returns>判断结果</returns> public bool EmpExist(string empId) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IEmployeeRepository empRep = new EmployeeRepository(unitwork); return empRep.Exist(empId); } }
/// <summary> /// 根据模具号判断模具是否存在 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>判断结果</returns> public bool MoldExist(string moldNR) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRep = new MoldRepository(unitwork); return moldRep.MoldExsit(moldNR); } }
/// <summary> /// 根据模具号获得库位 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>库位</returns> public Position GetMoldPositionByNr(string moldNR) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IPositionRepository posiRep = new PositionRepository(unitwork); return(posiRep.GetByFacilictyNR(moldNR)); } }
/// <summary> /// 根据模具号获得库位号 /// </summary> /// <param name="posiNr">库位号</param> /// <returns>模具号</returns> public string GetMoldNrByPosiNr(string posiNr) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRep = new MoldRepository(unitwork); return(moldRep.GetMoldNrByPosiNr(posiNr)); } }
public List <ReportView> GetReportViewByDate(ReportType type, DateTime?startDate, DateTime?endDate) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IReportRepository reportRep = new ReportRepository(unitwork); return(reportRep.GetReportViewByDate(type, startDate, endDate)); } }
public List <StorageRecord> GetStoreRecordByDate(int type, DateTime?startDate, DateTime?endDate) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IStorageRecordRepository reportRep = new StorageRecordRepository(unitwork); return(reportRep.GetByTypesDate(MoldRecordTypeHelper.GetApplyTypes(type), startDate, endDate)); } }
/// <summary> /// 根据仓库类型获取仓库列表 /// </summary> /// <param name="warehouseType">仓库类型</param> /// <returns>仓库列表</returns> public List<Warehouse> GetWarehousesByType(WarehouseType warehouseType) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IWarehouseRepository warehouseRep = new WarehouseRepository(unitwork); List<Warehouse> warehouses = warehouseRep.GetWarehouseByType(warehouseType); return warehouses; } }
/// <summary> /// 获取模具型号列表 /// </summary> /// <returns>模具型号列表</returns> public List<MoldType> GetMoldTypes() { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldTypeRepositotry moldTypeRepository = new MoldTypeRepository(unitwork); List<MoldType> moldTypes = moldTypeRepository.All(); return moldTypes; } }
/// <summary> /// 获取模具类别列表 /// </summary> /// <returns>模具类别列表</returns> public List<MoldCategory> GetMoldCates() { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldCategoryRepository moldcateRep = new MoldCategoryRepository(unitwork); List<MoldCategory> moldCate = moldcateRep.All(); return moldCate; } }
/// <summary> /// 根据模具号、操作员号、起止日期获得模具基本信息 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>模具基本信息列表</returns> public List <StorageRecord> GetMoldApplyRecords(string moldNR, string applicantId, DateTime?startDate, DateTime?endDate) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IStorageRecordRepository recordRepositroy = new StorageRecordRepository(unitwork); List <StorageRecord> records = recordRepositroy.GetMoldApplyRecordsByMoldNR(moldNR, applicantId, startDate, endDate); return(records); } }
/// <summary> /// 获取成本中心列表 /// </summary> /// <returns>成本中心列表</returns> public List<Project> GetProjects() { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IProjectRepository projectRepository = new ProjectRepository(unitwork); List<Project> projects = projectRepository.All(); return projects; } }
/// <summary> /// 根据报告号获取附件 /// </summary> /// <param name="reportId">报告号</param> /// <returns>附件列表</returns> public List <Attachment> GetAttachmentById(Guid reportId) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IAttachmentRepository reportAttachRep = new AttachmentRepository(unitwork); List <Attachment> attaches = reportAttachRep.GetByMasterNR(reportId.ToString()); return(attaches); } }
/// <summary> /// 根据模具号获得库位号 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>库位号</returns> public string GetMoldCurrentPosition(string moldNR) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); MoldView moldview = moldRepostitory.GetMoldViewByMoldNR(moldNR); return(moldview.StorageRecordNR == null ? string.Empty : moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)moldview.StorageRecordNR)); } }
/// <summary> /// 模具测试 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="operatorNR">操作员工号</param> /// <param name="files">文件列表</param> /// <returns>测试信息</returns> public Message MoldTest(string moldNR, string operatorNR, FileUP[] files, int currentCutTimes, bool moldNormal) { try { using (TransactionScope ts = new TransactionScope()) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IReportRepository reportRep = new ReportRepository(unitwork); Report report = new Report(); report.ReportId = GuidUtil.GenerateGUID(); report.MoldID = moldNR; report.ReportType = ReportType.TestReport; report.OperatorID = operatorNR; report.Date = DateTime.Now; //upload files FileUpLoad(files, report.ReportId.ToString()); reportRep.Add(report); // update the last released date IMoldRepository moldRep = new MoldRepository(unitwork); Mold mold = moldRep.GetById(moldNR); mold.LastReleasedDate = report.Date; mold.Cuttedtimes += mold.CurrentCuttimes; mold.CurrentCuttimes = 0; if (moldNormal) { mold.State = MoldStateType.Normal; } unitwork.Submit(); ts.Complete(); return(new Message() { MsgType = MsgType.OK, Content = "实验报告上传成功!" }); } } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = ex.Message }); } }
public bool DelAttachmentById(int attachId, string filePath) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { try { IAttachmentRepository attachRep = new AttachmentRepository(unitwork); attachRep.DeleteById(attachId); string p = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, Settings.Default.FileAttachmentPath); string path = Path.Combine(p, filePath); File.Delete(path); unitwork.Submit(); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } return(true); } }
/// <summary> /// 根据模具号获得模具动态信息 /// </summary> /// <param name="moldNR">模具号</param> /// <returns>模具基本信息</returns> public MoldDynamicInfo GetMoldDynamicInfoByMoldNR(string moldNR) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); MoldView moldview = moldRepostitory.GetMoldViewByMoldNR(moldNR); if (moldview == null) { return(null); } IStorageRecordRepository storageRep = new StorageRecordRepository(unitwork); StorageRecord storageRecord = null; if (moldview.StorageRecordNR != null) { storageRecord = storageRep.GetByStorageNR((Guid)moldview.StorageRecordNR); } MoldDynamicInfo moldDynamicInfo = new MoldDynamicInfo() { CurrentPosition = moldview.StorageRecordNR == null ? string.Empty : moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)moldview.StorageRecordNR), Operator = storageRecord == null ? string.Empty : storageRecord.OperatorId, OperateTime = storageRecord == null ? string.Empty : storageRecord.Date.ToString(), AllowedCuttedTime = moldview.MaxCuttimes, CurrentCuttedTime = moldview.CurrentCuttimes, ReleaseCycle = moldview.ReleaseCycle, LastReleasedTime = moldview.LastReleasedDate.ToString(), MantainCycle = moldview.MaintainCycle, LastMantainTime = moldview.LastMainedDate.ToString(), State = moldview.State, StateCN = EnumUtil.GetEnumDescriptionByEnumValue(moldview.State), ProjectId = moldview.ProjectID, ProjectName = moldview.ProjectName }; return(moldDynamicInfo); } }
/// <summary> /// 将模具从缓冲区移到库位 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="operatorNR">操作员工号</param> /// <param name="remark">备注</param> /// <returns>操作信息</returns> public Message ReturnMoldInPosition(string moldNR, string operatorNR, string remark) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRep = new MoldRepository(unitwork); Mold mold = moldRep.GetById(moldNR); if (mold.State == MoldStateType.NotReturned) { return new Message() { MsgType = MsgType.Warn, Content = "模具还未归还,请归还后再入库!" } } ; string currentPosi = moldRep.GetMoldCurrPosiByMoldNR(moldNR); if (!currentPosi.Equals(GetPartPoolPosiNr())) { return new Message() { MsgType = MsgType.Warn, Content = "模具已经入库!" } } ; StorageRecord storageRecord = new StorageRecord(); //set value of storage record IPositionRepository positionRep = new PositionRepository(unitwork); Position position = positionRep.GetByFacilictyNR(moldNR); storageRecord.PositionId = position.PositionID; storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.Source = currentPosi; storageRecord.Destination = position.PositionNR; storageRecord.OperatorId = operatorNR == null?string.Empty: operatorNR.ToString(); storageRecord.Date = DateTime.Now; storageRecord.Quantity = 1; storageRecord.TargetNR = moldNR; storageRecord.Remark = remark == null?string.Empty:remark.ToString(); storageRecord.RecordType = StorageRecordType.MoveStore; // add new storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); recordRep.Add(storageRecord); // update mold last apply storage record nr IMoldLastRecordRepository lastRecordRep = new MoldLastRecordRepository(unitwork); MoldLastRecord lastRecord = lastRecordRep.GetByMoldNR(moldNR); lastRecord.StorageRecordNR = storageRecord.StorageRecordNR; unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "入库成功" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = ex.Message }); } }
/// <summary> /// 模具移库 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="sourcePosiNr">源位置号</param> /// <param name="desiPosiNr">目标位置号</param> /// <returns>移库信息</returns> public Message MoldMoveStore(string moldNR, string warehouseNR, string sourcePosiNr, string desiPosiNr) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IPositionRepository posiRep = new PositionRepository(unitwork); if (!posiRep.PositionExsit(desiPosiNr)) { return new Message() { MsgType = MsgType.Warn, Content = "目标库位不存在,请核实!" } } ; IMoldRepository moldRep = new MoldRepository(unitwork); if (moldRep.GetMoldNrByPosiNr(desiPosiNr).Length == 0) { // there is no mold in desitination position // add new uniqstorage Position position = posiRep.GetByWarehouseNRAndPositionNR(warehouseNR, desiPosiNr); // add new uniqstorage IUniqStorageRepository uniqStroageRep = new UniqStorageRepository(unitwork); uniqStroageRep.DeleteByMoldNr(moldNR); UniqStorage uniqStorage = new UniqStorage() { UniqStorageId = GuidUtil.GenerateGUID(), UniqNR = moldNR, PositionId = position.PositionID, Quantity = 1 }; uniqStroageRep.Add(uniqStorage); //set value of storage record StorageRecord storageRecord = new StorageRecord(); storageRecord.PositionId = position.PositionID; storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.Source = sourcePosiNr; storageRecord.Destination = desiPosiNr; storageRecord.Date = DateTime.Now; storageRecord.Quantity = 1; storageRecord.TargetNR = moldNR; storageRecord.RecordType = StorageRecordType.MoveStore; // add new storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); recordRep.Add(storageRecord); IMoldLastRecordRepository moldLastRecord = new MoldLastRecordRepository(unitwork); moldLastRecord.GetByMoldNR(moldNR).StorageRecordNR = storageRecord.StorageRecordNR; } else { Position sourcePosi = posiRep.GetByWarehouseNRAndPositionNR(warehouseNR, sourcePosiNr); Position desiPosi = posiRep.GetByWarehouseNRAndPositionNR(warehouseNR, desiPosiNr); UniqStorage sourceU = sourcePosi.UniqStorage.First(); UniqStorage desiU = desiPosi.UniqStorage.First(); string desiMoldNr = desiU.UniqNR; sourceU.UniqNR = desiMoldNr; desiU.UniqNR = moldNR; // add new storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); StorageRecord sourcestorageRecord = new StorageRecord(); sourcestorageRecord.PositionId = sourcePosi.PositionID; sourcestorageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); sourcestorageRecord.Source = sourcePosiNr; sourcestorageRecord.Destination = desiPosiNr; sourcestorageRecord.Date = DateTime.Now; sourcestorageRecord.Quantity = 1; sourcestorageRecord.TargetNR = moldNR; sourcestorageRecord.RecordType = StorageRecordType.MoveStore; recordRep.Add(sourcestorageRecord); StorageRecord desistorageRecord = new StorageRecord(); desistorageRecord.PositionId = desiPosi.PositionID; desistorageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); desistorageRecord.Source = desiPosiNr; desistorageRecord.Destination = sourcePosiNr; desistorageRecord.Date = DateTime.Now; desistorageRecord.Quantity = 1; desistorageRecord.TargetNR = desiMoldNr; desistorageRecord.RecordType = StorageRecordType.MoveStore; recordRep.Add(desistorageRecord); IMoldLastRecordRepository moldLastRecord = new MoldLastRecordRepository(unitwork); moldLastRecord.GetByMoldNR(moldNR).StorageRecordNR = sourcestorageRecord.StorageRecordNR; moldLastRecord.GetByMoldNR(desiMoldNr).StorageRecordNR = desistorageRecord.StorageRecordNR; } unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "移库成功" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = ex.Message }); } }
/// <summary> /// 申领模具 /// </summary> /// <param name="moldUseType">模具使用类型</param> /// <param name="moldNR">模具号</param> /// <param name="applicantNR">申请员工工号</param> /// <param name="operatorNR">操作员工工号</param> /// <param name="workstationNR">操作台号</param> /// <returns>申请信息</returns> public Message ApplyMold(MoldUseType moldUseType, string moldNR, string applicantNR, string operatorNR, string workstationNR) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IWorkstationRepository workstationRep = new WorkstationRepository(unitwork); IMoldRepository moldRep = new MoldRepository(unitwork); Mold mold = moldRep.GetById(moldNR); // check mold is available for apply if (mold.State == MoldStateType.NotReturned) { return new Message() { MsgType = MsgType.Warn, Content = "模具处于不可借状态!" } } ; // check workstaition reach the max mold apply number if (workstationRep.OverAppliedMold(workstationNR) == false && Settings.Default.AllowOverApply == false) { return new Message() { MsgType = MsgType.Warn, Content = "申领已到达上限!" } } ; if (mold.CurrentCuttimes != null && mold.MaxCuttimes != null) { if (mold.CurrentCuttimes.Value > mold.MaxCuttimes.Value) { return(new Message() { MsgType = MsgType.Warn, Content = "模具压接次数超过上限!" }); } } IPositionRepository positionRep = new PositionRepository(unitwork); Position position = positionRep.GetByFacilictyNR(moldNR); //set value of storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); StorageRecord storageRecord = new StorageRecord(); storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.PositionId = position.PositionID; storageRecord.Source = position.PositionNR; storageRecord.Destination = workstationNR; storageRecord.OperatorId = operatorNR; storageRecord.ApplicantId = applicantNR; storageRecord.Quantity = 1; storageRecord.Date = DateTime.Now; storageRecord.TargetNR = moldNR; storageRecord.RecordType = (StorageRecordType)moldUseType; // add new storage record recordRep.Add(storageRecord); // update mold last apply storage record nr IMoldLastRecordRepository lastRecordRep = new MoldLastRecordRepository(unitwork); MoldLastRecord lastRecord = lastRecordRep.GetByMoldNR(moldNR); lastRecord.StorageRecordNR = storageRecord.StorageRecordNR; // update mold state mold = moldRep.GetById(storageRecord.TargetNR); mold.State = MoldStateType.NotReturned; // update the workstation current mold count Workstation workstation = workstationRep.GetById(storageRecord.Destination); workstation.CurrentMoldCount++; unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "申领成功" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = "请核实所填数据的准确性" }); } }
/// <summary> /// 模具入库 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="operatorNR">操作员工号</param> /// <param name="warehouseNR">仓库号</param> /// <param name="positionNR">库位号</param> /// <returns>入库信息</returns> public Message MoldInStore(string moldNR, string operatorNR, string warehouseNR, string positionNR) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IPositionRepository positionRep = new PositionRepository(unitwork); IMoldLastRecordRepository lastRecordRep = new MoldLastRecordRepository(unitwork); // check if mold is reinstore again if (lastRecordRep.MoldInStored(moldNR) == true) { return new Message() { MsgType = MsgType.Warn, Content = "此模具已经入库!" } } ; //check if position is available and allow over instore if (positionRep.CheckPositionAvailable(warehouseNR, positionNR, 1) == false && Settings.Default.AllowOverInStore == false) { return new Message() { MsgType = MsgType.Warn, Content = "库位容量已打上限!" } } ; Position position = positionRep.GetByWarehouseNRAndPositionNR(warehouseNR, positionNR); // add new uniqstorage IUniqStorageRepository uniqStroageRep = new UniqStorageRepository(unitwork); UniqStorage uniqStorage = new UniqStorage() { UniqStorageId = GuidUtil.GenerateGUID(), UniqNR = moldNR, PositionId = position.PositionID, Quantity = 1 }; uniqStroageRep.Add(uniqStorage); //set value of storage record StorageRecord storageRecord = new StorageRecord(); storageRecord.PositionId = position.PositionID; storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.Source = moldNR; storageRecord.Destination = position.PositionNR; storageRecord.OperatorId = operatorNR; storageRecord.Date = DateTime.Now; storageRecord.Quantity = 1; storageRecord.TargetNR = moldNR; storageRecord.RecordType = StorageRecordType.InStore; // add new storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); recordRep.Add(storageRecord); // add mold last apply // add mold last apply storage record nr MoldLastRecord lastRecord = new MoldLastRecord() { MoldNR = moldNR, StorageRecordNR = storageRecord.StorageRecordNR }; // lastRecord.StroageRecordNR = storageRecord.StorageRecordNR; lastRecordRep.Add(lastRecord); unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "入库成功!" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = "请核实所填数据的准确性" }); } }
/// <summary> /// 上传文件 /// </summary> /// <param name="files">文件列表</param> /// <param name="masterNR">附主号</param> /// <returns>上传信息</returns> public Message FileUpLoad(FileUP[] files, string masterNR) { try { if (files != null && files.Length > 0) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { string p = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, Settings.Default.FileAttachmentPath); if (!Directory.Exists(p)) { Directory.CreateDirectory(p); } List <Attachment> reportAttaches = new List <Attachment>(); string type = string.Empty; const int bufferLength = 4096; foreach (FileUP file in files) { // type = file.Name.Substring(file.Name.LastIndexOf('.'), file.Name.Length - file.Name.LastIndexOf('.')); string servername = GuidUtil.GenerateGUID().ToString() + file.FileType; string filePath = Path.Combine(p, servername); using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write, FileShare.Read)) { using (Stream stream = new MemoryStream(file.Data)) { byte[] buffer = new byte[bufferLength]; int readcount = 0; do { readcount = stream.Read(buffer, 0, bufferLength); if (readcount > 0) { fs.Write(buffer, 0, readcount); } } while (readcount > 0); } } Attachment attachment = new Attachment() { MasterNR = masterNR, Name = file.Name, Path = servername, Date = DateTime.Now }; reportAttaches.Add(attachment); } IAttachmentRepository attachRep = new AttachmentRepository(unitwork); attachRep.Add(reportAttaches); unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "文件上传成功!" }); } } return(new Message() { MsgType = MsgType.Warn, Content = "文件为空!" }); } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = "请核实所填数据的准确性" }); } }
/// <summary> /// 模具移动工作台 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="operatorNR">操作员工号</param> /// <param name="targetWStationNR">目标工作台号</param> /// <returns>移动信息</returns> public Message MoldMoveWorkStation(string moldNR, string operatorNR, string targetWStationNR) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IWorkstationRepository workstationRep = new WorkstationRepository(unitwork); IMoldRepository moldRep = new MoldRepository(unitwork); IEmployeeRepository empRep = new EmployeeRepository(unitwork); Mold mold = moldRep.GetById(moldNR); if (!empRep.Exist(operatorNR)) { return new Message() { MsgType = MsgType.Warn, Content = "操作员不存在!" } } ; if (mold == null) { return new Message() { MsgType = MsgType.Warn, Content = "模具不存在!" } } ; Workstation tworkstation = workstationRep.GetById(targetWStationNR); if (tworkstation == null) { return new Message() { MsgType = MsgType.Warn, Content = "目标工作台不存在!" } } ; // check mold is available for move if (mold.State != MoldStateType.NotReturned) { return new Message() { MsgType = MsgType.Warn, Content = "模具未被借用,请先借用!" } } ; MoldView moldview = moldRep.GetMoldViewByMoldNR(moldNR); string currentWorkPosi = moldview.StorageRecordNR == null ? string.Empty : moldRep.GetMoldCurrPosiByRecordNR((Guid)moldview.StorageRecordNR); // if(workstationRep.GetById(currentWorkPosi)==null) // return new Message() { MsgType = MsgType.Warn, Content = "模具正在使用的工作台号已经被修改,请先归还此模具再做后续操作!" }; if (currentWorkPosi.Equals(targetWStationNR)) { return new Message() { MsgType = MsgType.Warn, Content = "模具已经在此工作台,不可重复移动!" } } ; // check workstaition reach the max mold apply number if (workstationRep.OverAppliedMold(targetWStationNR) == false && Settings.Default.AllowOverApply == false) { return new Message() { MsgType = MsgType.Warn, Content = "目标工作台已经到达模具使用上限!" } } ; IPositionRepository positionRep = new PositionRepository(unitwork); Position position = positionRep.GetByFacilictyNR(moldNR); //set value of storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); StorageRecord storageRecord = new StorageRecord(); storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.PositionId = position.PositionID; storageRecord.Source = currentWorkPosi; storageRecord.Destination = targetWStationNR; storageRecord.OperatorId = operatorNR; storageRecord.Quantity = 1; storageRecord.Date = DateTime.Now; storageRecord.TargetNR = moldNR; storageRecord.RecordType = StorageRecordType.MoveWStation; // add new storage record recordRep.Add(storageRecord); // update mold last apply storage record nr IMoldLastRecordRepository lastRecordRep = new MoldLastRecordRepository(unitwork); MoldLastRecord lastRecord = lastRecordRep.GetByMoldNR(moldNR); lastRecord.StorageRecordNR = storageRecord.StorageRecordNR; // update the workstation current mold count //Workstation tworkstation = workstationRep.GetById(storageRecord.Destination); //if(tworkstation!=null) tworkstation.CurrentMoldCount++; Workstation sworkstation = workstationRep.GetById(storageRecord.Source); if (sworkstation != null) { sworkstation.CurrentMoldCount--; } unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "移动工作台成功!" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = "请核实所填数据的准确性" }); } }
/// <summary> /// 归还模具 /// </summary> /// <param name="moldNR">模具号</param> /// <param name="applicantNR">申请员工工号</param> /// <param name="operatorNR">操作员工工号</param> /// <param name="remark">备注</param> /// <param name="moldState">模具状态</param> /// <returns>归还信息</returns> public Message ReturnMold(string moldNR, string applicantNR, string operatorNR, string remark, MoldReturnStateType moldState) { try { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRep = new MoldRepository(unitwork); Mold mold = moldRep.GetById(moldNR); if (mold.State != MoldStateType.NotReturned) { return new Message() { MsgType = MsgType.Warn, Content = "模具已归还!" } } ; StorageRecord storageRecord = new StorageRecord(); //set value of storage record IPositionRepository positionRep = new PositionRepository(unitwork); //Position position = positionRep.GetByFacilictyNR(moldNR); Position position = positionRep.GetPartPoolPosition(Settings.Default.MoldPoolPosiNr); storageRecord.PositionId = position.PositionID; storageRecord.StorageRecordNR = GuidUtil.GenerateGUID(); storageRecord.Source = moldRep.GetMoldCurrPosiByMoldNR(moldNR); storageRecord.Destination = position.PositionNR; storageRecord.OperatorId = operatorNR; storageRecord.ApplicantId = applicantNR; storageRecord.Date = DateTime.Now; storageRecord.Quantity = 1; storageRecord.TargetNR = moldNR; storageRecord.Remark = remark; storageRecord.RecordType = StorageRecordType.Return; // add new storage record IStorageRecordRepository recordRep = new StorageRecordRepository(unitwork); recordRep.Add(storageRecord); // update mold last apply storage record nr IMoldLastRecordRepository lastRecordRep = new MoldLastRecordRepository(unitwork); MoldLastRecord lastRecord = lastRecordRep.GetByMoldNR(moldNR); lastRecord.StorageRecordNR = storageRecord.StorageRecordNR; // update mold state mold = moldRep.GetById(storageRecord.TargetNR); mold.State = (MoldStateType)moldState; // update workstation mold count IWorkstationRepository workstationRep = new WorkstationRepository(unitwork); Workstation workstation = workstationRep.GetById(storageRecord.Source); if (workstation != null) { workstation.CurrentMoldCount--; } unitwork.Submit(); return(new Message() { MsgType = MsgType.OK, Content = "归还成功" }); } } catch (Exception ex) { LogUtil.log.Error(ex.ToString()); return(new Message() { MsgType = MsgType.Error, Content = ex.Message }); } }