CSFrameworkV6旗舰版 | 主从子表（多级明细表）设计方案|C/S开发框架

    public partial class frmPN : frmBaseBusinessForm
    {
        private bllPN _BLL;

        public frmPN()
        {
            InitializeComponent();
        }

        private void frmtb_PN_Load(object sender, EventArgs e)
        {
            this.InitializeForm();
        }

        //省略代码.....
    }

/// <summary>
/// 主从子表（三层表或多明细表）建议使用独立的类，不需要继承bll基类。
/// </summary>
public class bllPN
{
    private IBridge_PN _Bridge;

    /// <summary>
    /// 构造器
    /// </summary>
    public bllPN()
    {
        _Bridge = this.CreateBridge();
    }

    /// <summary>
    /// 当前实体数据
    /// </summary>
    public BusinessData_PN CurrentBusiness { get; set; }

    /// <summary>
    /// 主表数据
    /// </summary>
    public tb_PN DataBinder => this.CurrentBusiness.Master;

    /// <summary>
    /// 创建策略接口实例
    /// </summary>
    /// <returns></returns>
    private IBridge_PN CreateBridge()
    {
        if (BridgeFactory.IsADODirect)
            return new dalPN(Core.Loginer.CurrentUser);

        if (BridgeFactory.IsWebApi)
            return new WebApi_PN();

        throw new Exception(BridgeFactory.UNKNOW_BRIDGE_TYPE);
    }

    //省略代码......

}

    /// <summary>
    /// PN工艺单：主从子表复合模型
    /// </summary>
    public class BusinessData_PN
    {
        public BusinessData_PN()
        {
            this.Master = new tb_PN();
            this.DetailsA = new List<tb_PNDtlA>();
            this.DetailsASub = new List<tb_PNDtlASub>();
            this.DetailsB = new List<tb_PNDtlB>();
        }

        /// <summary>
        /// 主表数据
        /// </summary>
        public tb_PN Master { get; set; }

        /// <summary>
        /// 第1个明细表
        /// </summary>
        public List<tb_PNDtlA> DetailsA { get; set; }

        /// <summary>
        /// 第2个明细表
        /// </summary>
        public List<tb_PNDtlB> DetailsB { get; set; }

        /// <summary>
        /// 三级表
        /// </summary>
        public List<tb_PNDtlASub> DetailsASub { get; set; }

    }

        public BusinessData_PN GetDataByKey(string docNo)
        {
            var data = new BusinessData_PN();

            var q_PN = _Database.GetQueryable<tb_PN>();
            var q_PNDtlA = _Database.GetQueryable<tb_PNDtlA>();
            var q_PNDtlB = _Database.GetQueryable<tb_PNDtlB>();
            var q_PNDtlASub = _Database.GetQueryable<tb_PNDtlASub>();

            data.Master = q_PN.Where(w => w.PNNO == docNo).FirstOrDefault();
            data.DetailsA = q_PNDtlA.Where(w => w.PNNO == data.Master.PNNO).ToList();
            data.DetailsASub = q_PNDtlASub.Where(w => w.PNNO == data.Master.PNNO).ToList();
            data.DetailsB = q_PNDtlB.Where(w => w.PNNO == data.Master.PNNO).ToList();

            return data;
        }