GroupBy/04-程式設計/Trunk/Tool/GroupBuyExportImport/ExportAndImport.cs

using OT.COM.ArsenalDB;
using SoldierData.EnterprizeV4;
using System;
using System.Linq;

namespace CounsellorBL
{
    public class ExportAndImport
    {
        ExportAndImportUtility UT = new ExportAndImportUtility
        (
            i_sExportPath: @"E:\GroupBuy Export Json String",
            i_sImportPath: ""
        );

        public void Export()
        {
            try
            {
                ExportProcess("7a190d74-deb3-4c58-8cf1-21906131c6e6");// 測試團購
            }
            catch(Exception ex)
            {
                ex.ToString().PrintLine();
            }
        }

        private void ExportProcess(string i_s_tb_grp_group_uid)
        {
            var tb_grp_groups = UT.GetTableEntity<tb_grp_group>(
                new WhereNode(tb_grp_group.CN_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_grp_group), i_s_tb_grp_group_uid)
            );

            var tb_grp_group_uid = tb_grp_groups.First().uid;
            var tb_grp_group_id = tb_grp_groups.First().fb_group_id;

            ProcessGroup2User(tb_grp_group_uid);
            ProcessBranch(tb_grp_group_uid);
            ProcessArticle(tb_grp_group_uid);
            ProcessCheckoutListMaster(tb_grp_group_uid);
            ProcessMember(tb_grp_group_id);
        }
        
        private void ProcessGroup2User (string i_s_tb_grp_groups_uid)
        {
            UT.GetTableEntity<tb_grp_group2user>(
                new WhereNode(tb_grp_group2user.CN_GROUP_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_grp_group2user), i_s_tb_grp_groups_uid)
            ); 
        }

        private void ProcessBranch(string i_s_tb_grp_groups_uid)
        {
            var tb_grp_branchs = UT.GetTableEntity<tb_grp_branch>(
                new WhereNode(tb_grp_branch.CN_GROUP_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_grp_branch), i_s_tb_grp_groups_uid)
            );
            
            foreach(var branch in tb_grp_branchs)
            {
                UT.GetTableEntity<tb_hr_employee2branch>(
                    new WhereNode(tb_hr_employee2branch.CN_BRANCH_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_hr_employee2branch), branch.uid)
                );
            }
        }

        private void ProcessMember(string i_s_tb_grp_group_id_)
        {
            var tb_meb_members = UT.GetTableEntity<tb_meb_member>(
                new WhereNode(tb_meb_member.CN_GROUP_ID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_meb_member), i_s_tb_grp_group_id_)
            );
            
            foreach (var member in tb_meb_members)
            {
                UT.GetTableEntity<tb_meb_shopping_points_record>(
                    new WhereNode(tb_meb_shopping_points_record.CN_MEMBER_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_meb_shopping_points_record), member.uid)
                );
            }
        }

        private void ProcessCheckoutListMaster(string i_s_tb_grp_groups_uid)
        {
            var checkoutMasters = UT.GetTableEntity<tb_ord_checkout_list_master>(
                new WhereNode(tb_ord_checkout_list_master.CN_GROUP_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_checkout_list_master), i_s_tb_grp_groups_uid)
                );

            foreach(var checkoutMaster in checkoutMasters)
            {
                UT.GetTableEntity<tb_ord_checkout_list_detail>(
                    new WhereNode(tb_ord_checkout_list_detail.CN_MEMBER_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_checkout_list_detail), checkoutMaster.uid)
                );
            }
        }

        private void ProcessArticle(string i_s_tb_grp_groups_uid)
        {
            var tb_grp_articles = UT.GetTableEntity<tb_grp_article>(
                new WhereNode(tb_grp_article.CN_GROUP_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_grp_article), i_s_tb_grp_groups_uid)
            );

            foreach (var tb_grp_article in tb_grp_articles)
            {
                var tb_grp_article_medias = UT.GetTableEntity<tb_grp_article_media>(
                    new WhereNode(tb_grp_article_media.CN_ARTICLE_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_grp_article_media), tb_grp_article.uid)
                );
                var tb_ord_order_masters = UT.GetTableEntity<tb_ord_order_master>(
                    new WhereNode(tb_ord_order_master.CN_ARTICLE_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_order_master), tb_grp_article.uid)
                );

                foreach (var orderMaster in tb_ord_order_masters)
                {
                    UT.GetTableEntity<tb_ord_incoming_return_record>(
                        new WhereNode(tb_ord_incoming_return_record.CN_ORDER_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_incoming_return_record), orderMaster.uid)
                    );

                    UT.GetTableEntity<tb_prd_article2product>(
                        new WhereNode(tb_prd_article2product.CN_ORDER_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_prd_article2product), orderMaster.uid)
                    );

                    var tb_ord_order_details = UT.GetTableEntity<tb_ord_order_detail>(
                        new WhereNode(tb_ord_order_detail.CN_ORDER_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_order_detail), orderMaster.uid)
                    );

                    foreach (var orderDetail in tb_ord_order_details)
                    {                        
                        var tb_ord_purchase_details = UT.GetTableEntity<tb_ord_purchase_detail>(
                            new WhereNode(tb_ord_purchase_detail.CN_ORDER_DETAIL_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_purchase_detail), orderDetail.uid)
                        );

                        foreach (var purchaseDetail in tb_ord_purchase_details)
                        {
                            var tb_ord_purchases = UT.GetTableEntity<tb_ord_purchase>(
                                new WhereNode(tb_ord_purchase.CN_UID, WhereNode.EColumnOperation.EOT_EQ, typeof(tb_ord_purchase), purchaseDetail.uid)
                            );
                        }
                    }
                }
            }
        }

        public void Import()
        {

        }
    }
}