public void SaveComponentType(Sender sender, ComponentType obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { ComponentType model = new ComponentType(); model.ComponentTypeID = obj.ComponentTypeID; if (op.LoadComponentType(model) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertComponentType(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateComponentTypeByComponentTypeID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveLocation(Sender sender, SaveLocationArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Location obj = new Location(); obj.LocationID = args.Location.LocationID; if (op.LoadLocationByLocationID(obj) == 0) { args.Location.Created = DateTime.Now; args.Location.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); args.Location.Modified = DateTime.Now; args.Location.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertLocation(args.Location); } else { args.Location.Modified = DateTime.Now; args.Location.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.UpdateLocationByLocationID(args.Location); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveOrderStep(Sender sender, OrderStep obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (op.LoadOrderStep(obj) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertOrderStep(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateOrderStepByStepID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveProductComponents(Sender sender, SaveProductComponentArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (args.ProductComponents != null) { foreach (ProductComponent Item in args.ProductComponents) { Item.Created = DateTime.Now; Item.CreatedBy = sender.UserCode + "." + sender.UserName; Item.Modified = DateTime.Now; Item.ModifiedBy = sender.UserCode + "." + sender.UserName; if (op.LoadProductComponent(Item) == 0) { op.InsertProductComponent(Item); } else { op.UpdateProductComponentByComponentID(Item); } } } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveOrderLog(Sender sender, SaveOrderLogArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { OrderLog obj = new OrderLog(); obj.LogID = args.OrderLog.LogID; if (op.LoadOrderLogByLogID(obj) == 0) { args.OrderLog.Created = DateTime.Now; args.OrderLog.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertOrderLog(args.OrderLog); } else { op.UpdateOrderLogByLogID(args.OrderLog); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveWorkingLine(Sender sender, SaveWorkingLineArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { WorkingLine obj = new WorkingLine(); obj.WorkingLineID = args.WorkingLine.WorkingLineID; if (op.LoadWorkingLineByWorkingLineID(obj) == 0) { args.WorkingLine.Created = DateTime.Now; args.WorkingLine.CreatedBy = sender.UserCode + "." + sender.UserName; args.WorkingLine.Modified = DateTime.Now; args.WorkingLine.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertWorkingLine(args.WorkingLine); } else { args.WorkingLine.Modified = DateTime.Now; args.WorkingLine.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateWorkingLineByWorkingLineID(args.WorkingLine); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveOrder2Hardware(Sender sender, SaveOrder2HardwareArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Order2Hardware obj = new Order2Hardware(); obj.ItemID = args.Order2Hardware.ItemID; if (op.LoadOrder2HardwareByItemID(obj) == 0) { op.InsertOrder2Hardware(args.Order2Hardware); } else { op.UpdateOrder2HardwareByItemID(args.Order2Hardware); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveWorkShift(Sender sender, SaveWorkShiftArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { WorkShift obj = new WorkShift(); obj.WorkShiftID = args.WorkShift.WorkShiftID; if (op.LoadWorkShiftByWorkShiftID(obj) == 0) { args.WorkShift.Created = DateTime.Now; args.WorkShift.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); args.WorkShift.Modified = DateTime.Now; args.WorkShift.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertWorkShift(args.WorkShift); } else { args.WorkShift.Modified = DateTime.Now; args.WorkShift.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.UpdateWorkShiftByWorkShiftID(args.WorkShift); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveReviewDetail(Sender sender, ReviewDetail obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (op.LoadReviewDetail(obj) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertReviewDetail(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateReviewDetailByTransID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveLogisticsEnterprise(Sender sender, SaveLogisticsEnterpriseArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { LogisticsEnterprise obj = new LogisticsEnterprise(); obj.EnterpriseID = args.LogisticsEnterprise.EnterpriseID; if (op.LoadLogisticsEnterpriseByEnterpriseID(obj) == 0) { args.LogisticsEnterprise.Created = DateTime.Now; args.LogisticsEnterprise.CreatedBy = sender.UserCode + "." + sender.UserName; args.LogisticsEnterprise.Modified = DateTime.Now; args.LogisticsEnterprise.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertLogisticsEnterprise(args.LogisticsEnterprise); } else { args.LogisticsEnterprise.Modified = DateTime.Now; args.LogisticsEnterprise.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateLogisticsEnterpriseByEnterpriseID(args.LogisticsEnterprise); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveRoomDesignerKJLRelation(Sender sender, SaveRoomDesignerKJLRelationArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { //string designID = args.RoomDesignerKJLRelation.KJLDesignID; if (op.LoadRoomDesignerKJLRelatioByDesignID(args.RoomDesignerKJLRelation) == 0) { args.RoomDesignerKJLRelation.ID = Guid.NewGuid(); args.RoomDesignerKJLRelation.Status = false; args.RoomDesignerKJLRelation.Created = DateTime.Now; args.RoomDesignerKJLRelation.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertRoomDesignerKJLRelation(args.RoomDesignerKJLRelation); } //else //{ // args.RoomDesignerKJLRelation.KJLDesignID = designID; // op.UpdateRoomDesignerKJLRelationByDesignID(args.RoomDesignerKJLRelation); //} op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveProductBOM(Sender sender, ProductBOM obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { ProductBOM model = new ProductBOM(); model.ID = obj.ID; if (op.LoadProductBOM(model) == 0) { string key = "BOM" + DateTime.Now.ToString("yy"); int index = this.GetIncrease(sender, key); obj.BOMID = key + DateTime.Now.Month.ToString("00") + index.ToString("00000"); obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertProductBOM(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateProductBOMByID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveOrderWorkFlow(Sender sender, SaveOrderWorkFlowArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { OrderWorkFlow obj = new OrderWorkFlow(); obj.WorkingID = args.OrderWorkFlow.WorkingID; if (op.LoadOrderWorkFlowByWorkingID(obj) == 0) { op.InsertOrderWorkFlow(args.OrderWorkFlow); } else { op.UpdateOrderWorkFlowByWorkingID(args.OrderWorkFlow); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveMaterial2Supplier(Sender sender, SaveMaterial2SupplierArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Material2Supplier obj = new Material2Supplier(); obj.MaterialID = args.Material2Supplier.MaterialID; obj.SupplierID = args.Material2Supplier.SupplierID; if (op.LoadMaterial2SupplierByMaterialID_SupplierID(obj) == 0) { op.InsertMaterial2Supplier(args.Material2Supplier); } else { op.UpdateMaterial2SupplierByMaterialID_SupplierID(args.Material2Supplier); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveWorkFlow(Sender sender, WorkFlow obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { WorkFlow model = new WorkFlow(); model.WorkFlowID = obj.WorkFlowID; if (op.LoadWorkFlow(model) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertWorkFlow(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateWorkFlowByWorkFlowID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveOrderScheduling(Sender sender, SaveOrderSchedulingArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { OrderScheduling obj = new OrderScheduling(); obj.MadeID = args.OrderScheduling.MadeID; if (op.LoadOrderSchedulingByMadeID(obj) == 0) { args.OrderScheduling.Created = DateTime.Now; args.OrderScheduling.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); args.OrderScheduling.Modified = DateTime.Now; args.OrderScheduling.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertOrderScheduling(args.OrderScheduling); } else { args.OrderScheduling.Modified = DateTime.Now; args.OrderScheduling.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.UpdateOrderSchedulingByMadeID(args.OrderScheduling); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveComponentMaterialExtension(Sender sender, ComponentMaterialExtension obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (op.LoadComponentMaterialExtension(obj) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertComponentMaterialExtension(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateComponentMaterialExtensionByID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void DeleteUserGroup(Sender sender, Guid groupID) { try { using (ObjectProxy op = new ObjectProxy(true)) { //删除用户组下面的角色用户; List <Role> roles = op.LoadRolesByGroupID(groupID); foreach (Role role in roles) { op.DeleteUser2RolesByRoleID(role.RoleID); } //删除用户组下的角色 op.DeleteRolesByGroupID(groupID); //删除用户组 op.DeleteUserGroupByGroupID(groupID); op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveSolutionOthers(Sender sender, SaveSolutionOthersArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { SolutionOthers obj = new SolutionOthers(); obj.DetailID = args.SolutionOthers.DetailID; if (op.LoadSolutionOthersByDetailID(obj) == 0) { op.InsertSolutionOthers(args.SolutionOthers); } else { op.UpdateSolutionOthersByDetailID(args.SolutionOthers); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveCategory(Sender sender, SaveCategoryArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Category obj = new Category(); obj.CategoryID = args.Category.CategoryID; if (op.LoadCategoryByCategoryID(obj) == 0) { args.Category.Created = DateTime.Now; args.Category.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); args.Category.Modified = DateTime.Now; args.Category.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertCategory(args.Category); } else { args.Category.Modified = DateTime.Now; args.Category.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.UpdateCategoryByCategoryID(args.Category); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveProductComponent(Sender sender, ProductComponent obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (op.LoadProductComponent(obj) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; obj.Modified = DateTime.Now; obj.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertProductComponent(obj); } else { obj.Modified = DateTime.Now; obj.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateProductComponentByComponentID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveCar(Sender sender, SaveCarArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Car obj = new Car(); obj.CarID = args.Car.CarID; if (op.LoadCarByCarID(obj) == 0) { args.Car.Created = DateTime.Now; args.Car.CreatedBy = sender.UserCode + "." + sender.UserName; args.Car.Modified = DateTime.Now; args.Car.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertCar(args.Car); } else { args.Car.Modified = DateTime.Now; args.Car.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateCarByCarID(args.Car); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveSolutionFile(Sender sender, SaveSolutionFileArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { SolutionFile obj = new SolutionFile(); obj.FileID = args.SolutionFile.FileID; if (op.LoadSolutionFileByFileID(obj) == 0) { args.SolutionFile.Created = DateTime.Now; args.SolutionFile.CreatedBy = sender.UserCode + "." + sender.UserName; args.SolutionFile.Modified = DateTime.Now; args.SolutionFile.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertSolutionFile(args.SolutionFile); } else { args.SolutionFile.Created = DateTime.Now; args.SolutionFile.CreatedBy = sender.UserCode + "." + sender.UserName; args.SolutionFile.Modified = DateTime.Now; args.SolutionFile.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateSolutionFileByFileID(args.SolutionFile); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveMaterialQuotePrice(Sender sender, SaveMaterialQuotePriceArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { MaterialQuotePrice obj = new MaterialQuotePrice(); obj.MaterialID = args.MaterialQuotePrice.MaterialID; if (op.LoadMaterialQuotePriceByMaterialID(obj) == 0) { op.InsertMaterialQuotePrice(args.MaterialQuotePrice); } else { op.UpdateMaterialQuotePriceByMaterialID(args.MaterialQuotePrice); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveCustomerTransDetail(Sender sender, SaveCustomerTransDetailArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { CustomerTransDetail obj = new CustomerTransDetail(); obj.TransID = args.CustomerTransDetail.TransID; if (op.LoadCustomerTransDetailByTransID(obj) == 0) { args.CustomerTransDetail.Created = DateTime.Now; args.CustomerTransDetail.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertCustomerTransDetail(args.CustomerTransDetail); } else { op.UpdateCustomerTransDetailByTransID(args.CustomerTransDetail); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveNotice(Sender sender, SaveNoticeArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Notice obj = new Notice(); obj.NoticeID = args.Notice.NoticeID; if (op.LoadNoticeByNoticeID(obj) == 0) { args.Notice.Created = DateTime.Now; args.Notice.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertNotice(args.Notice); } else { op.UpdateNoticeByNoticeID(args.Notice); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveSolution2Hardware(Sender sender, Solution2Hardware item) { try { using (ObjectProxy op = new ObjectProxy(true)) { Solution2Hardware obj = new Solution2Hardware(); obj.CabinetID = item.CabinetID; if (op.LoadSolution2HardwareByItemID(obj) == 0) { item.Created = DateTime.Now; item.CreatedBy = sender.UserCode + "." + sender.UserName; item.Modified = DateTime.Now; item.ModifiedBy = sender.UserCode + "." + sender.UserName; op.InsertSolution2Hardware(item); } else { item.Modified = DateTime.Now; item.ModifiedBy = sender.UserCode + "." + sender.UserName; op.UpdateSolution2HardwareByItemID(item); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveKeyValue(Sender sender, KeyValue kv) { try { using (ObjectProxy op = new ObjectProxy(true)) { KeyValue tmp = new KeyValue(); tmp.Key = kv.Key; if (op.LoadKeyValueByKey(tmp) == 0) { tmp = null; } if (tmp == null) { op.InsertKeyValue(kv); } else { op.UpdateKeyValueByKey(kv); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveSupplier(Sender sender, SaveSupplierArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { Supplier obj = new Supplier(); obj.SupplierID = args.Supplier.SupplierID; if (op.LoadSupplierBySupplierID(obj) == 0) { args.Supplier.Created = DateTime.Now; args.Supplier.CreatedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); args.Supplier.Modified = DateTime.Now; args.Supplier.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.InsertSupplier(args.Supplier); } else { args.Supplier.Modified = DateTime.Now; args.Supplier.ModifiedBy = string.Format("{0}.{1}", sender.UserCode, sender.UserName); op.UpdateSupplierBySupplierID(args.Supplier); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public void SaveWorkOrders(Sender sender, SaveWorkOrderArgs args) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (args.WorkOrders != null) { foreach (WorkOrder Item in args.WorkOrders) { string key = "W" + DateTime.Now.ToString("yy"); int index = this.GetIncrease(sender, key); Item.WorkOrderNo = key + DateTime.Now.Month.ToString("00") + index.ToString("00000"); Item.Created = DateTime.Now; Item.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertWorkOrder(Item); } } if (args.ProductionOrder != null) { op.UpdateProductionOrderByProductionID(args.ProductionOrder); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }