DEV XPO对比之UOW_producer xp-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_16215957/article/details/124919934

本文介绍了如何使用DevExpress的XPO框架创建和操作一个名为XYZ_Producer的业务对象，涉及属性定义、权限控制和数据库操作。展示了如何实例化对象、设置属性并进行CRUD操作，包括保存和连接管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Producer XPObject：

using DevExpress.Data.Filtering;
//using DevExpress.Utils.Base;
using DevExpress.Xpo;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using DevExpress.Persistent.BaseImpl;
using DevExpress.Persistent.BaseImpl.PermissionPolicy;

namespace XYZ.Module.BusinessObjects
{
    //[ImageName("BO_Contact")]
    //[DefaultProperty("DisplayMemberNameForLookupEditorsOfThisType")]
    //[DefaultListViewOptions(MasterDetailMode.ListViewOnly, false, NewItemRowPosition.None)]
    //[Persistent("DatabaseTableName")]
    // Specify more UI options using a declarative approach (https://documentation.devexpress.com/#eXpressAppFramework/CustomDocument112701).
    public class XYZ_Producer : BaseObject
    { // Inherit from a different class to provide a custom primary key, concurrency and deletion behavior, etc. (https://documentation.devexpress.com/eXpressAppFramework/CustomDocument113146.aspx).
        // Use CodeRush to create XPO classes and properties with a few keystrokes.
        // https://docs.devexpress.com/CodeRushForRoslyn/118557
        public XYZ_Producer(Session session)
            : base(session)
        {
        }
        PermissionPolicyUser GetCurrentUser()
        {
            PermissionPolicyUser user = null;

            try
            {
                //return Session.GetObjectByKey<PermissionPolicyUser>(SecuritySystem.CurrentUserId);  // In XAF apps for versions older than v20.1.7.
                user = Session.FindObject<PermissionPolicyUser>(CriteriaOperator.Parse("Oid=CurrentUserId()"));
            }
            catch (Exception ex)
            {
            }
            return user;  // In non-XAF apps where SecuritySystem.Instance is unavailable (v20.1.7+).
        }
        public override void AfterConstruction()
        {
            base.AfterConstruction();
            CreatedOn = DateTime.Now;
            CreatedBy = GetCurrentUser();
        }
        protected override void OnSaving()
        {
            base.OnSaving();
            UpdatedOn = DateTime.Now;
            UpdatedBy = GetCurrentUser();
        }
        //private string _PersistentProperty;
        //[XafDisplayName("My display name"), ToolTip("My hint message")]
        //[ModelDefault("EditMask", "(000)-00"), Index(0), VisibleInListView(false)]
        //[Persistent("DatabaseColumnName"), RuleRequiredField(DefaultContexts.Save)]
        //public string PersistentProperty {
        //    get { return _PersistentProperty; }
        //    set { SetPropertyValue(nameof(PersistentProperty), ref _PersistentProperty, value); }
        //}

