public virtual string Add(MasterData data) { var newMasterData = new TESTENTITY() { Id = "123", STRING = data.city, ISACTIVE = SafeConvert.ToInt64(data.isActive), COMMENT = data.comment, TESTENTITY2ID = data.combobox, REGISTERTIME = data.registerTime, }; var Id = testRepository.Insert(newMasterData).Id; // testRepository.InsertOrUpdate(newMasterData); return(Id); // testRepository.Update(t => t.Id == "57627fde-0332-4db0-9036-ce3ec5e48496", t => // new TESTENTITY() // { // // COMMENT = DateTime.Now.ToString("HH:mm:ss") // } // ); //throw new Exception(); //test2Repository.Update(t => t.Id == "123",t => new TESTENTITY2() { // Text = DateTime.Now.ToString("HH:mm:ss tt zz") //}); return(null); }
/// <summary> /// 修改角色 /// </summary> /// <param name="dto">传入角色信息</param> public void ModifyRole(RoleDto dto) { Role entity = _roleRepository.Get(SafeConvert.ToInt64(dto.Id)); entity.Name = dto.Name; _roleRepository.Update(entity); }
/// <summary> /// 修改权限 /// </summary> /// <param name="dto">传入权限信息</param> public void ModifyPermission(PermissionManage.PermissionDto dto) { Permission entity = _permissionRepository.Get(SafeConvert.ToInt64(dto.ParentId)); entity.MenuId = dto.MenuId; _permissionRepository.Update(entity); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="dto">传入菜单信息</param> public void ModifyMenu(MenuDto dto) { Menu entity = _menuRepository.Get(SafeConvert.ToInt64(dto.Id)); entity.Name = dto.Name; entity.Url = dto.Url; entity.Icon = dto.Icon; _menuRepository.Update(entity); }
/// <summary> /// 修改用户 /// </summary> /// <param name="dto">传入用户信息</param> public void ModifyUser(UserManage.UserDto dto) { User entity = _userRepository.Get(SafeConvert.ToInt64(dto.Id)); entity.Email = dto.Email; entity.RealName = dto.RealName; entity.Phone = dto.Phone; entity.RoleId = dto.RoleId; _userRepository.Update(entity); }
/// <summary> /// 分配权限 /// </summary> /// <param name="roleId"></param> /// <param name="permissionIds"></param> public void DistributePermission(long?roleId, long?[] permissionIds) { Role entity = _roleRepository.Get(SafeConvert.ToInt64(roleId)); var permissions = _permissionRepository.Table.Where(t => permissionIds.Contains(t.Id)); entity.Permissions.Clear(); entity.Permissions = permissions.ToList(); _roleRepository.Update(entity); //WriteOperateLog(LogType.信息, LogModule.权限管理, "角色[{0}]分配权限成功!", entity.RoleName); }
/// <summary> /// 删除角色 /// </summary> /// <param name="dto">传入角色信息</param> public void DeleteRole(RoleDto dto) { Role entity = _roleRepository.Get(SafeConvert.ToInt64(dto.Id)); _roleRepository.Delete(entity); }
/// <summary> /// 删除用户 /// </summary> /// <param name="dto">传入用户信息</param> public void DeleteUser(UserManage.UserDto dto) { User entity = _userRepository.Get(SafeConvert.ToInt64(dto.Id)); _userRepository.Delete(entity); }
public string createIPQC(RepairOrderRequest param) { DateTime now = SSGlobalConfig.Now; IList <CV_QM_REPAIR_ORDER> orderList = param.orderList; Dictionary <string, string> dict = new Dictionary <string, string>(); dict.Add("PN", "IPQC"); dict.Add("Y", now.ToString("yyyyMMdd")); string message = ""; //创建IPQC表单 using (TransactionScope ts = new TransactionScope()) { string ipqcSequence = createCode("IPQCRule", dict); QM_REPAIR_IPQC ipqc = new QM_REPAIR_IPQC() { TGuid = Guid.NewGuid(), Sequence = ipqcSequence, OrderID = orderList[0].OrderID, ReportLine = orderList[0].ReportLine, ReportWorkshop = orderList[0].ReportWorkshop, DefID = orderList[0].DefID, DefName = orderList[0].DefDescript, Status = "新建", CreatedBy = param.user, CreatedOn = now }; ipqcbo.Insert(ipqc); foreach (CV_QM_REPAIR_ORDER tmp in orderList) { QM_REPAIR_IPQC_DETAIL detail = new QM_REPAIR_IPQC_DETAIL() { TGuid = ipqc.TGuid, SN = tmp.AbnormalitySN, ReportID = tmp.ReportID, Result = tmp.Result, ReportTerminal = tmp.ReportTerminal, ProductDecision = tmp.ProductDecision, QualityDecision = tmp.QualityDecision }; ipqc_detailbo.Insert(detail); //修改SN状态为IPQC(7) string cmd_ipqcSql1 = string.Format(CultureInfo.InvariantCulture, ipqcSql1, 7, tmp.AbnormalitySN); alt_bscbo.ExecuteNonQueryBySql(cmd_ipqcSql1); } //创建预警信息 string cmd_altsql = string.Format(CultureInfo.InvariantCulture, ipqcAltSql, ipqc.DefID + ipqc.DefName, ipqc.OrderID, orderList[0].LineName, ipqcSequence); log.Info("createIPQC Sql : " + cmd_altsql); DataTable dt = alt_bscbo.GetDataTableBySql(cmd_altsql); if (dt.Rows.Count > 0) { //开始推送 PM_ALT_MESSAGE msg = alt_messagebo.GetEntity(SafeConvert.ToInt64(dt.Rows[0]["MsgPK"].ToString())); if (alt_bscbo.ExecuteNotify(msg)) { message = ipqcSequence; ts.Complete(); } else { message = "NG,推送失败,请重新提交.."; } } } return(message); }
/// <summary> /// 删除权限 /// </summary> /// <param name="dto">传入权限信息</param> public void DeletePermission(PermissionManage.PermissionDto dto) { Permission permission = _permissionRepository.Get(SafeConvert.ToInt64(dto.Id)); _permissionRepository.Delete(permission); }
/// <summary> /// 添加权限 /// </summary> /// <param name="dto">传入权限信息</param> public void AddPermission(PermissionManage.PermissionDto dto) { Permission parent = _permissionRepository.Get(SafeConvert.ToInt64(dto.ParentId)); //entity.Permission.Parent = parent; //_permissionExRepository.Add(entity); }
/// <summary> /// 删除菜单 /// </summary> /// <param name="dto">传入菜单信息</param> public void DeleteMenu(MenuDto dto) { Menu entity = _menuRepository.Get(SafeConvert.ToInt64(dto.Id)); _menuRepository.Delete(entity); }
public string addFirstCheck(AddFirstCheckRequest param) { string message = ""; Dictionary <string, string> dict = new Dictionary <string, string>(); dict.Add("PN", "SJ" + param.snOrderList[0].OrderID); DateTime now = SSGlobalConfig.Now; CV_QM_FIRSTCHECK_SN snOrder = param.snOrderList[0]; //先获得首检检验项 string SubBopID = null; if (snOrder.Step == "装配" || snOrder.Step == "检定" || snOrder.Step == "包装") { //查询step是否为包装或者装配,若是,则查询需加上subbopid SubBopID = snOrder.Step; } IList <CV_QM_PROCESSITEM> processItemList = _ICV_QM_PROCESSITEMBO.GetEntitiesByOrderID(snOrder.OrderID, "1", SubBopID);//首检InspectSource = 1 if (processItemList.Count() == 0) { message = "NG,无首检检验项信息"; } else { QM_PROCESS_TOP top = new QM_PROCESS_TOP() { Source = 1, SequenceStatus = "待检", SapOrderID = snOrder.SalesOrderID, //SAP订单 WorkOrderID = snOrder.OrderID, //MES工单 MinSampleSize = param.minSampleSize, //最小抽样数量 SampleQua = param.snOrderList.Count, //抽样数量 MaterielID = snOrder.DefID, //物料编码 MaterielVer = snOrder.DefVer, //物料版本 MaterielDescript = snOrder.DefDescript, //物料描述 PlantID = snOrder.PlanPlant, //工厂ID Plant = snOrder.PlantName, //工厂名称 Step = snOrder.Step, //工序 Workshop = snOrder.DepartID, //车间 LineID = snOrder.LineID, //产线ID ProdLine = snOrder.LineName, //产线名称 CreateBy = param.user, //创建者 CreateTime = now //创建时间 }; using (TransactionScope ts = new TransactionScope()) { top.Sequence = createCode("FirstInspectRule", dict);//首检单号 //创建首检单 _IQM_PROCESS_TOPBO.Insert(top); //获得刚创建的首检单 QM_PROCESS_TOP_QueryParam topParam = new QM_PROCESS_TOP_QueryParam() { Source = 1, Sequence = top.Sequence }; //查询KID top = _IQM_PROCESS_TOPBO.GetEntitiesByQueryParam(topParam)[0]; foreach (CV_QM_FIRSTCHECK_SN tmp in param.snOrderList) { QM_PROCESS_MIDDLE middle = new QM_PROCESS_MIDDLE() { KID = top.KID, Sequence = top.Sequence, SN = tmp.LotID, SNStatus = "待检" }; _IQM_PROCESS_MIDDLEBO.Insert(middle); } //查询KLID IList <QM_PROCESS_MIDDLE> middleList = _IQM_PROCESS_MIDDLEBO.GetByKid(top.KID.Value); //操作底表 foreach (QM_PROCESS_MIDDLE middleTmp in middleList) { foreach (CV_QM_PROCESSITEM item in processItemList) { QM_PROCESS_BOTTOM bottom = new QM_PROCESS_BOTTOM() { KLID = middleTmp.KLID, Sequence = middleTmp.Sequence, SN = middleTmp.SN, MaterielID = top.MaterielID, ItemIndex = item.InforDetailID, Item = item.InspectItemDes, ItemStatus = "待检", ItemProperty = item.InspectItemProperty.Equals("2") ? "定量" : "定性", }; if (!string.IsNullOrEmpty(item.TargetValue)) { bottom.Target = SafeConvert.ToDouble(item.TargetValue); } if (!string.IsNullOrEmpty(item.UpperLimit)) { bottom.UpperBound = SafeConvert.ToDouble(item.UpperLimit); } if (!string.IsNullOrEmpty(item.LowerLimit)) { bottom.LowerBound = SafeConvert.ToDouble(item.LowerLimit); } _IQM_PROCESS_BOTTOMBO.Insert(bottom); } } //创建预警信息 string cmd_altsql = string.Format(CultureInfo.InvariantCulture, firstAltSql, top.ProdLine, top.WorkOrderID, top.Sequence); DataTable dt = bscbo.GetDataTableBySql(cmd_altsql); if (dt.Rows.Count > 0) { //开始推送 PM_ALT_MESSAGE msg = alt_messagebo.GetEntity(SafeConvert.ToInt64(dt.Rows[0]["MsgPK"].ToString())); if (alt_bscbo.ExecuteNotify(msg)) { message = top.Sequence; ts.Complete(); } else { message = "NG,推送失败,请重新提交.."; } } } } return(message); }