DataTable dtTcu = GetAllTcuInfoBySdId(sdId);

             DataTable dtToesm = GetAllToesmBySdId(sdId);

             foreach (DataRow row in dtToesm.Rows)

             {

                 int toesmTcuId = ConvertHelper.ToInt32(row["toesm_manager_tcu_id"]);   //店主

                 int shopOaId = ConvertHelper.ToInt32(row["toesm_toes_oa_id"]);

                 var rows = dtTcu.AsEnumerable().Where<DataRow>(c => c.RowState != DataRowState.Deleted && c["tc_cu_shop_oa_id"].ToString() == shopOaId.ToString());

                 int rowsCount = rows.Count<DataRow>();

                 if (rows != null)

                 {

                     foreach (DataRow row2 in rows)

                     {

                         int tcuId = ConvertHelper.ToInt32(row2["tc_cuid"]);

                         if (tcuId != toesmTcuId)

                         {

                             dtTcu.Rows[dtTcu.Rows.IndexOf(row2)].Delete();

                         }

                     }

                 }

             }

             dtTcu.AcceptChanges();

             return dtTcu;