        //[Action(Caption = "My UI Action", ConfirmationMessage = "Are you sure?", ImageName = "Attention", AutoCommit = true)]
        //public void ActionMethod() {
        //    // Trigger a custom business logic for the current record in the UI (https://documentation.devexpress.com/eXpressAppFramework/CustomDocument112619.aspx).
        //    this.PersistentProperty = "Paid";
        //}
        string fCode;
        [Size(255)]
        //[XafDisplayName("编码")]
        public string Code
        {
            get { return fCode; }
            set { SetPropertyValue<string>(nameof(Code), ref fCode, value); }
        }
        string fName;
        [Size(255)]
        //[XafDisplayName("名称")]
        public string Name
        {
            get { return fName; }
            set { SetPropertyValue<string>(nameof(Name), ref fName, value); }
        }
        string fAddress;
        [Size(255)]
        //[XafDisplayName("名称")]
        public string Address
        {
            get { return fAddress; }
            set { SetPropertyValue<string>(nameof(Address), ref fAddress, value); }
        }
        string fLegalRepresentative;
        [Size(255)]
        //[XafDisplayName("负责人")]
        //[ModelDefault("AllowEdit", "True")]
        public string LegalRepresentative
        {
            get { return fLegalRepresentative; }
            set { SetPropertyValue<string>(nameof(LegalRepresentative), ref fLegalRepresentative, value); }
        }
        string fContact;
        [Size(255)]
        //[XafDisplayName("负责人")]
        //[ModelDefault("AllowEdit", "True")]
        public string Contact
        {
            get { return fContact; }
            set { SetPropertyValue<string>(nameof(Contact), ref fContact, value); }
        }
        private string _Phone;
        //[XafDisplayName("电话")]
        public string Phone
        {
            get
            {
                return _Phone;
            }
            set
            {
                SetPropertyValue("Phone", ref _Phone, value);
            }
        }
        string fRemark;
        [Size(255)]
        //[XafDisplayName("备注")]
        public string Remark
        {
            get { return fRemark; }
            set { SetPropertyValue<string>(nameof(Remark), ref fRemark, value); }
        }
        PermissionPolicyUser createdBy;
        //[ModelDefault("AllowEdit", "False")]
        public PermissionPolicyUser CreatedBy
        {
            get { return createdBy; }
            set { SetPropertyValue("CreatedBy", ref createdBy, value); }
        }
        DateTime createdOn;
        //[ModelDefault("AllowEdit", "False"), ModelDefault("DisplayFormat", "G")]
        public DateTime CreatedOn
        {
            get { return createdOn; }
            set { SetPropertyValue("CreatedOn", ref createdOn, value); }
        }
        PermissionPolicyUser updatedBy;
        //[ModelDefault("AllowEdit", "False")]
        public PermissionPolicyUser UpdatedBy
        {
            get { return updatedBy; }
            set { SetPropertyValue("UpdatedBy", ref updatedBy, value); }
        }
        DateTime updatedOn;
        //[ModelDefault("AllowEdit", "False"), ModelDefault("DisplayFormat", "G")]
        public DateTime UpdatedOn
        {
            get { return updatedOn; }
            set { SetPropertyValue("UpdatedOn", ref updatedOn, value); }
        }
    }
}

调用：

string connectionString;
IDataLayer dataLayer = null;
UnitOfWork uow = null;

private void tESTUOWToolStripMenuItem_Click(object sender, EventArgs e)
{
	KeepUOWConnect();

	XYZ_Producer producer = new XYZ_Producer(uow);

	producer.Name = "";

	producer.Contact = "david";

	producer.Save();

	uow.CommitChanges();
}

public void KeepUOWConnect()
{
	try
	{
		if (uow == null)
		{
			logHelper.InfoOnce($"数据库连接为空！");
			if (connectionString == null)
				connectionString = ConfigurationManager.ConnectionStrings["ConnectionString_XYZData"].ConnectionString;
			if (dataLayer == null)
				dataLayer = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
			logHelper.InfoOnce($"数据库已连接！");
			uow = new UnitOfWork(dataLayer);
		}
	}
	catch (Exception ex)
	{
		logHelper.ErrorOnce($"数据库连接失败！{Environment.NewLine}Error Message:{Environment.NewLine}{ex.Message}{Environment.NewLine}StackTrace:{Environment.NewLine}{ex.StackTrace}");
	}
	finally
	{

	}
}

/// <summary>
/// 
/// </summary>
public void ReleaseUOWConnect()
{
	try
	{
		if (uow != null)
		{
			uow.Disconnect();
			uow.Dispose();
			if (dataLayer != null)
			{
				dataLayer.Dispose();
			}
            dataLayer = null;
            uow = null;
		}
	}
	catch (Exception ex)
	{
		logHelper.ErrorOnce($"释放数据库连接失败！{Environment.NewLine}Error Message:{Environment.NewLine}{ex.Message}{Environment.NewLine}StackTrace:{Environment.NewLine}{ex.StackTrace}");
	}
	finally
	{

	}
}