GZFramwork数据库层《三》普通主从表增删改查

2022-10-27 19:50:45

运行结果：

使用代码生成器（GZCodeGenerate）生成tb_Cusomer和tb_CusomerDetail的Model

生成方式见第一节：

GZFramwork数据库层《一》普通表增删改查

生成明细表ORM略有不同：

项目附加结果：

新增一个自定义控件：ucTableMD

界面：

后台代码：

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Data;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using GZFramworkDB.Model;

using GZFramworkDB.BLL;

namespace GZFramworkDB.Main.MyControls

{

    public partial class ucTableMD : UserControl, IData

    {

        public bllBusiness bll;

        protected DataTable dtMain;

        protected DataTable dtDetail;

        FormStatus Status;

        public ucTableMD()

        {

            InitializeComponent();

            Status = FormStatus.View;

            bll = new bllBusiness(typeof(tb_Customer), typeof(tb_CustomerDetail));

            gv_Summary.FocusedRowChanged += gv_Summary_FocusedRowChanged;

            this.gv_Detail.InitNewRow += new DevExpress.XtraGrid.Views.Grid.InitNewRowEventHandler(this.gv_Detail_InitNewRow);

        }

        void gv_Summary_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)

        {

            if (gv_Summary.FocusedRowHandle < )

            {

                gc_Detail.DataSource = null;

                return;

            }

            string Key = gv_Summary.GetFocusedDataRow()[bll.RelationKey].ToString();

            if (Status == FormStatus.Add)

            {

                dtDetail.DefaultView.RowFilter = String.Format("{0}='{1}'", tb_CustomerDetail.CustomerCode, Key);

                gc_Detail.DataSource = dtDetail;

            }

            else

            {

                DataSet ds = bll.GetDetailData(Key);

                gc_Detail.DataSource = ds.Tables[].Copy();

            }

        }

        //明细表新增行的时候

        private void gv_Detail_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)

        {

            string CustomerCode = gv_Summary.GetFocusedRowCellValue(tb_Customer.CustomerCode).ToString();

            gv_Detail.SetRowCellValue(e.RowHandle, tb_Customer.CustomerCode, CustomerCode);

        }

        public void DoSearch()

        {

            gc_Summary.DataSource = null;

            gc_Detail.DataSource = null;

            if (dtMain != null)

                dtMain.Rows.Clear();

            if (dtDetail != null)

                dtDetail.Rows.Clear();

            dtMain = bll.GetSummaryData();

            dtDetail = bll.GetDetailData("").Tables[];

            gc_Summary.DataSource = dtMain;

            gc_Detail.DataSource = dtDetail;

            Status = FormStatus.View;

        }

        public void DoAdd()

        {

            gc_Summary.DataSource = null;

            gc_Detail.DataSource = null;

            if (Status == FormStatus.View)

            {

                if (dtMain != null)

                    dtMain.Rows.Clear();

                if (dtDetail != null)

                    dtDetail.Rows.Clear();

                Status = FormStatus.Add;

            }

            dtMain.Rows.Add();

            gc_Summary.DataSource = dtMain;

            gc_Detail.DataSource = dtDetail;

        }

        public void DoDeleteKey()

        {

            string Key = gv_Summary.GetFocusedDataRow()[bll.SummaryKey].ToString();

            bll.Delete(Key);

            foreach (DataRow dr in dtDetail.Select(String.Format("{0}='{1}'", tb_CustomerDetail.CustomerCode, Key)))

            {

                dr.Delete();

            }

            gv_Summary.DeleteSelectedRows();

            dtDetail.AcceptChanges();

            dtMain.AcceptChanges();

        }

        public void DoDeleteTable()

        {

            string Key = gv_Summary.GetFocusedDataRow()[bll.SummaryKey].ToString();

            foreach (DataRow dr in dtDetail.Select(String.Format("{0}='{1}'", tb_CustomerDetail.CustomerCode, Key)))

            {

                dr.Delete();

            }

            gv_Summary.DeleteSelectedRows();

        }

        public void DoUpdate()

        {

            DataSet ds = new DataSet();

            ds.Tables.Add(dtMain.Copy());

            ds.Tables.Add(dtDetail.Copy());

            if (bll.Update(ds))

            {

                MessageBox.Show("更新成功！");

                return;

            }

            ds.Tables.Clear();

            dtDetail.AcceptChanges();

            dtMain.AcceptChanges();

            Status = FormStatus.View;

        }

    }

    public enum FormStatus

    {

        Add,

        View

    }

}