C#将sqlserver关联表拆分成主表与子表

最新推荐文章于 2021-02-02 18:31:16 发布

qq_42678477

最新推荐文章于 2021-02-02 18:31:16 发布

阅读量406

点赞数

本文链接：https://blog.csdn.net/qq_42678477/article/details/82528118

版权

        /// <summary>
        /// 拆分
        /// </summary>
        private void ReCreateJjr() {
            DataTable dtS = new DataTable();
            dtS.Columns.Add("OBJECT_ID", typeof(string));
            dtS.Columns.Add("JJR", typeof(string));
            dtS.Columns.Add("JG", typeof(string));
            dtS.Columns.Add("DZJC", typeof(string));
            //dtS.PrimaryKey = new DataColumn[] { dtS.Columns["JGBM"] };

            DataTable dtRelation = new DataTable();
            dtRelation.Columns.Add("P_OBJECT_ID", typeof(string));
            dtRelation.Columns.Add("S_OBJECT_ID", typeof(string));

            DataTable dt = MyCommon.GetDt("SELECT * FROM dbo.DZLXR", sqc.ConnectString);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow drSource = dt.Rows[i];
                object o = drSource["JJR"];
                if (DBNull.Value == o || string.IsNullOrEmpty(o.ToString())) { }
                else
                {
                    string[] items = o.ToString().Split(';');
                    foreach (string item in items)
                    {
                        string s_id = string.Format("{{{0}}}", Guid.NewGuid().ToString());
                        DataRow drS = dtS.NewRow();
                        object[] arrS = { s_id, item, drSource["JG"], drSource["DZJC"] };
                        drS.ItemArray = arrS;
                        dtS.Rows.Add(drS);

                        DataRow drR = dtRelation.NewRow();
                        object[] arrR = { drSource["OBJECT_ID"], s_id };
                        drR.ItemArray = arrR;
                        dtRelation.Rows.Add(drR);
                    }
                }
            }

            dtS.TableName = "JJR"; EUtil.CopyDtToServer(dtS, sqc, dtS.TableName, true);
            dtRelation.TableName = "DZLXR_JJR"; EUtil.CopyDtToServer(dtRelation, sqc, dtRelation.TableName, true);

            //MessageBox.Show("JJR Ok!");

        }