LLBL Gen 基本代码操作

ParameterBase.CurrentUser.UserIdStringEnum<Ciphis.Enums.AccClass>.GetStringValue(Ciphis.Enums.AccClass.Vendor)//创建Manager     ICustomerDeskDetailManager customerDeskDetailManager = ClientProxyFactory.CreateProxyInstance<ICustomerDeskDetailManager>();//过滤条件    IRelationPredicateBucket bucket = new RelationPredicateBucket();    bucket.PredicateExpression.Add(CustomerDeskDetailFields.DeskName == list[0].SysDeskName);//在得到的EntityCollection中搜索相关数据    List<int> ids = customerDeskDetails.FindMatches(CustomerDeskDetailFields.TableName == item.TableName);//关联查找    IPrefetchPath2 prefetchPath = new PrefetchPath2((int)EntityType.PurchaseOrderEntity);    IPrefetchPathElement2 element = prefetchPath.Add(PurchaseOrderEntity.PrefetchPathPurchaseOrderDetails);    element.SubPath.Add(PurchaseOrderDetailEntity.PrefetchPathPurchaseOrderBomDetails);//添加排序条件    ISortExpression sortExpression = new SortExpression();    sortExpression.Add(CustomerDeskFields.SortNo | SortOperator.Ascending);//添加关联关系    bucket.Relations.Add(InventoryMovementEntity.Relations.InventoryMovementDetailEntityUsingRefNo);//系统有外键，直接调用    bucket.Relations.Add(new EntityRelation(ItemFields.ItemNo, InventoryMovementDetailFields.ItemNo, RelationType.OneToMany), JoinHint.Left);//系统无外键，通过这种方式创建；JoinHint与写的顺序相反//别名关联        bucket.Relations.Add(new EntityRelation(LocationFields.Loc,JobOrderMaterialPickFields.LocFrom, RelationType.OneToMany),"LocFrom", JoinHint.Left);//主实体必须放在后面//多建关联    IEntityRelation mulKeyRelation = new EntityRelation(JobOrderMaterialPickDetailFields.SourceRefNo, PurchaseOrderDetailFields.OrderNo, RelationType.ManyToOne);    mulKeyRelation.AddEntityFieldPair(JobOrderMaterialPickDetailFields.SourceEntryNo, PurchaseOrderDetailFields.EntryNo);    bucket.Relations.Add(mulKeyRelation, JoinHint.Right);//系统无外键，通过这种方式创建//复杂的公式    DbFunctionCall dbFunQtyReceipt = new DbFunctionCall("ISNULL", new object[] { (PurchaseReceiptsDetailFields.QtyReceipt), 0 });    DbFunctionCall dbFunQtyCosting = new DbFunctionCall("ISNULL", new object[] { (PurchaseReceiptsDetailFields.QtyCosting), 0 });    EntityField2 eQtyReceipt = new EntityField2("QtyReceipt", dbFunQtyReceipt);    EntityField2 eQtyCosting = new EntityField2("QtyCosting", dbFunQtyCosting);    bucketInspection.PredicateExpression.Add(new FieldCompareExpressionPredicate(eQtyReceipt, null, ComparisonOperator.GreaterThan, new Expression(eQtyCosting)));//保存时不验证    entity.Validator = null;    adapter.SaveEntity(entity, true, false);//创建对象IRelationPredicateBucket bucket = e.Argument as IRelationPredicateBucket;//读取哪些列     ExcludeIncludeFieldsList fields = new ExcludeIncludeFieldsList(false);            fields.Add(FiscalPeriodFields.EndDate);//添加需要读取的字段【！！必须按顺序，必须数量等于条数】ResultsetFields fields = new ResultsetFields(4);fields.DefineField(InventoryMovementFields.RefNo, 0);fields.DefineField(InventoryMovementFields.LocFrom, 1);fields.DefineField(ProductionInspectionFields.JobNo, 3, "InspectionJobNo");//关联表的数据，以及创建别名//添加Where条件bucket.PredicateExpression.Add(InventoryMovementFields.SourceType ==     StringEnum<Ciphis.Enums.TransactionType>.GetStringValue(Ciphis.Enums.TransactionType.ProductionInspection));//判断是否为空bucket.PredicateExpression.Add(JobOrderMaterialPickDetailFields.SourceEntryNo == DBNull.Value);//获取IUserDefinedQueryManager userDefinedQueryManager = ClientProxyFactory.CreateProxyInstance<IUserDefinedQueryManager>();_productionIssueTable = userDefinedQueryManager.GetQueryResult(fields, bucket, sortExpression, null, true, 0, false);//直接删除 Delete From A WhereIRelationPredicateBucket bucket = new RelationPredicateBucket((CustomerFields.CustomerID == "FISSA"));DataAccessAdapter adapter = new DataAccessAdapter();adapter.DeleteEntitiesDirectly("CustomerEntity", bucket);//事务    using (DataAccessAdapterBase adapter = GetCompanyDataAccessAdapter())    {        try{            adapter.StartTransaction(IsolationLevel.ReadCommitted, "SalesShipmentImportOrder");            使用LLBL基本的语句写            adapter.Commit();        }        catch                {                    adapter.Rollback();                    throw;                }//直接更新 Update A set Where    var ShipmentImportTmpChangedEntity = new ShipmentImportTmpEntity();    ShipmentImportTmpChangedEntity.TransactionType = "FeedBack";//直接赋值    ShipmentImportTmpChangedEntity.Fields[(int)ShipmentImportTmpFieldIndex.TransactionType].ExpressionToApply =         new Expression(ShipmentImportTmpFields.PaymentType);//等于另外一个字段    ShipmentImportTmpChangedEntity.Fields[(int)ShipmentImportTmpFieldIndex.TransactionType].ExpressionToApply =        (ShipmentImportTmpFields.PaymentType + ShipmentImportTmpFields.TransactionType);//等于表达式    IRelationPredicateBucket bucket2 = new RelationPredicateBucket();    bucket2.PredicateExpression.Add(ShipmentImportTmpFields.PaymentType == "Amazon fees");    adapter.UpdateEntitiesDirectly(ShipmentImportTmpChangedEntity, bucket2);//实际应该把其他的值设置为false，防止同时更新，然后使用currentValue赋值，防止发生连带赋值 InventoryMovementDetailEntity updateMovDetails = new InventoryMovementDetailEntity();                    foreach (IEntityField2 field in updateMovDetails.Fields) { field.IsChanged = false; }                    updateMovDetails.Fields[(int)InventoryMovementDetailFieldIndex.CreatedDate].CurrentValue = DateTime.Now;                    adapter.UpdateEntitiesDirectly(updateMovDetails, bucket);//复杂代码            IRelationPredicateBucket bucket = new RelationPredicateBucket();            Foundation.HelperClasses.ResultsetFields fields = new Foundation.HelperClasses.ResultsetFields(2);            DbFunctionCall dbFunQtyOnHand = new DbFunctionCall("isnull({0},0) - isnull({1},0)",                new object[] { (InventoryBalanceFields.QtyOnHand), (InventoryBalanceFields.QtyReserved) });            EntityField2 eQtyBalance = new EntityField2("QtyBalance", dbFunQtyOnHand);            fields.DefineField(eQtyBalance, 0);            fields[0].SetAggregateFunction(AggregateFunction.Sum);            fields.DefineField(InventoryBalanceFields.ItemNo, 1);            ISortExpression sortExpression = new SortExpression();            IUserDefinedQueryManager userDefinedQueryManager = ClientProxyFactory.CreateProxyInstance<IUserDefinedQueryManager>();            IGroupByCollection groupByCollection = new GroupByCollection();            groupByCollection.Add(fields[1]);            DataTable table = userDefinedQueryManager.GetQueryResult(fields, bucket, sortExpression, groupByCollection, true, 0, false);            table.PrimaryKey = new DataColumn[] { table.Columns[InventoryBalanceFields.ItemNo.Name] };            return table;